Query Metrics
7
Database Queries
7
Different statements
159.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.37 ms (84.10%) |
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 229077 384859 390840 393701 394204 403281 404176 422491 428382 435045 440700 450858 455612 455840 457150 457169 458200 460065 463195 467295 467310 470828 471593 475973 476387 476553 476819 479483 479996 480066 488286 491372 491641 491716 491719 491726 495114 498924 501845 505236 505986 508836 510617 513280 518297 518397 521114 521530 521912 521928 523653 524007 525660 526925 527620 543314 548713 551164 551195 551450 551640 552637 553936 562311 564445 565414 565561 566580 569878 570028 570030 570036 570341 570371 570530 570620 570635 570644 570751 571593 571884 571893 571907 572158 572396 573553 573597 574582 575117 575205 575499 575512 575764 576389 578138 609241 700517 721297 726022 729586 735463 735499 742171 743477 745531 753277 753317 753348 753368 753409 753885 757606 761968 766458 776244 777190 782284 789598 808799 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (9.78%) |
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 553936 609241 789598 782284 729586 753277 743477 745531 753317 753368 766458 735463 742171 761968 735499 753348 753409 753885 757606 726022 700517 777190 808799 403281 479996 525660 498924 543314 551164 564445 570030 575499 575512 576389 551450 552637 571884 571907 574582 551195 551640 570341 570620 575205 575764 565414 565561 566580 570644 575117 457169 467295 480066 457150 463195 467310 440700 455612 458200 460065 471593 476387 476553 476819 479483 422491 428382 518297 521530 524007 527620 488286 491641 491716 491719 505986 518397 521928 491726 495114 521912 491372 505236 508836 510617 513280 521114 523653 526925 562311 573597 455840 393701 435045 569878 569904 570028 570036 570371 573553 578138 570530 570635 572158 571593 571893 572396 548713 570751 384859 475973 390840 229077 776244 721297 394204 404176 470828 450858 501845 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.88%) |
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 229077 384859 390840 393701 394204 403281 404176 422491 428382 435045 440700 450858 455612 455840 457150 457169 458200 460065 463195 467295 467310 470828 471593 475973 476387 476553 476819 479483 479996 480066 488286 491372 491641 491716 491719 491726 495114 498924 501845 505236 505986 508836 510617 513280 518297 518397 521114 521530 521912 521928 523653 524007 525660 526925 527620 543314 548713 551164 551195 551450 551640 552637 553936 562311 564445 565414 565561 566580 569878 570028 570030 570036 570341 570371 570530 570620 570635 570644 570751 571593 571884 571893 571907 572158 572396 573553 573597 574582 575117 575205 575499 575512 575764 576389 578138 609241 700517 721297 726022 729586 735463 735499 742171 743477 745531 753277 753317 753348 753368 753409 753885 757606 761968 766458 776244 777190 782284 789598 808799 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pickup russian"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пикап русск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.