Query Metrics
7
Database Queries
7
Different statements
158.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.87 ms (85.59%) |
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 282465 394335 429257 464145 514787 515227 525444 532153 533284 539238 550539 551359 556359 564823 572932 572946 574223 592326 594014 597259 599058 603145 605822 613949 614094 616701 622540 624276 625033 626752 628767 628958 631551 635533 637609 644600 644654 649267 651882 660761 670566 678897 683359 685930 690214 700691 708612 708823 712336 713785 721561 723931 725336 725741 729720 729742 730944 732167 734081 734813 736022 736980 737370 737852 743063 745987 746371 748091 748631 748632 750086 750352 755100 758875 759195 760334 761410 762371 762472 763814 765448 766162 769128 775258 778188 778205 778835 780444 780478 783780 785486 786491 786852 789417 789641 790070 795704 796785 796857 797371 797423 798209 800317 801624 803181 805346 806031 809980 810901 812919 817184 818101 819382 821798 824449 825226 825808 826914 827126 ] |
||||||||||||||||||||||||||||||
|
11.89 ms (7.49%) |
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 700691 780444 394335 824264 539238 685930 622540 603145 732167 821798 806031 765448 708612 574223 778205 761410 760334 745987 780478 790070 626752 282465 825808 551359 515227 532153 743063 826914 827126 825226 572946 649267 660761 712336 613949 628767 785486 809980 729720 737370 795704 734081 758875 670566 723931 550539 678897 614094 775258 824449 651882 637609 755100 810901 819382 721561 683359 616701 635533 599058 778835 783780 797371 763814 789417 798209 746371 762472 748091 778188 605822 789641 734813 801624 737852 748631 759195 769128 766162 736022 464145 597259 594014 805346 429257 514787 708823 624276 736980 748632 644654 817184 818101 525444 533284 572932 556359 564823 690214 713785 592326 628958 644600 631551 796785 786491 786852 800317 812919 725336 796857 797423 803181 729742 730944 762371 725741 750352 750086 625033 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.68%) |
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 282465 394335 429257 464145 514787 515227 525444 532153 533284 539238 550539 551359 556359 564823 572932 572946 574223 592326 594014 597259 599058 603145 605822 613949 614094 616701 622540 624276 625033 626752 628767 628958 631551 635533 637609 644600 644654 649267 651882 660761 670566 678897 683359 685930 690214 700691 708612 708823 712336 713785 721561 723931 725336 725741 729720 729742 730944 732167 734081 734813 736022 736980 737370 737852 743063 745987 746371 748091 748631 748632 750086 750352 755100 758875 759195 760334 761410 762371 762472 763814 765448 766162 769128 775258 778188 778205 778835 780444 780478 783780 785486 786491 786852 789417 789641 790070 795704 796785 796857 797371 797423 798209 800317 801624 803181 805346 806031 809980 810901 812919 817184 818101 819382 821798 824449 825226 825808 826914 827126 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"year old girl"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"year old девушк"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.