Query Metrics
7
Database Queries
7
Different statements
154.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.84 ms (83.52%) |
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 108555 131474 382099 382110 390255 446310 449896 450126 459333 459574 465450 483482 484345 489789 489795 489796 489797 493020 493100 513025 515260 520576 531576 531902 543149 549592 553298 554510 555726 557137 557155 557237 561600 571814 574022 578029 579768 598339 600404 604885 607537 616630 628458 629004 634320 639953 665192 677913 690314 697844 710420 713755 714456 724439 724632 726392 728490 729076 732027 739339 745531 747544 747556 747850 752109 754608 755904 759309 763265 763623 763675 764585 765921 767333 767402 773346 776182 777521 777724 778153 778274 783088 786602 786716 788414 788883 789894 790650 791900 792615 794625 794952 797215 797299 797725 798926 799765 802005 802023 802069 802886 802942 805285 808071 808873 813311 813977 817283 817801 817819 818104 820075 821788 823827 823943 826305 827266 ] |
||||||||||||||||||||||||||||||
|
14.63 ms (9.48%) |
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 639953 797725 739339 747556 754608 769836 745531 724439 726392 752109 755904 764537 729076 759309 773346 788883 797299 798926 554510 520576 493100 382110 579768 557155 616630 629004 131474 747544 450126 459333 531576 531902 677913 713755 697844 778274 484345 561600 489796 600404 459574 489797 513025 794625 493020 571814 604885 489789 823827 449896 557237 543149 690314 710420 557137 598339 628458 634320 732027 763675 747850 728490 791900 792615 108555 817819 823943 821788 826305 813977 817801 827266 555726 714456 788414 797215 799765 802069 805285 808071 778153 786716 790650 808873 767333 767402 783088 789894 794952 802886 763623 769902 764585 763265 765921 776182 777521 777724 786602 802023 802942 813311 382099 802005 607537 390255 489795 549592 574022 665192 446310 553298 724632 465450 578029 817283 818104 820075 515260 483482 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (2.21%) |
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 108555 131474 382099 382110 390255 446310 449896 450126 459333 459574 465450 483482 484345 489789 489795 489796 489797 493020 493100 513025 515260 520576 531576 531902 543149 549592 553298 554510 555726 557137 557155 557237 561600 571814 574022 578029 579768 598339 600404 604885 607537 616630 628458 629004 634320 639953 665192 677913 690314 697844 710420 713755 714456 724439 724632 726392 728490 729076 732027 739339 745531 747544 747556 747850 752109 754608 755904 759309 763265 763623 763675 764585 765921 767333 767402 773346 776182 777521 777724 778153 778274 783088 786602 786716 788414 788883 789894 790650 791900 792615 794625 794952 797215 797299 797725 798926 799765 802005 802023 802069 802886 802942 805285 808071 808873 813311 813977 817283 817801 817819 818104 820075 821788 823827 823943 826305 827266 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob glasses"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.09%) |
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.