Query Metrics
7
Database Queries
7
Different statements
160.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.05 ms (79.18%) |
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 181905 399912 400021 400915 408460 417674 418142 420061 424362 434654 435624 436742 437496 438339 445718 447697 450969 451044 451865 461168 466467 478055 485540 498717 500299 500880 503292 504958 507737 510288 512931 524592 528385 528555 533785 533944 537379 545462 550778 556050 565501 566843 568257 569827 571304 572978 583267 584762 586028 590102 591221 609926 613521 619992 625731 631714 636969 644025 659793 666977 680242 693761 700247 703927 709559 712955 713163 713918 714079 720190 720756 726878 728153 735631 736326 736987 738471 738496 742925 744157 748624 748963 750980 756505 758826 758846 769865 772479 772606 775627 776966 777782 782585 784137 785012 785114 785510 786317 787931 788456 792796 793248 795231 797127 797570 798639 801236 801655 804712 805261 806967 806976 807260 807261 808625 811507 813002 818867 821835 827970 ] |
||||||||||||||||||||||||||||||
|
22.66 ms (14.12%) |
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 568257 400021 399912 478055 644025 565501 713918 797570 811507 445718 485540 417674 435624 424362 782585 434654 609926 798639 720190 556050 590102 451865 808625 804712 591221 566843 500880 503292 787931 537379 510288 700247 785114 806976 736987 807260 750980 728153 736326 613521 466467 795231 512931 524592 504958 785012 420061 550778 408460 436742 498717 659793 786317 758846 772606 793248 756505 758826 450969 451044 528555 418142 713163 507737 693761 748624 714079 801236 586028 447697 583267 680242 772479 738471 738496 569827 500299 438339 533944 827970 533785 181905 461168 775627 744157 797127 584762 777782 818867 720756 801655 726878 769865 785510 528385 572978 545462 631714 805261 784137 792796 806967 625731 788456 748963 813002 703927 709559 712955 619992 735631 742925 776966 666977 807261 437496 400915 821835 571304 636969 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.07%) |
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 181905 399912 400021 400915 408460 417674 418142 420061 424362 434654 435624 436742 437496 438339 445718 447697 450969 451044 451865 461168 466467 478055 485540 498717 500299 500880 503292 504958 507737 510288 512931 524592 528385 528555 533785 533944 537379 545462 550778 556050 565501 566843 568257 569827 571304 572978 583267 584762 586028 590102 591221 609926 613521 619992 625731 631714 636969 644025 659793 666977 680242 693761 700247 703927 709559 712955 713163 713918 714079 720190 720756 726878 728153 735631 736326 736987 738471 738496 742925 744157 748624 748963 750980 756505 758826 758846 769865 772479 772606 775627 776966 777782 782585 784137 785012 785114 785510 786317 787931 788456 792796 793248 795231 797127 797570 798639 801236 801655 804712 805261 806967 806976 807260 807261 808625 811507 813002 818867 821835 827970 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазм киска молодая"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оргазм вагин молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.