Query Metrics
7
Database Queries
7
Different statements
190.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.15 ms (84.62%) |
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 420472 443971 451175 470118 474776 509163 521798 532785 541195 549584 549799 549870 550604 551246 551275 551477 552120 552160 552267 552467 553032 554742 556051 558126 558976 560387 560462 560653 561652 561821 562078 565181 565476 567304 567337 567338 567774 568315 569260 570708 571421 572042 574184 574731 575162 575479 575774 575806 576393 576395 579475 580298 586491 586770 587858 590542 590604 591312 591839 594090 594604 595450 595458 596423 596526 597013 597227 597490 597494 597550 597566 597572 597573 597819 597950 598057 598092 598524 598680 598752 600111 600143 600489 602506 602607 602647 602747 603103 604247 609205 612799 622987 623206 623716 624084 624925 633732 634501 635106 636273 636274 636869 646838 652610 654322 658082 659283 667985 696212 714449 716032 716414 722821 722871 732087 742143 747517 783468 789781 804913 ] |
||||||||||||||||||||||||||||||
|
20.00 ms (10.50%) |
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 623716 598752 470118 474776 600143 634501 560387 576395 562078 553032 574731 659283 549870 565476 586491 571421 594604 789781 747517 716414 602747 624925 451175 549799 420472 654322 541195 732087 804913 560653 597950 580298 597573 633732 595450 597819 596526 623206 561821 575479 572042 556051 575162 722821 551246 597566 602607 636274 636273 742143 714449 722871 550604 551275 574184 575806 551477 552160 552467 558976 560462 567304 567337 598680 597227 509163 595458 604247 609205 612799 521798 568315 579475 646838 667985 602506 658082 652610 591839 598524 635106 570708 575774 594090 590604 600111 597494 532785 552267 558126 552120 567774 576393 716032 598057 783468 549584 569260 561652 696212 586770 591312 602647 590542 598092 443971 624084 597013 600489 597490 567338 603103 597572 636869 597550 587858 622987 565181 554742 596423 ] |
||||||||||||||||||||||||||||||
|
2.43 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 420472 443971 451175 470118 474776 509163 521798 532785 541195 549584 549799 549870 550604 551246 551275 551477 552120 552160 552267 552467 553032 554742 556051 558126 558976 560387 560462 560653 561652 561821 562078 565181 565476 567304 567337 567338 567774 568315 569260 570708 571421 572042 574184 574731 575162 575479 575774 575806 576393 576395 579475 580298 586491 586770 587858 590542 590604 591312 591839 594090 594604 595450 595458 596423 596526 597013 597227 597490 597494 597550 597566 597572 597573 597819 597950 598057 598092 598524 598680 598752 600111 600143 600489 602506 602607 602647 602747 603103 604247 609205 612799 622987 623206 623716 624084 624925 633732 634501 635106 636273 636274 636869 646838 652610 654322 658082 659283 667985 696212 714449 716032 716414 722821 722871 732087 742143 747517 783468 789781 804913 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian anal butt"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал butt"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск анал butt"
]
|
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.