Query Metrics
140
Database Queries
15
Different statements
23.25 ms
Query time
5
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.50 ms (40.84%) |
71 |
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:
[ "173" "en" "App\AMZ\Core\Entity\Post" ] |
|
6.23 ms (26.80%) |
31 |
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
]
|
|
1.53 ms (6.56%) |
11 |
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"
]
|
|
1.33 ms (5.70%) |
10 |
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
]
|
|
1.12 ms (4.80%) |
2 |
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:
[
"ismart-what-s-new"
]
|
|
0.99 ms (4.25%) |
5 |
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" ] |
|
0.94 ms (4.03%) |
1 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
|
0.34 ms (1.46%) |
2 |
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
]
|
|
0.24 ms (1.01%) |
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
Parameters:
[
173
]
|
|
0.23 ms (1.00%) |
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 LEFT JOIN amz_core_category a2_ ON a1_.category_id = a2_.id WHERE a1_.deleted = 'normal' AND a1_.is_hot = 'post_status_hot_type_hot' AND a1_.published = 'published' ORDER BY a1_.sort_order DESC
Parameters:
[] |
|
0.20 ms (0.85%) |
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 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 6
Parameters:
[] |
|
0.19 ms (0.81%) |
1 |
SELECT a0_.id AS id_0, a0_.image AS image_1, a0_.title AS title_2, a0_.sub_title AS sub_title_3, a0_.link AS link_4, a0_.created_at AS created_at_5, a0_.update_at AS update_at_6, a0_.gallery_id AS gallery_id_7 FROM amz_picture a0_ LEFT JOIN amz_gallery a1_ ON a0_.gallery_id = a1_.id WHERE a1_.id = 81
Parameters:
[] |
|
0.15 ms (0.65%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.css AS css_4, t0.custom_css AS custom_css_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.post_id AS post_id_8, t0.block_id AS block_id_9 FROM amz_core_page t0 WHERE t0.post_id = ? LIMIT 1
Parameters:
[
173
]
|
|
0.14 ms (0.62%) |
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 LEFT JOIN amz_core_category a2_ ON a1_.category_id = a2_.id WHERE a1_.deleted = 'normal' AND a2_.id = 3 AND a1_.published = 'published' ORDER BY a1_.sort_order DESC LIMIT 6
Parameters:
[] |
|
0.14 ms (0.61%) |
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
Parameters:
[
173
]
|
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. |
| App\Backend\Picture\Entity\Picture | No errors. |