Query Metrics
7
Database Queries
7
Different statements
162.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.20 ms (81.35%) |
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 390264 416467 419220 421155 431422 435700 451758 470933 477588 478414 478530 486616 488549 491913 493234 497869 506839 515974 516222 519760 520767 522095 524389 526008 526070 527091 530729 535019 540400 545365 549027 563414 563547 564561 564814 567338 577358 584101 584528 590130 590707 596075 598937 600297 600317 600798 601535 604383 605378 605576 608939 619469 622693 630678 636070 636280 640676 643420 644941 660690 660748 662129 670773 681257 689358 696946 707322 717523 717829 723564 725376 728437 733266 737522 739860 739863 742636 748945 761028 766694 766896 768031 768032 775801 777577 784345 784481 787564 788494 788942 790409 799946 799990 800205 800287 800347 801277 801287 801941 801962 801967 801975 802057 802202 802826 805696 805703 807951 808166 809104 810299 812987 814431 814926 814991 815190 815699 816403 817256 818156 ] |
||||||||||||||||||||||||||||||
|
20.49 ms (12.61%) |
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 788942 802202 737522 739863 802057 605576 516222 526008 584101 800347 816403 577358 662129 670773 717829 590707 619469 805696 768031 725376 739860 768032 805703 419220 477588 435700 814431 717523 545365 777577 784345 728437 733266 766694 640676 799946 567338 530729 596075 491913 563414 564561 800287 515974 601535 470933 563547 600317 660690 689358 600798 810299 788494 801962 766896 644941 814926 815190 815699 451758 681257 660748 636280 643420 800205 808166 809104 787564 790409 801277 801975 812987 801967 761028 604383 636070 801941 807951 416467 506839 390264 600297 564814 526070 584528 478414 522095 707322 608939 497869 421155 817256 605378 493234 622693 519760 431422 723564 630678 775801 801287 748945 784481 802826 696946 799990 488549 535019 818156 527091 814991 520767 486616 549027 590130 540400 598937 742636 478530 524389 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.56%) |
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 390264 416467 419220 421155 431422 435700 451758 470933 477588 478414 478530 486616 488549 491913 493234 497869 506839 515974 516222 519760 520767 522095 524389 526008 526070 527091 530729 535019 540400 545365 549027 563414 563547 564561 564814 567338 577358 584101 584528 590130 590707 596075 598937 600297 600317 600798 601535 604383 605378 605576 608939 619469 622693 630678 636070 636280 640676 643420 644941 660690 660748 662129 670773 681257 689358 696946 707322 717523 717829 723564 725376 728437 733266 737522 739860 739863 742636 748945 761028 766694 766896 768031 768032 775801 777577 784345 784481 787564 788494 788942 790409 799946 799990 800205 800287 800347 801277 801287 801941 801962 801967 801975 802057 802202 802826 805696 805703 807951 808166 809104 810299 812987 814431 814926 814991 815190 815699 816403 817256 818156 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal fetish"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал фетиш"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал фетиш"
]
|
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.