http://dev-op.amzsolution.com/tin-tuc

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.83 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 = 'tin-tuc' LIMIT 1
Parameters:
[]
2 5.46 ms
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM amz_post a0_ INNER JOIN amz_category a1_ ON a0_.category_id = a1_.id WHERE a1_.slug = 'bai-viet' AND a0_.deleted = 0 AND a0_.type = 1
Parameters:
[]
3 1.90 ms
SELECT DISTINCT a0_.id AS id_0, a0_.id AS id_1 FROM amz_post a0_ INNER JOIN amz_category a1_ ON a0_.category_id = a1_.id WHERE a1_.slug = 'bai-viet' AND a0_.deleted = 0 AND a0_.type = 1 ORDER BY a0_.id DESC LIMIT 8
Parameters:
[]
4 6.70 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.sub_title AS sub_title_2, a0_.url AS url_3, a0_.thumbnail AS thumbnail_4, a0_.image AS image_5, a0_.slug AS slug_6, a0_.icon AS icon_7, a0_.sort_order AS sort_order_8, a0_.display AS display_9, a0_.description AS description_10, a0_.content AS content_11, a0_.is_hot AS is_hot_12, a0_.is_new AS is_new_13, a0_.type AS type_14, a0_.deleted AS deleted_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.category_id AS category_id_18, a0_.gallery_id AS gallery_id_19, a0_.google_seo_id AS google_seo_id_20 FROM amz_post a0_ INNER JOIN amz_category a1_ ON a0_.category_id = a1_.id WHERE a1_.slug = 'bai-viet' AND a0_.deleted = 0 AND a0_.type = 1 AND a0_.id IN (?) ORDER BY a0_.id DESC
Parameters:
[
  [
    "185"
    "184"
    "183"
    "182"
    "181"
    "180"
    "179"
    "178"
  ]
]
5 1.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:
[
  10
]
6 0.28 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.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\PostBundle\Entity\Category No errors.
App\AMZ\PostBundle\Entity\Gallery No errors.
App\AMZ\PostBundle\Entity\GoogleSeo No errors.