Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.sub_title AS sub_title_3,
  t0.url AS url_4,
  t0.thumbnail AS thumbnail_5,
  t0.image AS image_6,
  t0.slug AS slug_7,
  t0.icon AS icon_8,
  t0.sort_order AS sort_order_9,
  t0.display AS display_10,
  t0.description AS description_11,
  t0.content AS content_12,
  t0.reference_url AS reference_url_13,
  t0.is_hot AS is_hot_14,
  t0.is_new AS is_new_15,
  t0.is_home AS is_home_16,
  t0.post_type AS post_type_17,
  t0.document_file AS document_file_18,
  t0.extra_file01 AS extra_file01_19,
  t0.published AS published_20,
  t0.deleted AS deleted_21,
  t0.tag AS tag_22,
  t0.config AS config_23,
  t0.language AS language_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t27.id AS id_28,
  t27.employee_name AS employee_name_29,
  t27.business_title AS business_title_30,
  t27.code AS code_31,
  t27.email AS email_32,
  t27.phone AS phone_33,
  t27.birthday AS birthday_34,
  t27.address AS address_35,
  t27.deleted AS deleted_36,
  t27.created_at AS created_at_37,
  t27.update_at AS update_at_38,
  t27.post_id AS post_id_39,
  t27.account_id AS account_id_40,
  t27.department_id AS department_id_41,
  t42.id AS id_43,
  t42.created_at AS created_at_44,
  t42.update_at AS update_at_45,
  t42.post_id AS post_id_46,
  t47.id AS id_48,
  t47.deleted AS deleted_49,
  t47.created_at AS created_at_50,
  t47.updated_at AS updated_at_51,
  t47.user_id AS user_id_52,
  t47.post_id AS post_id_53,
  t54.id AS id_55,
  t54.google_title AS google_title_56,
  t54.google_description AS google_description_57,
  t54.google_tag AS google_tag_58,
  t54.facebook_title AS facebook_title_59,
  t54.facebook_description AS facebook_description_60,
  t54.facebook_thumbnail AS facebook_thumbnail_61,
  t54.created_at AS created_at_62,
  t54.updated_at AS updated_at_63,
  t54.post_id AS post_id_64,
  t65.id AS id_66,
  t65.name AS name_67,
  t65.deleted AS deleted_68,
  t65.css AS css_69,
  t65.custom_css AS custom_css_70,
  t65.created_at AS created_at_71,
  t65.updated_at AS updated_at_72,
  t65.post_id AS post_id_73,
  t65.block_id AS block_id_74,
  t0.category_id AS category_id_75,
  t0.gallery_id AS gallery_id_76,
  t0.gallery_alt_id AS gallery_alt_id_77
FROM
  amz_core_post t0
  LEFT JOIN amz_staff t27 ON t27.post_id = t0.id
  LEFT JOIN amz_partner t42 ON t42.post_id = t0.id
  LEFT JOIN amz_article_article t47 ON t47.post_id = t0.id
  LEFT JOIN amz_social_sharing t54 ON t54.post_id = t0.id
  LEFT JOIN amz_core_page t65 ON t65.post_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.url AS url_4, t0.thumbnail AS thumbnail_5, t0.image AS image_6, t0.slug AS slug_7, t0.icon AS icon_8, t0.sort_order AS sort_order_9, t0.display AS display_10, t0.description AS description_11, t0.content AS content_12, t0.reference_url AS reference_url_13, t0.is_hot AS is_hot_14, t0.is_new AS is_new_15, t0.is_home AS is_home_16, t0.post_type AS post_type_17, t0.document_file AS document_file_18, t0.extra_file01 AS extra_file01_19, t0.published AS published_20, t0.deleted AS deleted_21, t0.tag AS tag_22, t0.config AS config_23, t0.language AS language_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t27.id AS id_28, t27.employee_name AS employee_name_29, t27.business_title AS business_title_30, t27.code AS code_31, t27.email AS email_32, t27.phone AS phone_33, t27.birthday AS birthday_34, t27.address AS address_35, t27.deleted AS deleted_36, t27.created_at AS created_at_37, t27.update_at AS update_at_38, t27.post_id AS post_id_39, t27.account_id AS account_id_40, t27.department_id AS department_id_41, t42.id AS id_43, t42.created_at AS created_at_44, t42.update_at AS update_at_45, t42.post_id AS post_id_46, t47.id AS id_48, t47.deleted AS deleted_49, t47.created_at AS created_at_50, t47.updated_at AS updated_at_51, t47.user_id AS user_id_52, t47.post_id AS post_id_53, t54.id AS id_55, t54.google_title AS google_title_56, t54.google_description AS google_description_57, t54.google_tag AS google_tag_58, t54.facebook_title AS facebook_title_59, t54.facebook_description AS facebook_description_60, t54.facebook_thumbnail AS facebook_thumbnail_61, t54.created_at AS created_at_62, t54.updated_at AS updated_at_63, t54.post_id AS post_id_64, t65.id AS id_66, t65.name AS name_67, t65.deleted AS deleted_68, t65.css AS css_69, t65.custom_css AS custom_css_70, t65.created_at AS created_at_71, t65.updated_at AS updated_at_72, t65.post_id AS post_id_73, t65.block_id AS block_id_74, t0.category_id AS category_id_75, t0.gallery_id AS gallery_id_76, t0.gallery_alt_id AS gallery_alt_id_77 FROM amz_core_post t0 LEFT JOIN amz_staff t27 ON t27.post_id = t0.id LEFT JOIN amz_partner t42 ON t42.post_id = t0.id LEFT JOIN amz_article_article t47 ON t47.post_id = t0.id LEFT JOIN amz_social_sharing t54 ON t54.post_id = t0.id LEFT JOIN amz_core_page t65 ON t65.post_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.google_title AS google_title_2,
  t0.google_description AS google_description_3,
  t0.google_tag AS google_tag_4,
  t0.facebook_title AS facebook_title_5,
  t0.facebook_description AS facebook_description_6,
  t0.facebook_thumbnail AS facebook_thumbnail_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.post_id AS post_id_10
FROM
  amz_social_sharing t0
WHERE
  t0.post_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.google_title AS google_title_2, t0.google_description AS google_description_3, t0.google_tag AS google_tag_4, t0.facebook_title AS facebook_title_5, t0.facebook_description AS facebook_description_6, t0.facebook_thumbnail AS facebook_thumbnail_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.post_id AS post_id_10 FROM amz_social_sharing t0 WHERE t0.post_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.icon AS icon_5,
  t0.url AS url_6,
  t0.display AS display_7,
  t0.is_root AS is_root_8,
  t0.sort_order AS sort_order_9,
  t0.language AS language_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.parent AS parent_13,
  t0.author_id AS author_id_14
FROM
  amz_core_menu t0
WHERE
  t0.parent = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.icon AS icon_5, t0.url AS url_6, t0.display AS display_7, t0.is_root AS is_root_8, t0.sort_order AS sort_order_9, t0.language AS language_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.parent AS parent_13, t0.author_id AS author_id_14 FROM amz_core_menu t0 WHERE t0.parent = 5;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.icon AS icon_5,
  t0.url AS url_6,
  t0.display AS display_7,
  t0.is_root AS is_root_8,
  t0.sort_order AS sort_order_9,
  t0.language AS language_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.parent AS parent_13,
  t0.author_id AS author_id_14
FROM
  amz_core_menu t0
WHERE
  t0.position = ?
  AND t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.icon AS icon_5, t0.url AS url_6, t0.display AS display_7, t0.is_root AS is_root_8, t0.sort_order AS sort_order_9, t0.language AS language_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.parent AS parent_13, t0.author_id AS author_id_14 FROM amz_core_menu t0 WHERE t0.position = 'header' AND t0.language = 'vi' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3,
  t0.setting_type AS setting_type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  amz_core_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM amz_core_setting t0 WHERE t0.setting_key = 'script-setting' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sort_order AS sort_order_2,
  t0.title AS title_3,
  t0.sub_title AS sub_title_4,
  t0.description AS description_5,
  t0.content AS content_6,
  t0.slug AS slug_7,
  t0.image_icon AS image_icon_8,
  t0.image AS image_9,
  t0.background AS background_10,
  t0.mobile_background AS mobile_background_11,
  t0.image_on_right AS image_on_right_12,
  t0.type AS type_13,
  t0.text_icon AS text_icon_14,
  t0.url AS url_15,
  t0.location AS location_16,
  t0.video_url AS video_url_17,
  t0.kind AS kind_18,
  t0.active AS active_19,
  t0.created_at AS created_at_20,
  t0.update_at AS update_at_21,
  t0.page_id AS page_id_22,
  t0.post_id AS post_id_23
FROM
  amz_block_content t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.description AS description_5, t0.content AS content_6, t0.slug AS slug_7, t0.image_icon AS image_icon_8, t0.image AS image_9, t0.background AS background_10, t0.mobile_background AS mobile_background_11, t0.image_on_right AS image_on_right_12, t0.type AS type_13, t0.text_icon AS text_icon_14, t0.url AS url_15, t0.location AS location_16, t0.video_url AS video_url_17, t0.kind AS kind_18, t0.active AS active_19, t0.created_at AS created_at_20, t0.update_at AS update_at_21, t0.page_id AS page_id_22, t0.post_id AS post_id_23 FROM amz_block_content t0 WHERE t0.post_id = 1 ORDER BY t0.sort_order ASC;

SELECT
  a0_.id AS id_0,
  a0_.type AS type_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.post_id AS post_id_4
FROM
  amz_testimonial a0_
  LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id
WHERE
  a1_.deleted = 'normal'
  AND a1_.language = 'vi'
  AND a0_.type = 'testimonial_type_school'

SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.post_id AS post_id_4 FROM amz_testimonial a0_ LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id WHERE a1_.deleted = 'normal' AND a1_.language = 'vi' AND a0_.type = 'testimonial_type_school';

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.deleted AS deleted_2,
  a0_.css AS css_3,
  a0_.custom_css AS custom_css_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.post_id AS post_id_7,
  a0_.block_id AS block_id_8
FROM
  amz_core_page a0_
  LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id
WHERE
  a0_.deleted = 'normal'
  AND a1_.slug = 'trang-chu'
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.deleted AS deleted_2, a0_.css AS css_3, a0_.custom_css AS custom_css_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.post_id AS post_id_7, a0_.block_id AS block_id_8 FROM amz_core_page a0_ LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id WHERE a0_.deleted = 'normal' AND a1_.slug = 'trang-chu' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.deleted AS deleted_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.user_id AS user_id_4,
  a0_.post_id AS post_id_5
FROM
  amz_article_article a0_
  LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id
WHERE
  a1_.deleted = 'normal'
  AND a1_.published = 'published'
  AND a1_.is_hot = 'post_status_hot_type_hot'
  AND a0_.deleted = 'normal'

SELECT a0_.id AS id_0, a0_.deleted AS deleted_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.user_id AS user_id_4, a0_.post_id AS post_id_5 FROM amz_article_article a0_ LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id WHERE a1_.deleted = 'normal' AND a1_.published = 'published' AND a1_.is_hot = 'post_status_hot_type_hot' AND a0_.deleted = 'normal';

SELECT
  a0_.id AS id_0,
  a0_.type AS type_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  a0_.post_id AS post_id_4
FROM
  amz_testimonial a0_
  LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id
WHERE
  a1_.deleted = 'normal'
  AND a1_.language = 'vi'
  AND a0_.type = 'testimonial_type_user'

SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.post_id AS post_id_4 FROM amz_testimonial a0_ LEFT JOIN amz_core_post a1_ ON a0_.post_id = a1_.id WHERE a1_.deleted = 'normal' AND a1_.language = 'vi' AND a0_.type = 'testimonial_type_user';