Query Metrics
7
Database Queries
7
Different statements
170.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.84 ms (88.90%) |
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 391762 398874 400004 400716 410741 417154 422415 432897 450951 454534 460763 469768 487973 513511 514910 535993 539276 540975 549020 563303 564184 568531 574211 577919 578535 584260 588928 594289 594615 600696 604311 604371 608233 609289 616457 619171 622562 623289 623825 625745 625965 628801 628909 629167 634045 655132 655279 656590 659956 660340 661673 661950 684404 696100 700379 706454 709223 711672 712393 713877 714070 716603 718685 719303 720085 724091 724346 725032 728151 728360 728372 728407 734973 739403 739800 740089 740883 745069 746090 750100 751213 751925 756670 757535 761764 761814 762917 765406 765449 766883 767090 767269 769043 773678 774251 775712 776042 779979 781136 781355 783144 785510 785553 788779 788846 788857 789901 791418 792733 795303 796196 796916 798639 799446 799830 800975 804376 817280 826153 827588 ] |
||||||||||||||||||||||||||||||
|
9.03 ms (5.29%) |
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 792733 724091 728372 766883 728151 728360 728407 774251 739800 756670 761814 762917 739403 740089 746090 718685 776042 785510 804376 422415 400716 535993 398874 450951 568531 619171 410741 540975 712393 696100 594289 660340 800975 391762 417154 826153 817280 827588 513511 549020 700379 716603 720085 719303 574211 577919 779979 781136 783144 785553 796196 796916 775712 781355 789901 791418 795303 798639 745069 751213 757535 740883 750100 609289 469768 578535 656590 661673 655279 655132 659956 684404 709223 711672 714070 622562 625965 628801 628909 634045 594615 600696 588928 623825 629167 751925 563303 706454 604371 799446 799830 725032 432897 454534 400004 460763 514910 539276 564184 584260 661950 713877 608233 616457 625745 788846 788857 761764 724346 734973 765449 769043 765406 767269 767090 773678 604311 623289 788779 487973 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.55%) |
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 391762 398874 400004 400716 410741 417154 422415 432897 450951 454534 460763 469768 487973 513511 514910 535993 539276 540975 549020 563303 564184 568531 574211 577919 578535 584260 588928 594289 594615 600696 604311 604371 608233 609289 616457 619171 622562 623289 623825 625745 625965 628801 628909 629167 634045 655132 655279 656590 659956 660340 661673 661950 684404 696100 700379 706454 709223 711672 712393 713877 714070 716603 718685 719303 720085 724091 724346 725032 728151 728360 728372 728407 734973 739403 739800 740089 740883 745069 746090 750100 751213 751925 756670 757535 761764 761814 762917 765406 765449 766883 767090 767269 769043 773678 774251 775712 776042 779979 781136 781355 783144 785510 785553 788779 788846 788857 789901 791418 792733 795303 796196 796916 798639 799446 799830 800975 804376 817280 826153 827588 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie teen amateur"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie teen любительск"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie teen любительск"
]
|
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.