http://dev-op.amzsolution.com/ve-chung-toi

Query Metrics

22 Database Queries
8 Different statements
10.20 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.79 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 = 'we-propose' LIMIT 1
Parameters:
[]
2 1.55 ms
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.price AS price_2, a0_.deleted AS deleted_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.post_id AS post_id_6 FROM amz_service a0_
Parameters:
[]
3 1.39 ms
SELECT a0_.id AS id_0, a0_.author AS author_1, a0_.post_id AS post_id_2 FROM amz_post_testimonial a0_
Parameters:
[]
4 0.44 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 = 'our-basic' LIMIT 1
Parameters:
[]
5 0.29 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 = 'services' LIMIT 1
Parameters:
[]
6 0.29 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 = 'testimonials' LIMIT 1
Parameters:
[]
7 1.20 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:
[
  13
]
8 0.31 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:
[
  27
]
9 0.31 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:
[
  29
]
10 0.28 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:
[
  14
]
11 0.30 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:
[
  15
]
12 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.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:
[
  16
]
13 0.28 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:
[
  17
]
14 0.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.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:
[
  18
]
15 0.28 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:
[
  19
]
16 0.27 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:
[
  30
]
17 0.28 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:
[
  20
]
18 0.36 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:
[
  21
]
19 0.31 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:
[
  22
]
20 0.30 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:
[
  23
]
21 0.13 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:
[]
22 0.15 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\PageBundle\Entity\Page No errors.
App\AMZ\PostBundle\Entity\Post No errors.
App\AMZ\ProductBundle\Entity\Service No errors.
App\AMZ\PostBundle\Entity\Testimonial No errors.
App\AMZ\PostBundle\Entity\Category No errors.
App\AMZ\PostBundle\Entity\Gallery No errors.
App\AMZ\PostBundle\Entity\GoogleSeo No errors.