Query Metrics
7
Database Queries
7
Different statements
205.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.89 ms (86.14%) |
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 16663 26026 56810 71071 81091 107216 136157 172688 177651 187418 197736 199346 275948 308583 343369 382013 382215 385398 387145 387408 387886 392006 397199 398468 398533 398554 398791 399430 400326 400328 403685 410107 411710 412627 413007 413733 413734 414078 415049 415852 416116 416120 418562 423871 423983 424114 426639 427001 427208 428797 434589 443081 443400 443421 444376 447019 447024 449411 451776 453406 454021 454332 454491 456709 458193 458330 460289 462968 463148 464361 465215 465444 465485 466776 466813 467059 467360 468136 468518 470937 472677 472768 473319 473502 474786 475887 477444 479123 480013 481101 481750 483456 483826 485986 486822 488843 488885 489172 489926 490574 491158 491350 495137 495499 496293 496726 496891 500095 500574 501427 502600 503515 504119 504774 508871 509202 513451 521439 551821 552948 ] |
||||||||||||||||||||||||||||||
|
19.42 ms (9.46%) |
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 423871 502600 474786 460289 398468 491350 467360 382013 418562 387145 513451 172688 488843 400328 415852 382215 16663 426639 495137 413007 479123 343369 26026 443421 473502 458193 454021 472677 398533 416120 490574 481101 500095 496293 508871 495499 136157 398791 414078 454491 447019 503515 308583 71071 416116 509202 485986 489172 521439 397199 398554 400326 447024 486822 197736 403685 465485 199346 464361 465444 428797 412627 443400 551821 501427 411710 489926 454332 463148 552948 472768 504774 443081 427208 449411 491158 475887 473319 427001 468518 481750 488885 177651 387886 410107 415049 468136 480013 451776 453406 456709 496891 467059 477444 56810 423983 275948 107216 387408 399430 466776 413733 470937 483826 496726 483456 500574 385398 187418 392006 458330 465215 466813 462968 504119 81091 413734 424114 434589 444376 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.28%) |
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 16663 26026 56810 71071 81091 107216 136157 172688 177651 187418 197736 199346 275948 308583 343369 382013 382215 385398 387145 387408 387886 392006 397199 398468 398533 398554 398791 399430 400326 400328 403685 410107 411710 412627 413007 413733 413734 414078 415049 415852 416116 416120 418562 423871 423983 424114 426639 427001 427208 428797 434589 443081 443400 443421 444376 447019 447024 449411 451776 453406 454021 454332 454491 456709 458193 458330 460289 462968 463148 464361 465215 465444 465485 466776 466813 467059 467360 468136 468518 470937 472677 472768 473319 473502 474786 475887 477444 479123 480013 481101 481750 483456 483826 485986 486822 488843 488885 489172 489926 490574 491158 491350 495137 495499 496293 496726 496891 500095 500574 501427 502600 503515 504119 504774 508871 509202 513451 521439 551821 552948 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на весу её"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на вес"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.74%) |
1 |
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.