Query Metrics
7
Database Queries
7
Different statements
225.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.59 ms (89.54%) |
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 400483 416880 417102 418138 422733 423697 435746 443031 443311 446666 448851 449450 450326 450787 451108 451333 452326 453061 454402 455495 455620 455979 456954 458326 458787 460093 463313 463411 463966 470067 471326 471328 472683 475624 477858 478060 485290 485785 487975 492312 494325 499529 501830 504320 504848 506118 509137 511216 511953 514655 516510 516613 517676 520823 523666 523937 526415 530303 543351 551612 555799 558261 558606 560002 560613 561344 561492 572250 572268 573267 573453 573789 576179 578705 579128 579279 579390 579631 585276 585703 585752 589793 590917 591108 592989 598840 599734 600653 600859 601170 604677 606765 612387 614773 618332 621745 622257 628289 633934 635723 637172 650276 650742 665822 667810 671426 686596 687929 689004 702007 718455 719388 729678 729826 730975 753752 760610 775487 792614 814753 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (5.75%) |
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 579631 573267 687929 667810 719388 560613 572268 573789 599734 621745 589793 475624 471326 418138 450326 471328 460093 463966 511216 514655 523937 485785 523666 417102 455495 450787 455620 463313 478060 511953 509137 517676 516613 530303 543351 572250 665822 598840 600859 592989 633934 753752 400483 458326 451333 504320 579279 499529 449450 516510 573453 551612 760610 422733 504848 477858 558606 560002 637172 792614 448851 470067 492312 814753 456954 458787 506118 561492 650276 718455 686596 702007 671426 578705 579128 585276 604677 618332 585752 591108 606765 612387 635723 590917 600653 622257 729678 730975 729826 614773 628289 775487 446666 453061 501830 526415 423697 452326 463411 451108 487975 561344 555799 576179 650742 689004 585703 601170 443311 435746 443031 520823 416880 455979 454402 485290 494325 472683 558261 579390 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"watching girl"
]
|
||||||||||||||||||||||||||||||
|
2.48 ms (1.10%) |
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 400483 416880 417102 418138 422733 423697 435746 443031 443311 446666 448851 449450 450326 450787 451108 451333 452326 453061 454402 455495 455620 455979 456954 458326 458787 460093 463313 463411 463966 470067 471326 471328 472683 475624 477858 478060 485290 485785 487975 492312 494325 499529 501830 504320 504848 506118 509137 511216 511953 514655 516510 516613 517676 520823 523666 523937 526415 530303 543351 551612 555799 558261 558606 560002 560613 561344 561492 572250 572268 573267 573453 573789 576179 578705 579128 579279 579390 579631 585276 585703 585752 589793 590917 591108 592989 598840 599734 600653 600859 601170 604677 606765 612387 614773 618332 621745 622257 628289 633934 635723 637172 650276 650742 665822 667810 671426 686596 687929 689004 702007 718455 719388 729678 729826 730975 753752 760610 775487 792614 814753 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watching девушк"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"watching девушк"
]
|
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.