Query Metrics
7
Database Queries
7
Different statements
170.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.19 ms (86.42%) |
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 6609 7219 12792 13229 14966 24289 24724 25721 31134 39719 46186 71071 80663 81656 106185 120415 131975 145424 154497 157617 186988 214139 214663 229105 270386 287459 312466 336987 381874 382181 382362 382472 382943 383311 383592 383842 384015 384872 385605 386071 387353 387627 388532 389721 390071 390368 390746 391318 391686 392331 393533 393677 393849 395407 395504 395726 396054 396225 396230 396283 396456 396859 396883 397013 397071 397138 397170 397307 397808 398192 398666 402243 403678 410056 412134 418363 420621 428402 429193 429257 430742 430770 446077 446104 446136 448598 448602 454728 461015 462224 465583 465587 466568 475633 475639 488008 499356 499369 531297 532872 536740 539219 549309 549323 549933 552049 553814 589263 601062 614110 619211 624239 644431 681386 681394 688675 698526 713927 790810 818201 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (7.75%) |
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 390368 396230 818201 475639 454728 475633 532872 549323 392331 14966 410056 465583 465587 430742 446077 393533 398666 713927 428402 157617 393677 39719 396054 80663 385605 214663 312466 382362 382472 24289 388532 389721 429193 446136 539219 531297 536740 553814 549309 681386 698526 589263 790810 381874 393849 106185 430770 461015 387353 395407 397170 386071 382943 384872 383592 154497 186988 214139 24724 31134 6609 131975 390071 552049 688675 619211 396225 403678 270386 395504 396859 13229 71071 384015 397808 397307 120415 383842 229105 391686 336987 382181 25721 391318 387627 397013 448598 448602 466568 644431 46186 402243 390746 397071 446104 499356 499369 488008 395726 396456 681394 145424 624239 287459 429257 7219 412134 418363 81656 383311 12792 396283 396883 397138 398192 420621 462224 549933 601062 614110 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.80%) |
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 6609 7219 12792 13229 14966 24289 24724 25721 31134 39719 46186 71071 80663 81656 106185 120415 131975 145424 154497 157617 186988 214139 214663 229105 270386 287459 312466 336987 381874 382181 382362 382472 382943 383311 383592 383842 384015 384872 385605 386071 387353 387627 388532 389721 390071 390368 390746 391318 391686 392331 393533 393677 393849 395407 395504 395726 396054 396225 396230 396283 396456 396859 396883 397013 397071 397138 397170 397307 397808 398192 398666 402243 403678 410056 412134 418363 420621 428402 429193 429257 430742 430770 446077 446104 446136 448598 448602 454728 461015 462224 465583 465587 466568 475633 475639 488008 499356 499369 531297 532872 536740 539219 549309 549323 549933 552049 553814 589263 601062 614110 619211 624239 644431 681386 681394 688675 698526 713927 790810 818201 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"muscle girls"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мускулистые девушк"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.