Query Metrics
7
Database Queries
7
Different statements
140.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.78 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.26 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"под на кайф"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.20 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 422151 525011 538226 591959 603047 609205 621091 521739 584991 554519 575287 670089 593965 594964 624064 580773 655647 597503 613186 466500 536925 652594 573557 590670 621294 614853 521863 485634 511231 506612 478066 493097 579341 651938 659323 421678 509415 516999 526005 510589 444654 644954 604051 604873 484958 613515 475294 586646 612329 578396 567053 675321 611283 620009 610303 597134 600913 479854 577491 482944 534376 652947 657438 622778 615801 619005 584514 621277 632059 562740 584419 657361 658418 599368 516861 521307 653560 469355 472597 483788 589642 475891 517652 497452 526052 494985 ] |
||||||||||||||||||||||||||||||
| 4 | 3.82 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 421678 422151 444654 466500 469355 472597 475294 475891 478066 479854 482944 483788 484958 485634 493097 494985 497452 506612 509415 510589 511231 516861 516999 517652 521307 521739 521863 525011 526005 526052 534376 536925 538226 554519 562740 567053 573557 575287 577491 578396 579341 580773 584419 584514 584991 586646 589642 590670 591959 593965 594964 597134 597503 599368 600913 603047 604051 604873 609205 610303 611283 612329 613186 613515 614853 615801 619005 620009 621091 621277 621294 622778 624064 632059 644954 651938 652594 652947 653560 655647 657361 657438 658418 659323 670089 675321 ] |
||||||||||||||||||||||||||||||
| 5 | 110.03 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 421678 422151 444654 466500 469355 472597 475294 475891 478066 479854 482944 483788 484958 485634 493097 494985 497452 506612 509415 510589 511231 516861 516999 517652 521307 521739 521863 525011 526005 526052 534376 536925 538226 554519 562740 567053 573557 575287 577491 578396 579341 580773 584419 584514 584991 586646 589642 590670 591959 593965 594964 597134 597503 599368 600913 603047 604051 604873 609205 610303 611283 612329 613186 613515 614853 615801 619005 620009 621091 621277 621294 622778 624064 632059 644954 651938 652594 652947 653560 655647 657361 657438 658418 659323 670089 675321 ] |
||||||||||||||||||||||||||||||
| 6 | 2.19 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на кайф"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.