Query Metrics
7
Database Queries
7
Different statements
149.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.36 ms (82.94%) |
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 460857 473128 540051 540150 540159 540774 542445 544617 544871 546036 552382 554716 555220 555296 556040 556337 562048 562053 573516 576509 577019 580129 580382 581033 592576 597763 606253 606271 606484 610199 618177 618864 626332 626841 627131 628332 632750 633182 633823 637511 640156 640672 649440 652766 656523 659033 662214 672755 672764 678662 681535 691381 692713 692714 700011 701194 709712 710265 714453 714489 715888 717147 724029 725229 726171 727017 727042 727556 727969 728276 729287 732869 736396 736944 737883 739561 740472 744418 744820 745464 748496 748637 749129 751170 751360 752840 755057 757238 757246 758176 758292 768059 768683 774666 784048 785574 790124 790158 794019 795979 796577 797240 797250 800763 800920 802315 802949 805836 807881 810390 811785 811862 811882 811889 812934 816168 818635 826763 827080 827491 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (9.64%) |
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 768059 751360 755057 768683 727042 728276 758292 637511 709712 715888 717147 774666 562053 640672 744820 745464 739561 627131 757246 633823 628332 827491 818635 540774 540150 460857 573516 580382 556040 546036 681535 656523 692713 714489 554716 606253 618864 606484 606271 811882 726171 737883 749129 784048 805836 811785 732869 744418 751170 727017 740472 748637 757238 758176 727969 633182 701194 785574 800920 811862 811889 672764 790158 562048 710265 797240 752840 618177 540051 542445 577019 544617 544871 556337 649440 662214 700011 555296 632750 640156 626332 794019 795979 802949 807881 797250 810390 812934 725229 736396 790124 802315 724029 748496 727556 800763 678662 652766 626841 796577 736944 729287 473128 672755 816168 826763 827080 540159 552382 581033 576509 692714 659033 691381 714453 555220 580129 592576 597763 610199 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.08%) |
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 460857 473128 540051 540150 540159 540774 542445 544617 544871 546036 552382 554716 555220 555296 556040 556337 562048 562053 573516 576509 577019 580129 580382 581033 592576 597763 606253 606271 606484 610199 618177 618864 626332 626841 627131 628332 632750 633182 633823 637511 640156 640672 649440 652766 656523 659033 662214 672755 672764 678662 681535 691381 692713 692714 700011 701194 709712 710265 714453 714489 715888 717147 724029 725229 726171 727017 727042 727556 727969 728276 729287 732869 736396 736944 737883 739561 740472 744418 744820 745464 748496 748637 749129 751170 751360 752840 755057 757238 757246 758176 758292 768059 768683 774666 784048 785574 790124 790158 794019 795979 796577 797240 797250 800763 800920 802315 802949 805836 807881 810390 811785 811862 811882 811889 812934 816168 818635 826763 827080 827491 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss wife"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг жен"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.