Query Metrics
7
Database Queries
7
Different statements
147.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.46 ms (81.10%) |
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 385958 426375 451086 453657 464412 510286 522614 531525 534371 536347 557552 559709 579437 582356 582586 586000 597728 602806 618724 650490 651006 677284 686615 688107 702456 710540 726903 737404 738508 742709 744540 755233 755461 756642 756718 757613 758804 762109 769626 776176 776639 781314 781449 782618 784576 786226 788866 789720 790178 791961 793669 798621 799012 799870 800324 801913 806207 806861 808453 811922 814815 815157 815180 815191 815233 815249 815377 815391 815458 815506 815544 815612 815660 815687 815758 815777 815785 815797 815805 815909 815966 816050 816069 816116 816252 816319 816482 816498 816508 816532 816876 816893 816894 816953 817539 820744 821379 821506 821689 821905 822189 822217 822277 822279 822280 822287 822291 822376 822388 822458 822460 822559 822575 822822 822888 822988 822990 823230 823386 827579 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (11.86%) |
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 822988 822376 815458 677284 756642 821905 744540 822217 816953 815377 815544 789720 426375 816498 822280 806207 815612 815660 822458 816482 816532 586000 786226 799012 531525 811922 801913 781449 815180 817539 823386 821506 822575 522614 822291 827579 822822 815687 815909 815966 816894 821689 688107 815249 815777 776639 799870 822888 822990 820744 821379 814815 822279 534371 755233 464412 816252 742709 823230 702456 757613 769626 816069 822388 815797 816508 816876 815233 597728 800324 755461 815785 815157 815191 816116 816893 559709 618724 793669 762109 557552 815805 798621 815391 582586 756718 822189 822277 822460 816319 710540 582356 776176 788866 784576 815758 815506 579437 790178 602806 536347 451086 686615 385958 806861 822559 758804 650490 781314 726903 737404 738508 651006 791961 808453 510286 822287 816050 782618 453657 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.75%) |
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 385958 426375 451086 453657 464412 510286 522614 531525 534371 536347 557552 559709 579437 582356 582586 586000 597728 602806 618724 650490 651006 677284 686615 688107 702456 710540 726903 737404 738508 742709 744540 755233 755461 756642 756718 757613 758804 762109 769626 776176 776639 781314 781449 782618 784576 786226 788866 789720 790178 791961 793669 798621 799012 799870 800324 801913 806207 806861 808453 811922 814815 815157 815180 815191 815233 815249 815377 815391 815458 815506 815544 815612 815660 815687 815758 815777 815785 815797 815805 815909 815966 816050 816069 816116 816252 816319 816482 816498 816508 816532 816876 816893 816894 816953 817539 820744 821379 821506 821689 821905 822189 822217 822277 822279 822280 822287 822291 822376 822388 822458 822460 822559 822575 822822 822888 822988 822990 823230 823386 827579 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom like fuck"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom like секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom like секс"
]
|
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.