Query Metrics
7
Database Queries
7
Different statements
140.32 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.78 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 3.02 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls kiss girls"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.32 ms |
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 820800 698025 775130 420501 488234 769664 770895 818541 591403 724751 505438 523278 161351 721687 603948 697735 587967 798734 785915 735481 649932 400896 551417 441817 522743 410559 123614 448378 657525 731687 457471 467638 503423 569961 661430 389516 569453 823420 569950 554273 813133 382747 388020 568820 661462 427593 596365 514799 554635 693076 567146 584308 484461 786064 709295 500614 557533 603671 568079 567147 412966 645003 462418 635800 521201 429909 466374 425910 653536 679465 680819 190874 491273 431117 495397 580326 676989 515808 484977 581112 560203 637049 421214 523793 508860 603159 564120 438896 514997 ] |
||||||||||||||||||||||||||||||
| 4 | 3.07 ms |
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 123614 161351 190874 382747 388020 389516 400896 410559 412966 420501 421214 425910 427593 429909 431117 438896 441817 448378 457471 462418 466374 467638 484461 484977 488234 491273 495397 500614 503423 505438 508860 514799 514997 515808 521201 522743 523278 523793 551417 554273 554635 557533 560203 564120 567146 567147 568079 568820 569453 569950 569961 580326 581112 584308 587967 591403 596365 603159 603671 603948 635800 637049 645003 649932 653536 657525 661430 661462 676989 679465 680819 693076 697735 698025 709295 721687 724751 731687 735481 769664 770895 775130 785915 786064 798734 813133 818541 820800 823420 ] |
||||||||||||||||||||||||||||||
| 5 | 112.35 ms |
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 123614 161351 190874 382747 388020 389516 400896 410559 412966 420501 421214 425910 427593 429909 431117 438896 441817 448378 457471 462418 466374 467638 484461 484977 488234 491273 495397 500614 503423 505438 508860 514799 514997 515808 521201 522743 523278 523793 551417 554273 554635 557533 560203 564120 567146 567147 568079 568820 569453 569950 569961 580326 581112 584308 587967 591403 596365 603159 603671 603948 635800 637049 645003 649932 653536 657525 661430 661462 676989 679465 680819 693076 697735 698025 709295 721687 724751 731687 735481 769664 770895 775130 785915 786064 798734 813133 818541 820800 823420 ] |
||||||||||||||||||||||||||||||
| 6 | 2.47 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк kiss девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.31 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк kiss девушк"
]
|
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.