Query Metrics
7
Database Queries
7
Different statements
175.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.93 ms (86.60%) |
1 |
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 143302 191485 384282 394186 400438 417099 419066 421574 425205 436682 440647 442415 445199 446791 453965 454195 456732 458149 458904 460881 464565 465088 466144 467172 467263 468116 470858 473789 485841 489534 490584 491600 491981 497568 497761 502460 503763 505083 506181 511218 512593 512713 518286 523519 523700 524086 527693 529245 530548 535037 541916 549551 552237 555651 559395 561300 563022 563523 563645 569991 570419 571036 572030 572314 573961 581742 581987 583716 585162 585494 590375 590706 591782 599146 599640 601939 606892 608160 608363 609743 610823 623790 625108 626220 639330 650725 650781 654275 664655 676459 679447 693849 701875 710320 710638 711537 711673 714411 720390 722861 722895 731060 751958 756289 761373 771155 774293 779423 782246 782610 791712 802206 802652 803244 803522 805543 807187 810937 811072 824326 ] |
||||||||||||||||||||||||||||||
|
14.85 ms (8.46%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, 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.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 664655 610823 802206 761373 625108 782246 467172 559395 756289 419066 711537 650725 585494 802652 731060 453965 714411 676459 771155 824326 552237 570419 720390 490584 563645 650781 693849 722861 722895 679447 608160 639330 489534 491981 421574 524086 535037 581742 569991 585162 810937 460881 467263 394186 384282 491600 465088 563523 711673 599640 608363 779423 803522 458149 506181 527693 436682 454195 572030 583716 701875 561300 563022 623790 599146 591782 791712 803244 456732 400438 446791 445199 512593 440647 511218 503763 549551 571036 581987 458904 468116 523519 523700 485841 505083 555651 751958 425205 442415 417099 464565 497761 502460 654275 807187 710320 626220 805543 811072 497568 191485 782610 774293 541916 573961 601939 590375 470858 530548 572314 590706 609743 143302 512713 529245 518286 710638 606892 473789 466144 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.45%) |
1 |
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 143302 191485 384282 394186 400438 417099 419066 421574 425205 436682 440647 442415 445199 446791 453965 454195 456732 458149 458904 460881 464565 465088 466144 467172 467263 468116 470858 473789 485841 489534 490584 491600 491981 497568 497761 502460 503763 505083 506181 511218 512593 512713 518286 523519 523700 524086 527693 529245 530548 535037 541916 549551 552237 555651 559395 561300 563022 563523 563645 569991 570419 571036 572030 572314 573961 581742 581987 583716 585162 585494 590375 590706 591782 599146 599640 601939 606892 608160 608363 609743 610823 623790 625108 626220 639330 650725 650781 654275 664655 676459 679447 693849 701875 710320 710638 711537 711673 714411 720390 722861 722895 731060 751958 756289 761373 771155 774293 779423 782246 782610 791712 802206 802652 803244 803522 805543 807187 810937 811072 824326 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"have sex"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"have секс"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"have секс"
]
|
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.