Query Metrics
7
Database Queries
7
Different statements
182.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.52 ms (85.45%) |
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 33284 382519 384176 385757 387652 391395 393050 395758 398425 404734 405561 416333 416936 420159 429016 431496 436203 436296 438414 438779 439508 443313 444755 446606 451593 451634 453760 458911 460653 461266 462169 462587 463893 464101 464474 465766 465992 466333 466690 467339 467341 467842 469332 470121 470533 471583 472326 472782 473068 473108 473231 473839 473966 474040 474741 476213 477783 478464 478660 478788 478873 479319 479603 480213 480854 480856 481073 481291 481570 485885 489336 492017 494185 495924 498340 500181 502911 504272 505438 508984 510035 514903 518152 518433 520301 521046 523446 523716 524487 529141 531913 531976 532911 537159 538107 539495 540035 543487 543549 544274 551251 551283 551366 551409 553093 554396 558633 561411 561696 567360 586546 698994 735752 744965 748464 753465 760653 798844 800047 812825 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (8.92%) |
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 523716 529141 532911 494185 500181 520301 531913 498340 505438 518433 521046 523446 531976 537159 538107 495924 502911 504272 508984 510035 514903 518152 524487 539495 540035 460653 461266 465766 466333 470533 472782 477783 478788 478873 479319 480213 481073 481291 485885 489336 492017 543487 551366 558633 543549 544274 551409 554396 561411 561696 567360 698994 551251 551283 553093 586546 800047 812825 753465 744965 735752 748464 760653 798844 382519 384176 385757 391395 393050 395758 398425 404734 405561 416333 416936 420159 429016 431496 436203 436296 438414 438779 439508 443313 444755 446606 451593 451634 453760 458911 462169 462587 463893 464101 464474 465992 466690 467339 467341 467842 469332 470121 471583 472326 473068 473108 473231 473839 473966 474040 474741 476213 478464 478660 479603 480854 480856 481570 33284 387652 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.58%) |
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 33284 382519 384176 385757 387652 391395 393050 395758 398425 404734 405561 416333 416936 420159 429016 431496 436203 436296 438414 438779 439508 443313 444755 446606 451593 451634 453760 458911 460653 461266 462169 462587 463893 464101 464474 465766 465992 466333 466690 467339 467341 467842 469332 470121 470533 471583 472326 472782 473068 473108 473231 473839 473966 474040 474741 476213 477783 478464 478660 478788 478873 479319 479603 480213 480854 480856 481073 481291 481570 485885 489336 492017 494185 495924 498340 500181 502911 504272 505438 508984 510035 514903 518152 518433 520301 521046 523446 523716 524487 529141 531913 531976 532911 537159 538107 539495 540035 543487 543549 544274 551251 551283 551366 551409 553093 554396 558633 561411 561696 567360 586546 698994 735752 744965 748464 753465 760653 798844 800047 812825 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful white xxx"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая white xxx"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая white xxx"
]
|
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.