Query Metrics
7
Database Queries
7
Different statements
190.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.30 ms (85.84%) |
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 411703 428328 439587 446562 450990 452644 452953 454304 459401 464550 470064 473392 475227 482499 488957 489603 490268 491212 491508 491535 491732 493033 496595 500288 501007 503220 503287 505819 506252 507533 508786 508830 508835 508836 508839 508846 508860 509440 510898 511752 512274 517797 518599 518608 518609 518818 519426 523679 523862 525211 525957 527180 542748 544494 545721 548903 551165 567848 568835 572164 573175 574566 575057 575472 575806 576095 576380 576413 577427 581483 584631 584907 590425 591197 595756 596168 597028 597112 597149 597182 597480 598092 598574 598614 599326 599463 599529 599938 600078 600302 600973 601985 605349 605746 608560 608787 620124 621222 621735 621980 625439 630609 693338 746126 760451 796831 803039 ] |
||||||||||||||||||||||||||||||
|
16.45 ms (8.65%) |
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 597182 600302 598614 796831 803039 760451 746126 446562 459401 464550 518609 490268 491732 506252 508846 511752 519426 525957 512274 489603 505819 508830 508836 523679 598574 450990 439587 525211 568835 576413 542748 544494 575057 576380 693338 545721 581483 630609 599529 597149 428328 473392 411703 508835 493033 508786 518608 491212 508839 488957 491535 501007 503287 527180 507533 503220 496595 452644 482499 500288 574566 573175 575806 575472 577427 621222 600078 491508 518818 523862 509440 517797 470064 475227 567848 590425 600973 608787 598092 591197 584631 584907 599463 599938 548903 454304 595756 576095 608560 625439 510898 551165 572164 597480 621980 508860 596168 599326 620124 597112 605746 518599 597028 621735 605349 452953 601985 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.65%) |
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 411703 428328 439587 446562 450990 452644 452953 454304 459401 464550 470064 473392 475227 482499 488957 489603 490268 491212 491508 491535 491732 493033 496595 500288 501007 503220 503287 505819 506252 507533 508786 508830 508835 508836 508839 508846 508860 509440 510898 511752 512274 517797 518599 518608 518609 518818 519426 523679 523862 525211 525957 527180 542748 544494 545721 548903 551165 567848 568835 572164 573175 574566 575057 575472 575806 576095 576380 576413 577427 581483 584631 584907 590425 591197 595756 596168 597028 597112 597149 597182 597480 598092 598574 598614 599326 599463 599529 599938 600078 600302 600973 601985 605349 605746 608560 608787 620124 621222 621735 621980 625439 630609 693338 746126 760451 796831 803039 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus dirty"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск dirty"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск dirty"
]
|
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.