Query Metrics
7
Database Queries
7
Different statements
197.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.13 ms (87.33%) |
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 386354 400471 402164 418493 418513 419027 429220 429259 438486 462306 466635 491193 530594 550445 552171 552210 553889 557717 574125 574207 577836 583531 587929 588471 594613 598894 604002 614665 622427 622512 624703 628795 631828 637898 641787 648722 651883 654151 654881 655184 657536 657860 675715 676196 676215 676489 677074 678185 679296 679305 684812 687093 691676 693881 700737 705102 707741 708731 712293 716450 718587 718848 720299 721125 721756 725733 729705 730254 731931 732094 732387 734672 735379 735982 737971 738222 741553 741640 742195 744507 746753 748369 750084 755130 755576 759223 760288 761359 761384 761861 764193 764808 766517 778722 779894 780881 781019 781631 782499 787936 787941 788309 789089 795611 796859 798527 801136 805649 805650 805652 807268 807924 812958 813284 814490 818651 819442 821800 827347 827569 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (7.11%) |
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 614665 787941 807924 729705 766517 761861 760288 755130 721756 795611 577836 707741 721125 631828 637898 622512 778722 782499 798527 741553 735379 764808 748369 764193 746753 805649 491193 814490 821800 827569 819442 557717 708731 731931 737971 419027 574125 466635 716450 462306 807268 587929 796859 574207 678185 679305 693881 720299 641787 755576 750084 622427 429259 801136 732094 780881 787936 805650 730254 732387 386354 400471 418493 818651 781019 734672 725733 648722 654151 655184 657860 657536 429220 553889 705102 718848 654881 604002 805652 781631 741640 761359 735982 759223 812958 418513 550445 676489 679296 744507 402164 827347 552210 684812 651883 588471 624703 738222 530594 552171 687093 718587 676196 676215 628795 594613 598894 779894 788309 789089 813284 742195 761384 700737 712293 438486 583531 691676 675715 677074 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.75%) |
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 386354 400471 402164 418493 418513 419027 429220 429259 438486 462306 466635 491193 530594 550445 552171 552210 553889 557717 574125 574207 577836 583531 587929 588471 594613 598894 604002 614665 622427 622512 624703 628795 631828 637898 641787 648722 651883 654151 654881 655184 657536 657860 675715 676196 676215 676489 677074 678185 679296 679305 684812 687093 691676 693881 700737 705102 707741 708731 712293 716450 718587 718848 720299 721125 721756 725733 729705 730254 731931 732094 732387 734672 735379 735982 737971 738222 741553 741640 742195 744507 746753 748369 750084 755130 755576 759223 760288 761359 761384 761861 764193 764808 766517 778722 779894 780881 781019 781631 782499 787936 787941 788309 789089 795611 796859 798527 801136 805649 805650 805652 807268 807924 812958 813284 814490 818651 819442 821800 827347 827569 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 year old девушк"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18-year-old girl"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 year old девушк"
]
|
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.