Query Metrics
86
Database Queries
11
Different statements
20.15 ms
Query time
5
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.35 ms |
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.slug = ? LIMIT 1
Parameters:
[
"i-green-2024-for-halo-no-trash-tro-tai-hoa-than-tai-che-cuc-chat-cung-ismart"
]
|
| 2 | 0.33 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "280" "en" "App\AMZ\Core\Entity\Post" ] |
| 3 | 0.39 ms |
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
Parameters:
[
280
]
|
| 4 | 0.29 ms |
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
Parameters:
[
"google-tag-manager-id"
]
|
| 5 | 0.16 ms |
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
Parameters:
[
"script-setting"
]
|
| 6 | 0.29 ms |
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
Parameters:
[
"header-logo"
]
|
| 7 | 0.35 ms |
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
Parameters:
[ "header" "en" ] |
| 8 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "33" "en" "App\AMZ\Core\Entity\Menu" ] |
| 9 | 0.22 ms |
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 = ?
Parameters:
[
33
]
|
| 10 | 0.17 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "34" "en" "App\AMZ\Core\Entity\Menu" ] |
| 11 | 0.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "35" "en" "App\AMZ\Core\Entity\Menu" ] |
| 12 | 0.15 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "36" "en" "App\AMZ\Core\Entity\Menu" ] |
| 13 | 0.24 ms |
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
Parameters:
[ "main" "en" ] |
| 14 | 0.22 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "37" "en" "App\AMZ\Core\Entity\Menu" ] |
| 15 | 0.23 ms |
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 = ?
Parameters:
[
37
]
|
| 16 | 0.22 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "38" "en" "App\AMZ\Core\Entity\Menu" ] |
| 17 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "42" "en" "App\AMZ\Core\Entity\Menu" ] |
| 18 | 0.17 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "43" "en" "App\AMZ\Core\Entity\Menu" ] |
| 19 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "44" "en" "App\AMZ\Core\Entity\Menu" ] |
| 20 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "45" "en" "App\AMZ\Core\Entity\Menu" ] |
| 21 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "46" "en" "App\AMZ\Core\Entity\Menu" ] |
| 22 | 0.15 ms |
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 = ?
Parameters:
[
38
]
|
| 23 | 0.17 ms |
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 = ?
Parameters:
[
42
]
|
| 24 | 0.17 ms |
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 = ?
Parameters:
[
43
]
|
| 25 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "47" "en" "App\AMZ\Core\Entity\Menu" ] |
| 26 | 0.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "48" "en" "App\AMZ\Core\Entity\Menu" ] |
| 27 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "49" "en" "App\AMZ\Core\Entity\Menu" ] |
| 28 | 0.15 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "50" "en" "App\AMZ\Core\Entity\Menu" ] |
| 29 | 0.20 ms |
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 = ?
Parameters:
[
44
]
|
| 30 | 0.22 ms |
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 = ?
Parameters:
[
45
]
|
| 31 | 0.20 ms |
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 = ?
Parameters:
[
46
]
|
| 32 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.thumbnail AS thumbnail_5, t0.description AS description_6, t0.sort_order AS sort_order_7, t0.display AS display_8, t0.deleted AS deleted_9, t0.level AS level_10, t0.hot AS hot_11, t0.menu AS menu_12, t0.post_type AS post_type_13, t0.custom_path AS custom_path_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent AS parent_17 FROM amz_core_category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 33 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "2" "en" "App\AMZ\Core\Entity\Category" ] |
| 34 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.thumbnail AS thumbnail_5, t0.description AS description_6, t0.sort_order AS sort_order_7, t0.display AS display_8, t0.deleted AS deleted_9, t0.level AS level_10, t0.hot AS hot_11, t0.menu AS menu_12, t0.post_type AS post_type_13, t0.custom_path AS custom_path_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.parent AS parent_17 FROM amz_core_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 35 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1" "en" "App\AMZ\Core\Entity\Category" ] |
| 36 | 0.54 ms |
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' LIMIT 4
Parameters:
[] |
| 37 | 0.39 ms |
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 = ?
Parameters:
[
97
]
|
| 38 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "97" "en" "App\AMZ\Core\Entity\Post" ] |
| 39 | 0.25 ms |
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 = ?
Parameters:
[
109
]
|
| 40 | 0.15 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "109" "en" "App\AMZ\Core\Entity\Post" ] |
| 41 | 0.24 ms |
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 = ?
Parameters:
[
110
]
|
| 42 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "110" "en" "App\AMZ\Core\Entity\Post" ] |
| 43 | 0.21 ms |
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 = ?
Parameters:
[
111
]
|
| 44 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "111" "en" "App\AMZ\Core\Entity\Post" ] |
| 45 | 0.24 ms |
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 LEFT JOIN amz_core_category a2_ ON a1_.category_id = a2_.id WHERE a1_.deleted = 'normal' AND a1_.is_new = 'post_status_new_type_new' AND a1_.published = 'published' ORDER BY a1_.sort_order DESC LIMIT 3
Parameters:
[] |
| 46 | 0.41 ms |
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 = ?
Parameters:
[
347
]
|
| 47 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "347" "en" "App\AMZ\Core\Entity\Post" ] |
| 48 | 0.33 ms |
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 = ?
Parameters:
[
294
]
|
| 49 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "294" "en" "App\AMZ\Core\Entity\Post" ] |
| 50 | 0.39 ms |
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 = ?
Parameters:
[
292
]
|
| 51 | 0.28 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "292" "en" "App\AMZ\Core\Entity\Post" ] |
| 52 | 0.21 ms |
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 LEFT JOIN amz_core_category a2_ ON a1_.category_id = a2_.id WHERE a1_.deleted = 'normal' AND a2_.id = 2 AND a1_.published = 'published' ORDER BY a1_.sort_order DESC LIMIT 3
Parameters:
[] |
| 53 | 0.34 ms |
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 = ?
Parameters:
[
375
]
|
| 54 | 0.22 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "375" "en" "App\AMZ\Core\Entity\Post" ] |
| 55 | 0.68 ms |
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 = ?
Parameters:
[
374
]
|
| 56 | 0.24 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "374" "en" "App\AMZ\Core\Entity\Post" ] |
| 57 | 0.32 ms |
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 = ?
Parameters:
[
372
]
|
| 58 | 0.25 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "372" "en" "App\AMZ\Core\Entity\Post" ] |
| 59 | 0.21 ms |
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
Parameters:
[
"hotline"
]
|
| 60 | 0.19 ms |
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
Parameters:
[
"facebook-messenger"
]
|
| 61 | 0.42 ms |
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
Parameters:
[
"form-note-en"
]
|
| 62 | 0.19 ms |
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
Parameters:
[ "left-footer" "en" ] |
| 63 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "39" "en" "App\AMZ\Core\Entity\Menu" ] |
| 64 | 0.18 ms |
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 = ?
Parameters:
[
39
]
|
| 65 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "51" "en" "App\AMZ\Core\Entity\Menu" ] |
| 66 | 0.17 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "52" "en" "App\AMZ\Core\Entity\Menu" ] |
| 67 | 0.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "53" "en" "App\AMZ\Core\Entity\Menu" ] |
| 68 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "54" "en" "App\AMZ\Core\Entity\Menu" ] |
| 69 | 0.16 ms |
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
Parameters:
[ "middle-footer" "en" ] |
| 70 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "40" "en" "App\AMZ\Core\Entity\Menu" ] |
| 71 | 0.16 ms |
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 = ?
Parameters:
[
40
]
|
| 72 | 0.14 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "55" "en" "App\AMZ\Core\Entity\Menu" ] |
| 73 | 0.17 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "56" "en" "App\AMZ\Core\Entity\Menu" ] |
| 74 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "57" "en" "App\AMZ\Core\Entity\Menu" ] |
| 75 | 0.14 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "58" "en" "App\AMZ\Core\Entity\Menu" ] |
| 76 | 0.16 ms |
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
Parameters:
[ "right-footer" "en" ] |
| 77 | 0.17 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "41" "en" "App\AMZ\Core\Entity\Menu" ] |
| 78 | 0.19 ms |
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 = ?
Parameters:
[
41
]
|
| 79 | 0.15 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "59" "en" "App\AMZ\Core\Entity\Menu" ] |
| 80 | 0.17 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "60" "en" "App\AMZ\Core\Entity\Menu" ] |
| 81 | 0.19 ms |
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
Parameters:
[
"facebook"
]
|
| 82 | 0.17 ms |
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
Parameters:
[
"youtube"
]
|
| 83 | 0.16 ms |
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
Parameters:
[
"instagram"
]
|
| 84 | 0.16 ms |
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
Parameters:
[
"zalo"
]
|
| 85 | 0.23 ms |
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
Parameters:
[
"footer-logo"
]
|
| 86 | 0.20 ms |
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
Parameters:
[
"gcn-footer-en"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\AMZ\Core\Entity\Post |
|
| App\Backend\StaffBundle\Entity\Staff | No errors. |
| App\Backend\Account\Entity\User | No errors. |
| App\Backend\StaffBundle\Entity\Department | No errors. |
| App\Backend\PartnerBundle\Entity\Partner | No errors. |
| App\Backend\Article\Entity\Article |
|
| App\Backend\SocialBundle\Entity\SocialSharing | No errors. |
| App\AMZ\Core\Entity\Page |
|
| App\AMZ\Core\Entity\Block |
|
| App\AMZ\Core\Entity\Category | No errors. |
| App\Backend\Gallery\Entity\Gallery |
|
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| App\AMZ\Core\Entity\Setting | No errors. |
| App\AMZ\Core\Entity\Menu | No errors. |