Query Metrics
7
Database Queries
7
Different statements
172.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.65 ms (86.73%) |
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 393032 398308 398623 426124 426715 427159 429220 429232 434016 447787 454347 455439 458750 462959 475172 491539 494145 495885 504231 509034 512658 518988 522463 523974 525282 529080 530594 544660 549051 552171 552236 553080 553889 556342 558356 574125 574207 575308 588471 594613 596660 596662 597007 598894 603136 603463 603508 613806 621915 622579 624709 628795 639210 639942 641787 648722 650113 650167 651588 651691 660655 663176 671090 671810 672800 676196 676215 676474 676530 676953 676969 676995 678185 679305 679688 682954 686054 687374 693881 703281 703697 704942 705102 709535 717812 718587 718848 720208 720299 720807 729738 732426 732442 739567 742195 744507 744728 751376 754264 757585 761873 771572 772688 778412 778456 779800 779894 781631 786232 788309 789089 790535 802043 804941 805650 805652 807268 810234 813284 814091 ] |
||||||||||||||||||||||||||||||
|
12.14 ms (7.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 660655 679688 552236 778412 751376 790535 810234 757585 754264 739567 603463 624709 703281 804941 398308 426124 434016 455439 454347 458750 427159 512658 495885 462959 429232 494145 447787 475172 509034 491539 518988 522463 525282 523974 732426 744507 814091 772688 504231 648722 651588 671090 596660 588471 786232 744728 807268 651691 603508 426715 553080 597007 761873 398623 663176 686054 671810 676969 771572 805650 732442 393032 429220 529080 530594 544660 553889 558356 574125 549051 574207 552171 556342 575308 650167 678185 679305 703697 705102 709535 718587 650113 672800 676530 682954 687374 693881 704942 718848 720208 720807 676196 676215 676474 676953 676995 717812 720299 596662 628795 613806 621915 639942 594613 598894 639210 603136 622579 641787 778456 779894 802043 805652 779800 781631 788309 789089 813284 729738 742195 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (2.19%) |
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 393032 398308 398623 426124 426715 427159 429220 429232 434016 447787 454347 455439 458750 462959 475172 491539 494145 495885 504231 509034 512658 518988 522463 523974 525282 529080 530594 544660 549051 552171 552236 553080 553889 556342 558356 574125 574207 575308 588471 594613 596660 596662 597007 598894 603136 603463 603508 613806 621915 622579 624709 628795 639210 639942 641787 648722 650113 650167 651588 651691 660655 663176 671090 671810 672800 676196 676215 676474 676530 676953 676969 676995 678185 679305 679688 682954 686054 687374 693881 703281 703697 704942 705102 709535 717812 718587 718848 720208 720299 720807 729738 732426 732442 739567 742195 744507 744728 751376 754264 757585 761873 771572 772688 778412 778456 779800 779894 781631 786232 788309 789089 790535 802043 804941 805650 805652 807268 810234 813284 814091 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 летние в колготках"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 19 лет колготк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 19 лет колготк"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.84%) |
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.