Query Metrics
7
Database Queries
7
Different statements
167.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.98 ms (84.70%) |
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 263296 406095 419277 420428 421695 434810 435971 437097 438415 442802 446210 447008 448468 450567 450853 451313 453519 454966 456454 457339 457926 458509 458572 460349 460839 463471 463496 463592 472541 474989 480003 485720 493201 494180 500159 500498 505243 520829 522428 522960 524061 524358 524789 527228 528506 530178 531384 534773 536662 548815 551581 551634 551688 552368 555742 561281 562055 562444 562946 562952 567076 574675 575177 577111 577663 579390 580659 583954 585240 587197 587937 591375 593070 594443 595143 598719 605568 606143 608320 614422 616674 623219 625605 628724 635736 665597 698148 710367 717850 720624 722080 722934 725203 728499 734509 745980 749633 750587 750792 759014 759074 760530 763590 763845 768003 768988 771328 771564 779986 781904 782973 784856 787214 792351 796272 798469 798966 808236 812085 ] |
||||||||||||||||||||||||||||||
|
15.86 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 792351 749633 763590 782973 784856 808236 725203 759074 760530 751259 710367 453519 536662 781904 457339 263296 406095 442802 435971 437097 420428 438415 446210 493201 527228 534773 505243 522960 500159 460839 551688 562946 574675 577663 551581 552368 548815 561281 717850 665597 562444 562952 567076 598719 628724 587197 591375 625605 635736 606143 616674 779986 787214 798469 745980 750587 768003 771564 759014 768988 614422 722080 798966 812085 434810 457926 421695 480003 419277 450853 524061 528506 494180 524358 472541 734509 474989 580659 447008 524789 579390 454966 463471 485720 448468 450567 456454 458509 458572 463496 463592 451313 460349 500498 520829 530178 522428 531384 551634 583954 555742 575177 720624 722934 562055 577111 585240 593070 623219 587937 594443 595143 605568 608320 728499 750792 763845 771328 698148 796272 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.61%) |
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 263296 406095 419277 420428 421695 434810 435971 437097 438415 442802 446210 447008 448468 450567 450853 451313 453519 454966 456454 457339 457926 458509 458572 460349 460839 463471 463496 463592 472541 474989 480003 485720 493201 494180 500159 500498 505243 520829 522428 522960 524061 524358 524789 527228 528506 530178 531384 534773 536662 548815 551581 551634 551688 552368 555742 561281 562055 562444 562946 562952 567076 574675 575177 577111 577663 579390 580659 583954 585240 587197 587937 591375 593070 594443 595143 598719 605568 606143 608320 614422 616674 623219 625605 628724 635736 665597 698148 710367 717850 720624 722080 722934 725203 728499 734509 745980 749633 750587 750792 759014 759074 760530 763590 763845 768003 768988 771328 771564 779986 781904 782973 784856 787214 792351 796272 798469 798966 808236 812085 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"him cum"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"him cum"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"him cum"
]
|
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.