Query Metrics
7
Database Queries
7
Different statements
176.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.02 ms (88.06%) |
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 14369 186988 191117 195676 250422 271496 383088 386336 389289 397184 397605 398555 398927 401814 403087 408743 409350 411054 411731 416855 421257 422278 437352 439456 443191 449894 453122 454429 455325 459566 460129 462968 464423 467823 485610 487953 488532 489169 493679 503978 520106 527417 530098 533716 537760 543545 544184 546558 554460 567113 588635 589578 591741 604673 606252 617390 629810 629826 644102 652749 664813 666197 667574 669771 670501 699765 701257 711660 714173 714204 719907 724491 726492 728380 729100 729292 731040 731046 731317 734108 739561 740138 740954 742721 744053 745264 746095 746658 748483 751472 751522 756256 756811 769393 772120 775158 775589 781846 781885 781892 781900 790305 792593 794175 800176 801494 804030 808231 808631 810350 810356 823746 823881 823956 824331 825385 826703 827097 827183 827977 ] |
||||||||||||||||||||||||||||||
|
11.29 ms (6.41%) |
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 527417 543545 664813 667574 827183 827977 533716 711660 589578 629810 794175 810356 724491 728380 731046 726492 756811 719907 775589 781900 810350 397184 408743 422278 487953 455325 554460 617390 409350 439456 383088 389289 398927 398555 411731 823746 827097 485610 503978 546558 670501 567113 606252 644102 792593 800176 804030 801494 748483 744053 746095 756256 714173 775158 250422 191117 271496 397605 401814 403087 449894 453122 454429 493679 462968 530098 669771 604673 781885 772120 740138 488532 14369 386336 186988 195676 411054 823881 825385 826703 823956 824331 537760 652749 701257 714204 666197 588635 790305 808631 781846 808231 729100 734108 731040 731317 745264 729292 746658 751472 739561 740954 742721 751522 769393 629826 699765 460129 544184 467823 416855 437352 459566 464423 591741 781892 443191 520106 489169 421257 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.40%) |
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 14369 186988 191117 195676 250422 271496 383088 386336 389289 397184 397605 398555 398927 401814 403087 408743 409350 411054 411731 416855 421257 422278 437352 439456 443191 449894 453122 454429 455325 459566 460129 462968 464423 467823 485610 487953 488532 489169 493679 503978 520106 527417 530098 533716 537760 543545 544184 546558 554460 567113 588635 589578 591741 604673 606252 617390 629810 629826 644102 652749 664813 666197 667574 669771 670501 699765 701257 711660 714173 714204 719907 724491 726492 728380 729100 729292 731040 731046 731317 734108 739561 740138 740954 742721 744053 745264 746095 746658 748483 751472 751522 756256 756811 769393 772120 775158 775589 781846 781885 781892 781900 790305 792593 794175 800176 801494 804030 808231 808631 810350 810356 823746 823881 823956 824331 825385 826703 827097 827183 827977 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут пышку"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс полная"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.90%) |
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.