Query Metrics
7
Database Queries
7
Different statements
148.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.62 ms (81.75%) |
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 401616 413110 415567 417863 418725 421132 421236 421829 421842 421843 421853 421855 421877 421942 422182 424032 424798 425606 425976 427217 428532 429675 430235 430351 430495 431481 431750 433070 433605 434097 437310 438199 439717 439743 439809 443158 444101 444468 446204 450158 450399 450608 451127 452616 453305 453702 453716 454029 454446 455307 456605 457852 458378 458724 459893 460135 460178 460184 460187 460677 461019 464013 464416 464552 466368 469154 469473 471397 471408 472691 478678 478931 479038 481794 482251 485456 488118 490702 492115 492309 493213 493247 502812 505748 505973 509050 509700 511016 513362 514007 516410 516476 516829 517003 518046 519436 521129 521220 521391 521796 521997 523018 523836 523902 524262 524778 524876 525233 526226 526937 528347 528839 531998 532114 537122 537126 561510 565982 800190 813913 ] |
||||||||||||||||||||||||||||||
|
16.96 ms (11.40%) |
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 800190 413110 418725 421829 421843 424032 425606 439743 464416 472691 478931 482251 421877 428532 431750 438199 439809 450158 471408 421132 421842 421855 454029 458724 460184 461019 471397 422182 430351 434097 421853 433070 439717 450399 452616 453716 455307 460178 466368 505748 509050 524876 492115 493247 516410 516829 518046 521129 521796 523836 526937 485456 490702 509700 513362 514007 517003 521997 523018 523902 524778 526226 488118 505973 521220 521391 525233 401616 417863 421942 429675 433605 415567 431481 444101 444468 424798 425976 427217 430495 437310 443158 430235 421236 813913 450608 451127 453305 453702 454446 456605 460187 464552 478678 479038 481794 446204 457852 458378 459893 464013 469154 469473 493213 460135 531998 537126 511016 528347 537122 524262 532114 502812 516476 519436 528839 460677 492309 561510 565982 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.18%) |
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 401616 413110 415567 417863 418725 421132 421236 421829 421842 421843 421853 421855 421877 421942 422182 424032 424798 425606 425976 427217 428532 429675 430235 430351 430495 431481 431750 433070 433605 434097 437310 438199 439717 439743 439809 443158 444101 444468 446204 450158 450399 450608 451127 452616 453305 453702 453716 454029 454446 455307 456605 457852 458378 458724 459893 460135 460178 460184 460187 460677 461019 464013 464416 464552 466368 469154 469473 471397 471408 472691 478678 478931 479038 481794 482251 485456 488118 490702 492115 492309 493213 493247 502812 505748 505973 509050 509700 511016 513362 514007 516410 516476 516829 517003 518046 519436 521129 521220 521391 521796 521997 523018 523836 523902 524262 524778 524876 525233 526226 526937 528347 528839 531998 532114 537122 537126 561510 565982 800190 813913 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son long"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son длинные"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son длинные"
]
|
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.