Query Metrics
7
Database Queries
7
Different statements
170.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.78 ms (85.69%) |
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 204605 274758 318378 381980 382202 383036 383149 410076 413293 419847 427749 429169 432129 446137 448070 464627 493539 530855 535059 546813 559874 563678 579308 583314 589702 591135 592555 597689 600147 604958 611314 615475 619424 622205 622291 622377 622622 623261 645959 646915 650339 655864 660389 671458 679044 692263 697558 709841 710407 714053 716860 724037 724253 724370 725633 726582 726812 727818 728192 734364 736261 736402 736958 741050 744828 745999 747458 749153 755156 756107 758033 759641 761283 761325 761883 766042 766043 767837 768988 770105 770111 770183 770290 772590 775140 777010 779237 780006 781345 785218 785722 786497 788811 790073 794745 795024 795104 796555 797275 797399 798687 799206 802505 803963 804072 805128 805691 806239 806311 807521 807968 808418 808497 808690 810974 811085 811093 824541 825262 826278 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (8.24%) |
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 710407 714053 716860 645959 650339 655864 692263 592555 622377 622622 780006 775140 786497 796555 724037 725633 727818 744828 761325 785722 788811 794745 807968 808418 726812 736261 736402 767837 726582 734364 745999 772590 770105 770111 770183 724253 768988 709841 777010 802505 804072 806311 808497 808690 811093 318378 432129 429169 493539 646915 591135 383036 382202 413293 427749 824541 825262 446137 535059 546813 559874 579308 563678 679044 583314 589702 600147 615475 619424 622205 622291 781345 795024 795104 807521 724370 755156 790073 797275 797399 803963 811085 741050 747458 756107 759641 766042 728192 758033 749153 761283 766043 770290 736958 761883 604958 697558 785218 798687 805691 810974 274758 383149 410076 530855 660389 671458 611314 779237 799206 805128 806239 204605 597689 623261 381980 419847 826278 448070 464627 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.90%) |
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 204605 274758 318378 381980 382202 383036 383149 410076 413293 419847 427749 429169 432129 446137 448070 464627 493539 530855 535059 546813 559874 563678 579308 583314 589702 591135 592555 597689 600147 604958 611314 615475 619424 622205 622291 622377 622622 623261 645959 646915 650339 655864 660389 671458 679044 692263 697558 709841 710407 714053 716860 724037 724253 724370 725633 726582 726812 727818 728192 734364 736261 736402 736958 741050 744828 745999 747458 749153 755156 756107 758033 759641 761283 761325 761883 766042 766043 767837 768988 770105 770111 770183 770290 772590 775140 777010 779237 780006 781345 785218 785722 786497 788811 790073 794745 795024 795104 796555 797275 797399 798687 799206 802505 803963 804072 805128 805691 806239 806311 807521 807968 808418 808497 808690 810974 811085 811093 824541 825262 826278 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits lick"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ лиза"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ лиза"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.