Query Metrics
7
Database Queries
7
Different statements
170.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.38 ms (85.04%) |
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 83037 88788 89346 150785 151179 154195 154240 154257 155257 208554 381819 382205 383500 395479 397973 398101 417601 418718 428239 438181 438621 442337 448593 449916 455887 473119 499930 500336 505137 507691 508917 511053 513460 514085 523362 526902 529713 529714 534447 539470 539639 540945 541507 546057 547502 550891 551589 562503 568501 568744 584418 586994 587292 590370 596389 599477 600915 602329 621391 628104 634109 638674 643159 648649 648704 658777 658796 658816 660394 662026 669016 671002 671020 687369 692831 700906 710918 715261 730781 739140 741145 745092 745111 745915 747325 749672 751003 752630 752639 752656 752669 752682 753635 756773 758330 770386 777642 780938 782791 782987 784701 784738 788024 791132 791386 792726 796071 806834 814140 814151 814363 820066 820424 821781 823310 824565 824630 824885 825610 825660 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (8.76%) |
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 507691 534447 562503 550891 648649 596389 586994 638674 643159 756773 782791 150785 395479 418718 820424 741145 151179 89346 397973 398101 449916 539639 514085 539470 505137 547502 599477 88788 155257 154257 154195 584418 692831 782987 587292 417601 428239 438181 814363 448593 455887 546057 551589 687369 700906 621391 784738 791386 730781 739140 753635 777642 780938 473119 438621 511053 710918 715261 658777 513460 208554 154240 442337 814140 814151 499930 529713 523362 526902 529714 541507 540945 568501 671002 648704 660394 669016 671020 658816 662026 590370 600915 628104 634109 602329 796071 745092 784701 792726 745111 752669 752682 758330 745915 747325 749672 752630 752639 752656 770386 791132 806834 382205 383500 568744 820066 825660 788024 500336 658796 381819 824630 821781 824885 823310 824565 825610 508917 751003 83037 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.83%) |
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 83037 88788 89346 150785 151179 154195 154240 154257 155257 208554 381819 382205 383500 395479 397973 398101 417601 418718 428239 438181 438621 442337 448593 449916 455887 473119 499930 500336 505137 507691 508917 511053 513460 514085 523362 526902 529713 529714 534447 539470 539639 540945 541507 546057 547502 550891 551589 562503 568501 568744 584418 586994 587292 590370 596389 599477 600915 602329 621391 628104 634109 638674 643159 648649 648704 658777 658796 658816 660394 662026 669016 671002 671020 687369 692831 700906 710918 715261 730781 739140 741145 745092 745111 745915 747325 749672 751003 752630 752639 752656 752669 752682 753635 756773 758330 770386 777642 780938 782791 782987 784701 784738 788024 791132 791386 792726 796071 806834 814140 814151 814363 820066 820424 821781 823310 824565 824630 824885 825610 825660 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo masturbation solo"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд мастурбац соло"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.89%) |
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.