Query Metrics
7
Database Queries
7
Different statements
397.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.17 ms (52.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass beach"
]
|
||||||||||||||||||||||||||||||
|
160.02 ms (40.25%) |
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 13767 27635 123300 401927 415784 420520 425128 435740 440747 444874 446061 446081 446552 448308 448401 448712 454416 456250 456883 458521 465730 469231 469234 469238 469239 469245 478554 481068 481557 483757 486818 486842 491859 497125 504132 510717 518027 523049 523072 526086 530094 530312 530405 530441 532361 535391 537828 542112 543593 545267 549992 553932 558106 558451 558453 562362 562485 569618 577493 579123 600736 602173 613629 614766 619094 621041 634345 634463 635627 644198 647219 649833 650218 651163 652357 661004 661378 670762 679415 680933 680945 680950 682908 688999 690373 710400 714048 714049 717601 721906 724189 728713 732913 732923 734279 739220 740832 749359 750982 752148 761157 764650 768017 768057 768983 771393 771498 778934 781919 785103 791311 792434 801728 802704 804353 805190 809537 811897 812241 813271 ] |
||||||||||||||||||||||||||||||
|
19.04 ms (4.79%) |
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 781919 420520 644198 558451 602173 456250 454416 542112 651163 690373 401927 481557 483757 569618 558106 469231 469234 478554 486842 523072 811897 728713 764650 634463 469239 530094 535391 562485 558453 652357 661004 679415 680950 619094 613629 812241 791311 792434 771498 724189 732923 761157 714048 809537 123300 481068 518027 562362 415784 491859 530312 650218 649833 600736 635627 634345 813271 553932 670762 778934 448308 497125 714049 614766 448712 523049 435740 465730 448401 504132 579123 734279 486818 444874 621041 749359 27635 530405 526086 537828 530441 532361 577493 543593 647219 661378 680933 680945 688999 717601 805190 739220 768057 802704 740832 750982 768983 771393 768017 710400 721906 785103 804353 446552 458521 752148 446081 682908 13767 801728 732913 545267 549992 440747 446061 456883 469238 510717 469245 425128 ] |
||||||||||||||||||||||||||||||
|
4.80 ms (1.21%) |
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 13767 27635 123300 401927 415784 420520 425128 435740 440747 444874 446061 446081 446552 448308 448401 448712 454416 456250 456883 458521 465730 469231 469234 469238 469239 469245 478554 481068 481557 483757 486818 486842 491859 497125 504132 510717 518027 523049 523072 526086 530094 530312 530405 530441 532361 535391 537828 542112 543593 545267 549992 553932 558106 558451 558453 562362 562485 569618 577493 579123 600736 602173 613629 614766 619094 621041 634345 634463 635627 644198 647219 649833 650218 651163 652357 661004 661378 670762 679415 680933 680945 680950 682908 688999 690373 710400 714048 714049 717601 721906 724189 728713 732913 732923 734279 739220 740832 749359 750982 752148 761157 764650 768017 768057 768983 771393 771498 778934 781919 785103 791311 792434 801728 802704 804353 805190 809537 811897 812241 813271 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.44%) |
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.