Query Metrics
7
Database Queries
7
Different statements
187.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.44 ms (89.24%) |
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 193870 392750 396425 398164 404192 408277 430048 443941 454370 486540 515574 522867 541781 560319 562110 569415 576165 581399 583851 592452 599876 603382 605025 605305 610668 621508 630106 637673 639972 644331 644448 645700 660389 665709 677323 679462 681020 681045 681987 683369 683953 685686 687232 688262 688313 690081 690839 693849 694470 699549 703436 703538 705516 708462 710246 720243 721711 721715 728271 728946 735549 740639 741299 741893 750880 755429 756383 756604 766034 770322 770787 770881 770926 773554 774394 775793 789666 792831 800274 800606 801484 801963 802126 803864 804455 805268 805374 805595 805596 805989 808224 809468 809667 809723 815046 815192 815298 815318 815337 815341 815461 815534 815591 815693 815831 816562 817843 817935 818273 818277 818386 820353 821337 821596 821612 822424 823680 824315 825139 825831 ] |
||||||||||||||||||||||||||||||
|
12.05 ms (6.42%) |
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 599876 637673 605025 792831 800606 801963 805268 770787 728271 770926 735549 770322 770881 773554 703436 705516 721711 721715 808224 408277 562110 683369 610668 603382 569415 430048 677323 639972 522867 728946 398164 815461 815534 818277 822424 815337 816562 821596 823680 454370 679462 683953 681020 685686 688262 688313 687232 693849 703538 720243 592452 630106 802126 805596 805989 775793 789666 800274 803864 804455 805374 805595 756383 740639 755429 756604 750880 766034 741299 644448 708462 809667 809723 396425 404192 392750 774394 560319 576165 660389 741893 644331 515574 541781 605305 621508 801484 809468 486540 193870 443941 815298 815318 815341 815693 818386 820353 825139 815591 821337 821612 815046 815831 817935 825831 815192 817843 818273 824315 583851 581399 645700 681045 681987 694470 665709 699549 710246 690081 690839 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.32%) |
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 193870 392750 396425 398164 404192 408277 430048 443941 454370 486540 515574 522867 541781 560319 562110 569415 576165 581399 583851 592452 599876 603382 605025 605305 610668 621508 630106 637673 639972 644331 644448 645700 660389 665709 677323 679462 681020 681045 681987 683369 683953 685686 687232 688262 688313 690081 690839 693849 694470 699549 703436 703538 705516 708462 710246 720243 721711 721715 728271 728946 735549 740639 741299 741893 750880 755429 756383 756604 766034 770322 770787 770881 770926 773554 774394 775793 789666 792831 800274 800606 801484 801963 802126 803864 804455 805268 805374 805595 805596 805989 808224 809468 809667 809723 815046 815192 815298 815318 815337 815341 815461 815534 815591 815693 815831 816562 817843 817935 818273 818277 818386 820353 821337 821596 821612 822424 823680 824315 825139 825831 ] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom fuck threesome"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom секс секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom секс секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.71%) |
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.