Query Metrics
7
Database Queries
7
Different statements
368.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.37 ms (58.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
131.14 ms (35.59%) |
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 12775 21576 381809 390041 400956 401307 403085 426471 428515 452314 463933 466045 481601 486125 496270 504757 507803 514615 521510 522503 528391 532255 533692 540071 554808 555796 556933 562491 569596 617331 633243 638873 643368 644951 649536 649622 650992 654086 659206 661896 668789 668976 671335 675380 676915 676920 678017 679195 691481 693246 693576 694006 694442 700652 703370 705696 705732 707059 715415 721616 728795 730486 730736 734165 738493 740777 742453 745495 748995 750151 756225 756318 758108 759612 760940 761727 764186 766034 768281 772821 778277 779039 779388 779490 786064 788293 789277 794921 795572 795948 798768 802835 802838 803798 804086 805977 808044 810256 813109 815148 815498 815839 816206 817800 818782 819966 820190 820423 820577 820625 820956 821527 821600 823319 823342 825209 825369 825808 826828 826907 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (3.92%) |
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 795572 786064 426471 820577 815839 820190 554808 638873 705732 779039 21576 668976 703370 721616 659206 556933 643368 813109 738493 802835 768281 750151 778277 810256 826828 679195 789277 504757 428515 693246 694442 805977 486125 676915 756318 821527 507803 617331 772821 819966 522503 676920 779388 748995 496270 818782 668789 705696 691481 794921 756225 734165 758108 728795 745495 452314 528391 700652 788293 650992 649622 693576 766034 678017 715415 730736 759612 761727 466045 820956 820423 400956 532255 403085 540071 562491 815148 675380 381809 649536 569596 514615 633243 760940 12775 820625 644951 815498 481601 654086 661896 707059 764186 798768 521510 808044 463933 817800 816206 671335 742453 821600 825209 825369 825808 826907 823319 823342 533692 802838 803798 740777 555796 401307 694006 779490 795948 804086 730486 390041 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (0.72%) |
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 12775 21576 381809 390041 400956 401307 403085 426471 428515 452314 463933 466045 481601 486125 496270 504757 507803 514615 521510 522503 528391 532255 533692 540071 554808 555796 556933 562491 569596 617331 633243 638873 643368 644951 649536 649622 650992 654086 659206 661896 668789 668976 671335 675380 676915 676920 678017 679195 691481 693246 693576 694006 694442 700652 703370 705696 705732 707059 715415 721616 728795 730486 730736 734165 738493 740777 742453 745495 748995 750151 756225 756318 758108 759612 760940 761727 764186 766034 768281 772821 778277 779039 779388 779490 786064 788293 789277 794921 795572 795948 798768 802835 802838 803798 804086 805977 808044 810256 813109 815148 815498 815839 816206 817800 818782 819966 820190 820423 820577 820625 820956 821527 821600 823319 823342 825209 825369 825808 826828 826907 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"her blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.51%) |
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.