Query Metrics
5
Database Queries
5
Different statements
1278.81 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.69 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
| 2 | 629.52 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.type = ? AND p.status = ? AND p.sexual_orientation = ? ORDER BY published_at DESC LIMIT 120 OFFSET 960
Parameters:
[ 1 2 0 10 0 ] |
| 3 | 3.07 ms |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 829534 829058 821360 823476 821367 833978 829877 833772 821347 827648 827276 826276 830185 821147 826410 819867 831883 832667 831017 831733 819150 828607 831571 825805 819876 823588 832261 824466 830786 825342 824268 819457 831157 827999 820920 827183 832230 823392 829791 823851 826633 829429 833043 820157 820325 824645 827751 832612 826267 829666 830823 819228 826533 826878 827662 833256 821870 820167 820023 833619 824535 826680 821420 833943 824418 828224 831326 824656 825989 828590 833157 821194 831577 829037 819597 830414 825245 831973 825799 823673 823473 827434 825194 828851 826829 822946 819728 833476 820792 828540 826165 823481 821069 819342 827690 832165 823860 819022 833769 833587 828083 819761 824238 829700 830694 818916 818377 828790 826987 828698 820013 829365 831710 827903 827852 827892 828034 829533 832093 825921 ] |
| 4 | 144.44 ms |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 829534 829058 821360 823476 821367 833978 829877 833772 821347 827648 827276 826276 830185 821147 826410 819867 831883 832667 831017 831733 819150 828607 831571 825805 819876 823588 832261 824466 830786 825342 824268 819457 831157 827999 820920 827183 832230 823392 829791 823851 826633 829429 833043 820157 820325 824645 827751 832612 826267 829666 830823 819228 826533 826878 827662 833256 821870 820167 820023 833619 824535 826680 821420 833943 824418 828224 831326 824656 825989 828590 833157 821194 831577 829037 819597 830414 825245 831973 825799 823673 823473 827434 825194 828851 826829 822946 819728 833476 820792 828540 826165 823481 821069 819342 827690 832165 823860 819022 833769 833587 828083 819761 824238 829700 830694 818916 818377 828790 826987 828698 820013 829365 831710 827903 827852 827892 828034 829533 832093 825921 ] |
| 5 | 500.08 ms |
SELECT COUNT(*) FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.type = ? AND p.status = ? AND p.sexual_orientation = ?
Parameters:
[ 1 2 0 10 0 ] |
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
No loaded entities.