Query Metrics
7
Database Queries
7
Different statements
197.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.55 ms (85.32%) |
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 11013 30454 45367 92307 95586 96023 97401 118436 147638 193299 213057 282494 314118 322815 358539 362000 373998 381424 382365 382437 383095 383387 384490 384878 385248 385436 385743 387074 387228 387281 388481 388558 389453 391279 391904 393384 394453 396473 396701 400100 401184 403100 403468 404172 404192 404371 404409 404468 404809 407194 407311 407686 408969 410853 415507 417132 420471 421543 422837 423930 429820 432613 434125 437857 440692 443317 445279 445776 447161 452413 453691 460938 462822 470001 470273 476093 485493 492948 494106 497576 498983 502786 519021 520545 521181 521954 523507 541250 604053 608605 611968 633134 640703 643095 644813 716746 725297 729328 735524 743833 744324 748226 748695 750880 770524 770630 773098 775825 776196 776889 783466 789666 797430 806767 808474 808690 809663 811975 814313 814447 ] |
||||||||||||||||||||||||||||||
|
17.90 ms (9.06%) |
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 640703 608605 611968 604053 633134 643095 775825 806767 808474 776196 776889 789666 743833 748226 770524 783466 797430 809663 811975 725297 729328 735524 744324 750880 773098 748695 770630 716746 808690 381424 382365 385743 394453 415507 45367 92307 382437 385436 388558 391904 401184 404172 417132 429820 476093 314118 384878 393384 400100 404409 423930 445776 460938 118436 147638 282494 362000 385248 396473 403100 404192 404809 452413 462822 470001 470273 453691 485493 492948 498983 502786 521954 523507 519021 494106 497576 520545 521181 541250 95586 383095 383387 384490 213057 193299 322815 373998 358539 96023 97401 30454 11013 388481 389453 387281 387074 387228 391279 396701 403468 404371 404468 407311 407686 422837 445279 407194 408969 410853 420471 421543 432613 437857 443317 440692 434125 814313 644813 814447 447161 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.69%) |
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 11013 30454 45367 92307 95586 96023 97401 118436 147638 193299 213057 282494 314118 322815 358539 362000 373998 381424 382365 382437 383095 383387 384490 384878 385248 385436 385743 387074 387228 387281 388481 388558 389453 391279 391904 393384 394453 396473 396701 400100 401184 403100 403468 404172 404192 404371 404409 404468 404809 407194 407311 407686 408969 410853 415507 417132 420471 421543 422837 423930 429820 432613 434125 437857 440692 443317 445279 445776 447161 452413 453691 460938 462822 470001 470273 476093 485493 492948 494106 497576 498983 502786 519021 520545 521181 521954 523507 541250 604053 608605 611968 633134 640703 643095 644813 716746 725297 729328 735524 743833 744324 748226 748695 750880 770524 770630 773098 775825 776196 776889 783466 789666 797430 806767 808474 808690 809663 811975 814313 814447 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"двух"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"двух"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"двух"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.