Query Metrics
7
Database Queries
7
Different statements
180.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.78 ms (86.75%) |
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 27635 123300 329500 415833 425128 435740 440747 446061 446552 448308 448401 448712 451853 454416 456250 456883 456894 459178 459265 465432 465730 469230 469231 469234 469239 469243 481068 504132 523049 523072 523940 526539 530094 530441 532361 534635 535391 535897 542112 543593 543757 544956 545210 556761 558453 562485 562953 568180 576480 580710 585896 595723 599402 606792 613629 619094 634432 634452 651163 652299 652357 661378 661882 672095 677469 679415 682908 688999 692108 698819 704227 713167 713187 714048 719094 721882 721950 721965 724189 728713 733150 734028 734069 734071 735410 735640 740832 743653 749424 749829 751637 757310 761157 763744 768017 768969 771393 772844 785540 786328 789265 789335 792186 792456 792757 792871 793973 795308 798842 801637 802704 803684 803839 805138 808849 809736 809772 812241 813271 813296 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (8.15%) |
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 456250 469230 446552 454416 465432 469231 469234 415833 568180 651163 556761 599402 123300 481068 545210 682908 735410 808849 749424 714048 613629 803684 724189 757310 795308 661378 768969 535391 652357 634432 803839 761157 734028 504132 813271 704227 809736 469239 469243 534635 542112 562485 558453 721950 652299 679415 721965 619094 634452 805138 812241 789265 813296 734069 749829 751637 792757 562953 793973 595723 606792 448401 672095 763744 735640 440747 456894 530441 459178 713167 698819 801637 772844 448308 544956 688999 425128 448712 523072 721882 530094 789335 526539 465730 733150 728713 734071 768017 798842 523049 740832 435740 459265 523940 27635 543593 713187 792456 802704 446061 543757 792871 743653 792186 329500 677469 661882 719094 692108 585896 809772 532361 535897 451853 456883 576480 786328 771393 785540 580710 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.70%) |
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 27635 123300 329500 415833 425128 435740 440747 446061 446552 448308 448401 448712 451853 454416 456250 456883 456894 459178 459265 465432 465730 469230 469231 469234 469239 469243 481068 504132 523049 523072 523940 526539 530094 530441 532361 534635 535391 535897 542112 543593 543757 544956 545210 556761 558453 562485 562953 568180 576480 580710 585896 595723 599402 606792 613629 619094 634432 634452 651163 652299 652357 661378 661882 672095 677469 679415 682908 688999 692108 698819 704227 713167 713187 714048 719094 721882 721950 721965 724189 728713 733150 734028 734069 734071 735410 735640 740832 743653 749424 749829 751637 757310 761157 763744 768017 768969 771393 772844 785540 786328 789265 789335 792186 792456 792757 792871 793973 795308 798842 801637 802704 803684 803839 805138 808849 809736 809772 812241 813271 813296 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beach public sex"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пляж природ на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.66%) |
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.