Query Metrics
7
Database Queries
7
Different statements
161.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.65 ms (84.09%) |
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 252608 382017 383472 384325 384856 385042 390894 393732 393738 393745 393750 393771 395899 400422 400439 400446 400485 402081 402094 403042 403053 403060 413197 413228 452490 462288 462781 462961 463141 464145 469905 469910 512041 512043 532153 547753 549994 557064 560372 561734 562875 566509 590250 592735 605666 610232 626752 646939 663375 663882 663940 664309 665287 666164 667323 668894 669430 669446 669737 670513 676453 676924 676942 676982 677056 677697 681187 682510 682523 682538 684947 684995 688032 694132 694539 696969 702396 702852 705462 720435 720456 720504 721006 722662 722665 722670 722686 722705 723931 732135 734613 736022 741647 741650 743063 743103 743144 744790 746081 748136 759553 759591 759609 765448 766035 766578 775383 777277 778419 780713 789077 789212 789574 794702 794769 804530 810572 812127 812143 816661 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (9.03%) |
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 765448 746081 777277 393750 402094 400439 403053 469910 816661 532153 694539 702396 677056 720504 610232 590250 744790 741647 743063 722662 557064 395899 562875 605666 789077 393732 403042 413197 549994 722686 667323 676942 668894 684947 743103 789212 812143 759553 812127 462288 512041 413228 452490 676982 741650 384325 390894 665287 646939 681187 722665 722705 663882 682510 682538 722670 626752 794769 804530 732135 766578 759591 759609 748136 775383 383472 382017 400485 547753 666164 669446 669737 720435 702852 677697 682523 688032 592735 789574 723931 743144 766035 734613 720456 384856 402081 403060 393771 469905 252608 462781 560372 663940 676924 669430 670513 696969 664309 676453 684995 694132 561734 780713 810572 736022 794702 721006 778419 463141 385042 400422 663375 705462 393738 393745 400446 462961 512043 464145 566509 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (2.02%) |
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 252608 382017 383472 384325 384856 385042 390894 393732 393738 393745 393750 393771 395899 400422 400439 400446 400485 402081 402094 403042 403053 403060 413197 413228 452490 462288 462781 462961 463141 464145 469905 469910 512041 512043 532153 547753 549994 557064 560372 561734 562875 566509 590250 592735 605666 610232 626752 646939 663375 663882 663940 664309 665287 666164 667323 668894 669430 669446 669737 670513 676453 676924 676942 676982 677056 677697 681187 682510 682523 682538 684947 684995 688032 694132 694539 696969 702396 702852 705462 720435 720456 720504 721006 722662 722665 722670 722686 722705 723931 732135 734613 736022 741647 741650 743063 743103 743144 744790 746081 748136 759553 759591 759609 765448 766035 766578 775383 777277 778419 780713 789077 789212 789574 794702 794769 804530 810572 812127 812143 816661 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old девушк"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old девушк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old girl"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.