Query Metrics
7
Database Queries
7
Different statements
149.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.89 ms (83.10%) |
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 377993 378272 385596 393692 417553 419221 425272 427267 432272 448006 448089 453507 454319 455378 466553 468305 487278 494575 520641 521218 527072 543431 546994 555014 560889 566337 566833 567181 597910 603612 616425 621277 624201 624204 624207 625208 626120 637901 675461 714927 720424 726320 727459 727545 728260 728924 729262 730803 730806 732220 732698 733259 733271 734283 734342 734360 735987 740070 744815 747431 749486 751178 758208 759870 767189 769448 774771 777765 778285 781932 781962 786880 786920 790817 792348 793830 793839 793841 794291 794488 796307 796480 800017 800149 800542 801164 801922 802769 803605 804949 808021 811097 814727 816397 819338 820022 823151 823175 823598 823689 823754 823860 823974 824077 824085 824509 824598 824645 824790 824826 824953 825126 825260 826383 826410 826642 826651 827377 827617 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (9.81%) |
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 811097 777765 800542 543431 749486 616425 728260 767189 803605 448006 555014 432272 758208 626120 487278 759870 566337 823151 468305 455378 425272 393692 520641 527072 774771 567181 720424 546994 603612 453507 621277 800017 823754 824077 826651 823860 826383 824790 730803 827377 734283 624207 733271 819419 824645 819338 824598 824085 728924 786880 521218 597910 624204 494575 714927 790817 781932 814727 793839 734360 417553 792348 794291 727545 823689 823598 796307 740070 793841 824826 800149 378272 729262 637901 419221 566833 448089 466553 726320 730806 624201 801164 727459 427267 823175 816397 751178 802769 734342 747431 808021 385596 769448 826642 778285 793830 732220 454319 824953 827617 786920 823974 744815 732698 735987 377993 826410 825126 820022 560889 794488 625208 824509 825260 675461 796480 801922 781962 804949 733259 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.31%) |
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 377993 378272 385596 393692 417553 419221 425272 427267 432272 448006 448089 453507 454319 455378 466553 468305 487278 494575 520641 521218 527072 543431 546994 555014 560889 566337 566833 567181 597910 603612 616425 621277 624201 624204 624207 625208 626120 637901 675461 714927 720424 726320 727459 727545 728260 728924 729262 730803 730806 732220 732698 733259 733271 734283 734342 734360 735987 740070 744815 747431 749486 751178 758208 759870 767189 769448 774771 777765 778285 781932 781962 786880 786920 790817 792348 793830 793839 793841 794291 794488 796307 796480 800017 800149 800542 801164 801922 802769 803605 804949 808021 811097 814727 816397 819338 820022 823151 823175 823598 823689 823754 823860 823974 824077 824085 824509 824598 824645 824790 824826 824953 825126 825260 826383 826410 826642 826651 827377 827617 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy big ass"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy большая большие жоп"
]
|
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.