Query Metrics
7
Database Queries
7
Different statements
237.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.16 ms (65.40%) |
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 403010 404395 405252 406990 411704 413499 415224 417174 420357 424410 425750 425752 426139 426220 430002 438235 442173 442194 442195 442234 442248 442254 442255 442285 442325 442339 442352 442678 442735 442750 442768 442773 442783 443138 443184 443727 454177 458523 458937 461603 461616 464322 464922 466263 468232 472147 472481 472840 473994 476260 477953 480753 481339 484362 484462 484626 484639 485773 486345 489847 489971 492309 494051 509343 509712 510622 510929 513021 513059 515803 516894 521003 523438 523762 523766 523773 524191 528425 529079 530500 530530 531424 531473 531505 531508 533002 541484 544790 557960 562888 577357 580284 580388 580663 588633 592590 593167 600381 602317 602999 603973 618741 618952 624451 642403 644137 669410 677609 690106 714748 715719 724522 766911 784307 790888 792533 792663 803541 808621 820173 ] |
||||||||||||||||||||||||||||||
|
71.45 ms (30.12%) |
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 510929 516894 521003 523766 528425 531473 533002 509343 513021 515803 524191 530530 531424 492309 580388 557960 580284 541484 544790 577357 677609 715719 669410 690106 714748 562888 580663 588633 600381 618952 644137 592590 602317 603973 618741 593167 602999 642403 792663 790888 724522 766911 784307 792533 808621 404395 415224 424410 425752 443727 480753 405252 417174 425750 442234 442254 442750 466263 403010 442783 461616 473994 411704 420357 426139 438235 443184 454177 458937 477953 430002 442285 442325 442339 442773 523773 529079 484462 523762 484362 489847 489971 484626 484639 486345 458523 624451 509712 803541 426220 442173 442255 406990 442248 413499 442678 442735 442352 443138 442194 442195 442768 820173 494051 472481 472840 485773 461603 468232 481339 464322 464922 472147 476260 510622 513059 523438 530500 531505 531508 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.43%) |
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 403010 404395 405252 406990 411704 413499 415224 417174 420357 424410 425750 425752 426139 426220 430002 438235 442173 442194 442195 442234 442248 442254 442255 442285 442325 442339 442352 442678 442735 442750 442768 442773 442783 443138 443184 443727 454177 458523 458937 461603 461616 464322 464922 466263 468232 472147 472481 472840 473994 476260 477953 480753 481339 484362 484462 484626 484639 485773 486345 489847 489971 492309 494051 509343 509712 510622 510929 513021 513059 515803 516894 521003 523438 523762 523766 523773 524191 528425 529079 530500 530530 531424 531473 531505 531508 533002 541484 544790 557960 562888 577357 580284 580388 580663 588633 592590 593167 600381 602317 602999 603973 618741 618952 624451 642403 644137 669410 677609 690106 714748 715719 724522 766911 784307 790888 792533 792663 803541 808621 820173 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy red"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая red"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая red"
]
|
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.