Query Metrics
15
Database Queries
7
Different statements
3.71 ms
Query time
5
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.03 ms (27.90%) |
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:
[
1
]
|
|
0.90 ms (24.36%) |
7 |
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:
[
5
]
|
|
0.46 ms (12.40%) |
2 |
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" "vi" ] |
|
0.45 ms (12.13%) |
2 |
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"
]
|
|
0.44 ms (11.81%) |
1 |
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:
[
1
]
|
|
0.24 ms (6.52%) |
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:
[
1
]
|
|
0.18 ms (4.88%) |
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
Parameters:
[] |
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\Page |
|
| App\AMZ\Core\Entity\Post |
|
| App\AMZ\Core\Entity\Block |
|
| App\Backend\SocialBundle\Entity\SocialSharing | No errors. |
| 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\AMZ\Core\Entity\Category | No errors. |
| App\Backend\Gallery\Entity\Gallery |
|
| App\AMZ\Core\Entity\Setting | No errors. |
| App\AMZ\Core\Entity\Menu | No errors. |