Query Metrics
7
Database Queries
7
Different statements
149.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.56 ms (81.76%) |
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 3793 8164 73204 386266 388127 391009 392478 392772 394013 397867 398686 398930 415039 421653 421762 423459 423471 423942 427233 427911 432470 440721 441301 452731 455165 455540 458313 459083 460076 463501 472971 487216 491046 491462 493402 493755 495032 496243 497174 509170 519598 522749 524134 539913 545114 546893 548991 573915 575539 578207 578809 579977 584722 588531 589383 590818 605675 609634 617732 617780 618629 620828 621183 626839 627326 628596 641524 653117 666468 675581 691411 691982 700379 702280 705705 707183 727649 731345 739906 740175 746342 746358 746605 748609 750458 758023 758780 759913 760241 760301 763518 765962 768577 771931 773601 778786 779266 779948 791797 794377 795198 796137 800906 800994 803301 808104 810706 816808 818097 819334 819830 823718 823841 824494 826575 827034 827632 828442 828549 828781 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (10.72%) |
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 493402 386266 816808 819830 823841 509170 618629 727649 765962 768577 808104 73204 388127 427233 421653 423459 423942 427911 421762 423471 495032 546893 545114 700379 702280 666468 707183 620828 588531 589383 779266 779948 746605 760241 795198 739906 740175 759913 763518 609634 800994 392478 398930 440721 459083 455165 491462 391009 397867 460076 524134 496243 691411 590818 627326 810706 758780 731345 748609 746358 617732 800906 3793 432470 472971 519598 493755 491046 584722 823718 826575 827034 824494 828549 573915 641524 794377 796137 803301 548991 415039 441301 819334 455540 497174 487216 579977 675581 628596 621183 746342 791797 760301 617780 705705 394013 8164 398686 392772 818097 828781 827632 828442 522749 578809 653117 691982 750458 773601 758023 771931 778786 458313 452731 539913 463501 575539 578207 605675 626839 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (2.41%) |
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 3793 8164 73204 386266 388127 391009 392478 392772 394013 397867 398686 398930 415039 421653 421762 423459 423471 423942 427233 427911 432470 440721 441301 452731 455165 455540 458313 459083 460076 463501 472971 487216 491046 491462 493402 493755 495032 496243 497174 509170 519598 522749 524134 539913 545114 546893 548991 573915 575539 578207 578809 579977 584722 588531 589383 590818 605675 609634 617732 617780 618629 620828 621183 626839 627326 628596 641524 653117 666468 675581 691411 691982 700379 702280 705705 707183 727649 731345 739906 740175 746342 746358 746605 748609 750458 758023 758780 759913 760241 760301 763518 765962 768577 771931 773601 778786 779266 779948 791797 794377 795198 796137 800906 800994 803301 808104 810706 816808 818097 819334 819830 823718 823841 824494 826575 827034 827632 828442 828549 828781 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum doggy"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum рак"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum рак"
]
|
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.