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