Query Metrics
7
Database Queries
7
Different statements
186.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.40 ms (85.55%) |
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 75762 100642 122425 185123 187186 359089 386865 387151 390407 390775 391676 397409 402659 403487 406387 413982 414714 415640 418994 423472 426352 426868 427621 429045 430789 441466 443042 446274 447097 449342 449937 450127 450129 450130 450149 450151 450156 450166 450198 451714 452422 452991 453270 453276 453984 454062 454696 454791 455348 455419 455524 455633 456340 456560 457024 457200 458835 459511 460163 460558 460641 460905 461651 461776 461811 462877 462887 462951 463302 464022 465174 466672 467069 468421 470224 470878 472479 472922 472957 473865 475819 476818 477032 477423 479613 479713 479750 479822 481652 482695 485211 486692 489902 490142 496218 499257 499742 502417 503966 509010 518778 519079 521151 521976 522812 522824 525814 530736 534143 534476 538423 539016 557910 724241 735604 763896 790076 816423 818591 820991 ] |
||||||||||||||||||||||||||||||
|
17.79 ms (9.55%) |
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 503966 509010 530736 534143 534476 539016 460558 467069 468421 557910 790076 735604 763896 724241 391676 455524 463302 479613 387151 397409 459511 460905 472957 185123 447097 461776 470878 429045 475819 414714 430789 461811 518778 522812 525814 489902 496218 499257 521976 538423 499742 502417 519079 522824 441466 454696 521151 461651 386865 100642 122425 187186 359089 75762 390407 390775 402659 403487 406387 423472 426868 415640 418994 443042 413982 426352 427621 816423 818591 820991 482695 446274 450129 450166 450198 453276 453984 454062 457200 458835 465174 473865 477032 479822 481652 486692 449342 450151 450156 451714 452422 452991 453270 454791 455633 456340 456560 457024 460163 462887 466672 470224 472922 477423 485211 490142 449937 450127 450130 450149 455348 455419 460641 462877 462951 464022 472479 476818 479713 479750 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.40%) |
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 75762 100642 122425 185123 187186 359089 386865 387151 390407 390775 391676 397409 402659 403487 406387 413982 414714 415640 418994 423472 426352 426868 427621 429045 430789 441466 443042 446274 447097 449342 449937 450127 450129 450130 450149 450151 450156 450166 450198 451714 452422 452991 453270 453276 453984 454062 454696 454791 455348 455419 455524 455633 456340 456560 457024 457200 458835 459511 460163 460558 460641 460905 461651 461776 461811 462877 462887 462951 463302 464022 465174 466672 467069 468421 470224 470878 472479 472922 472957 473865 475819 476818 477032 477423 479613 479713 479750 479822 481652 482695 485211 486692 489902 490142 496218 499257 499742 502417 503966 509010 518778 519079 521151 521976 522812 522824 525814 530736 534143 534476 538423 539016 557910 724241 735604 763896 790076 816423 818591 820991 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy white"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy white"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy white"
]
|
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.