http://dev-op.amzsolution.com/chi-tiet-du-an/van-phong-duong-duc-hien.html

Query Metrics

7 Database Queries
6 Different statements
5.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.20 ms
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.client AS client_2, a0_.location AS location_3, a0_.location_detail AS location_detail_4, a0_.owner AS owner_5, a0_.area AS area_6, a0_.project_scale AS project_scale_7, a0_.scope_of_work AS scope_of_work_8, a0_.timeline AS timeline_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.post_id AS post_id_12 FROM amz_project a0_ INNER JOIN amz_post a1_ ON a0_.post_id = a1_.id WHERE a1_.type = 8 AND a1_.slug = 'van-phong-duong-duc-hien' ORDER BY a1_.display ASC LIMIT 1
Parameters:
[]
2 1.16 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.is_hot AS is_hot_13, t0.is_new AS is_new_14, t0.type AS type_15, t0.deleted AS deleted_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19, t0.gallery_id AS gallery_id_20, t0.google_seo_id AS google_seo_id_21 FROM amz_post t0 WHERE t0.id = ?
Parameters:
[
  167
]
3 0.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM amz_gallery t0 WHERE t0.id = ?
Parameters:
[
  82
]
4 0.84 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.deleted AS deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.gallery_id AS gallery_id_9 FROM amz_banner t0 WHERE t0.gallery_id = ?
Parameters:
[
  82
]
5 0.50 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.type AS type_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.parent AS parent_15 FROM amz_category t0 WHERE t0.id = ?
Parameters:
[
  17
]
6 0.26 ms
SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.updated_at AS updated_at_2, a0_.post_id AS post_id_3 FROM amz_page_page a0_ INNER JOIN amz_post a1_ ON a0_.post_id = a1_.id WHERE a1_.slug = 'footer' LIMIT 1
Parameters:
[]
7 0.16 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.is_hot AS is_hot_13, t0.is_new AS is_new_14, t0.type AS type_15, t0.deleted AS deleted_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19, t0.gallery_id AS gallery_id_20, t0.google_seo_id AS google_seo_id_21 FROM amz_post t0 WHERE t0.id = ?
Parameters:
[
  31
]

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\ProjectBundle\Entity\Project No errors.
App\AMZ\PostBundle\Entity\Post No errors.
App\AMZ\PostBundle\Entity\Category No errors.
App\AMZ\PostBundle\Entity\Gallery No errors.
App\AMZ\PostBundle\Entity\GoogleSeo No errors.
App\AMZ\PostBundle\Entity\Banner No errors.
App\AMZ\PageBundle\Entity\Page No errors.