Query Metrics
7
Database Queries
6
Different statements
16.62 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |