Query Metrics
7
Database Queries
7
Different statements
172.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.87 ms (83.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 310683 370905 385794 386991 397023 399075 400722 407072 407636 433201 443370 451465 455030 531317 544343 545769 550014 598427 610243 623473 629837 635228 636016 650951 663423 663436 663873 663987 664274 664848 664857 664961 665124 665190 665206 665230 665257 665278 665302 665303 665312 665315 665359 665364 665491 665508 665840 665842 665854 665890 666834 667278 667526 667538 667665 667672 667845 667894 668901 669735 669750 669753 669766 669786 673629 675729 688322 694188 694436 697704 702158 705355 705450 709359 710605 712314 714156 716470 716482 717760 718889 721120 721466 724502 726588 726830 731686 731788 732344 736400 737390 738917 740138 745007 745752 746110 748467 759582 770904 772120 773513 773547 780625 782256 789528 792590 804009 808002 808549 816766 816822 818316 818486 818731 820249 823586 823913 824807 824908 827936 ] |
||||||||||||||||||||||||||||||
|
19.38 ms (11.27%) |
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 740138 636016 816766 823586 675729 804009 773513 773547 818486 816822 531317 664848 665303 665840 665842 665854 665890 666834 667278 667665 667894 668901 669750 669753 669766 673629 718889 663436 664961 665206 665257 665302 665359 665364 665491 665508 688322 694436 697704 702158 710605 714156 717760 721466 663423 663873 663987 664274 664857 665124 665230 665278 667526 667672 694188 721120 623473 635228 598427 629837 759582 724502 726588 731686 770904 738917 745007 726830 731788 736400 737390 745752 748467 732344 746110 705355 705450 709359 712314 399075 400722 407636 827936 808002 782256 370905 780625 610243 385794 310683 407072 650951 716482 792590 386991 397023 433201 443370 455030 808549 772120 545769 665190 665315 669786 667538 667845 665312 550014 789528 451465 823913 820249 824807 818316 818731 824908 544343 669735 716470 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.44%) |
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 310683 370905 385794 386991 397023 399075 400722 407072 407636 433201 443370 451465 455030 531317 544343 545769 550014 598427 610243 623473 629837 635228 636016 650951 663423 663436 663873 663987 664274 664848 664857 664961 665124 665190 665206 665230 665257 665278 665302 665303 665312 665315 665359 665364 665491 665508 665840 665842 665854 665890 666834 667278 667526 667538 667665 667672 667845 667894 668901 669735 669750 669753 669766 669786 673629 675729 688322 694188 694436 697704 702158 705355 705450 709359 710605 712314 714156 716470 716482 717760 718889 721120 721466 724502 726588 726830 731686 731788 732344 736400 737390 738917 740138 745007 745752 746110 748467 759582 770904 772120 773513 773547 780625 782256 789528 792590 804009 808002 808549 816766 816822 818316 818486 818731 820249 823586 823913 824807 824908 827936 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие старые сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие старые сиськи…"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 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.