Query Metrics
7
Database Queries
7
Different statements
575.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.20 ms (36.84%) |
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 95700 161528 188028 383625 383980 386545 387104 387448 388645 388891 391678 396040 396519 396814 397647 398912 399423 401640 408188 409114 409946 410321 425588 433391 435162 442912 451493 481253 494384 497701 516229 518449 518911 529498 529857 530451 558899 561999 563945 565272 577079 600233 604208 604667 617456 634559 634947 646946 649859 651837 665745 673996 691561 693535 696358 698038 698496 700669 712333 712728 718538 726130 726610 731836 740473 742362 742588 746325 756104 761510 765391 765480 765770 765915 766820 769887 770113 770830 774144 774188 775377 777491 778372 782506 782650 786174 787554 790518 790821 790900 791932 794533 800329 800713 801225 801297 801338 803046 805706 808052 811121 812941 813399 816538 816944 817308 818909 819480 820568 820875 820921 821056 821154 822717 823041 823240 823293 823444 827325 827984 ] |
||||||||||||||||||||||||||||||
|
205.48 ms (35.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex boobs anal"
]
|
||||||||||||||||||||||||||||||
|
140.07 ms (24.32%) |
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 95700 161528 188028 383625 383980 386545 387104 387448 388645 388891 391678 396040 396519 396814 397647 398912 399423 401640 408188 409114 409946 410321 425588 433391 435162 442912 451493 481253 494384 497701 516229 518449 518911 529498 529857 530451 558899 561999 563945 565272 577079 600233 604208 604667 617456 634559 634947 646946 649859 651837 665745 673996 691561 693535 696358 698038 698496 700669 712333 712728 718538 726130 726610 731836 740473 742362 742588 746325 756104 761510 765391 765480 765770 765915 766820 769887 770113 770830 774144 774188 775377 777491 778372 782506 782650 786174 787554 790518 790821 790900 791932 794533 800329 800713 801225 801297 801338 803046 805706 808052 811121 812941 813399 816538 816944 817308 818909 819480 820568 820875 820921 821056 821154 822717 823041 823240 823293 823444 827325 827984 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (2.26%) |
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 425588 604667 481253 433391 765770 777491 778372 696358 698038 712333 617456 604208 791932 794533 801297 812941 770830 746325 386545 811121 442912 700669 518911 577079 651837 775377 790900 800713 805706 396814 398912 397647 765915 790518 388645 813399 516229 665745 742362 786174 761510 561999 529857 95700 558899 396040 399423 819480 820875 600233 787554 801225 782506 801338 774144 769887 765391 770113 726610 698496 800329 808052 396519 766820 387448 823444 818909 816944 387104 409946 409114 823041 816538 817308 827325 693535 774188 410321 383980 494384 383625 827984 712728 691561 742588 646946 634947 634559 782650 731836 765480 726130 718538 790821 391678 388891 803046 451493 435162 401640 518449 756104 740473 161528 565272 188028 408188 820568 820921 821056 822717 823240 821154 823293 529498 530451 497701 563945 649859 673996 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс boobs анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс boobs анал"
]
|
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.