Query Metrics
7
Database Queries
7
Different statements
207.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.89 ms (87.78%) |
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 195768 202846 385880 385991 394639 398073 407438 408885 409357 415755 420144 425412 450583 450840 450842 454140 462928 465603 465677 466768 467067 467085 468372 469092 469106 469142 472907 473454 475431 475699 477759 483484 483485 494247 495499 496514 496646 502472 511014 514726 522174 529713 529943 530144 530405 531850 532448 532806 532886 533642 533711 534586 535387 535775 539557 541845 544799 545345 547009 547858 550597 554803 554997 555014 557606 558179 560409 561034 561519 569558 575973 576176 576517 576545 577284 578693 580577 586081 588387 589697 591003 593041 595609 601798 602260 604936 606060 614835 614836 641997 655298 664193 669370 710461 710523 711591 749084 749087 752613 770107 781332 787516 793053 795718 800473 800542 800733 800753 800754 808725 812539 814182 822930 823884 824577 825365 825514 827496 827502 827693 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (7.23%) |
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 407438 825514 462928 450583 473454 514726 494247 502472 529943 532448 531850 469142 472907 547858 561519 576176 577284 580577 576517 710523 557606 569558 588387 614835 593041 800473 749084 808725 466768 398073 415755 496646 535387 641997 425412 450840 475431 467067 468372 475699 529713 532886 533642 541845 575973 554803 544799 655298 711591 669370 664193 710461 604936 586081 614836 781332 793053 800753 812539 787516 800542 800754 770107 752613 795718 800733 469106 450842 420144 465677 495499 589697 749087 522174 454140 483484 408885 477759 560409 558179 602260 530144 511014 496514 555014 578693 545345 547009 550597 595609 601798 606060 394639 469092 534586 561034 554997 576545 591003 385880 385991 195768 202846 409357 814182 823884 827502 827496 827693 822930 825365 824577 467085 483485 465603 530405 535775 539557 532806 533711 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.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 195768 202846 385880 385991 394639 398073 407438 408885 409357 415755 420144 425412 450583 450840 450842 454140 462928 465603 465677 466768 467067 467085 468372 469092 469106 469142 472907 473454 475431 475699 477759 483484 483485 494247 495499 496514 496646 502472 511014 514726 522174 529713 529943 530144 530405 531850 532448 532806 532886 533642 533711 534586 535387 535775 539557 541845 544799 545345 547009 547858 550597 554803 554997 555014 557606 558179 560409 561034 561519 569558 575973 576176 576517 576545 577284 578693 580577 586081 588387 589697 591003 593041 595609 601798 602260 604936 606060 614835 614836 641997 655298 664193 669370 710461 710523 711591 749084 749087 752613 770107 781332 787516 793053 795718 800473 800542 800733 800753 800754 808725 812539 814182 822930 823884 824577 825365 825514 827496 827502 827693 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo mature ass"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.