Query Metrics
7
Database Queries
7
Different statements
194.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.24 ms (87.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 402724 439732 451372 465237 509554 540143 540577 541197 541856 542580 542591 543627 545373 550124 550128 550196 550201 563939 578642 582323 586563 589240 591487 599875 599914 599915 599945 599969 600017 600185 600268 600363 600995 601517 601579 601584 613146 615714 627807 631194 631249 632633 632645 632654 632669 632691 632703 632974 633736 633766 633792 634139 634145 634773 634786 634790 637043 637125 637442 637592 637741 639027 639792 639802 640762 640800 641681 642002 642018 642041 644962 647635 647885 647914 647936 648816 648825 649215 649583 650817 651148 651168 651599 666535 666545 666548 666881 666883 666892 666902 668526 668555 673570 674975 676112 677293 678135 680255 695126 696202 702677 702927 704226 704248 716878 718745 718766 748931 749340 750299 750527 750538 784242 788780 788789 788794 800588 801292 820759 820779 ] |
||||||||||||||||||||||||||||||
|
15.74 ms (8.10%) |
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 639792 600017 784242 788780 634786 788789 749340 750299 696202 718766 649583 704226 788794 801292 540143 563939 578642 750527 465237 586563 542591 550201 651168 650817 637125 634139 641681 666548 673570 668555 632703 632669 748931 632633 633766 718745 591487 632974 439732 550124 666881 647914 702927 631249 640800 820779 649215 647885 677293 644962 543627 666545 599945 634145 632654 637043 639802 601517 639027 634773 640762 402724 550196 601579 637741 750538 509554 615714 451372 541197 704248 601584 589240 676112 666883 678135 600185 642002 642018 632645 800588 540577 550128 582323 541856 542580 648816 651599 680255 695126 716878 599915 632691 599914 600995 642041 627807 648825 613146 637592 647635 668526 600268 634790 599875 599969 647936 666892 674975 633736 637442 633792 820759 651148 600363 631194 545373 666535 702677 666902 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.61%) |
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 402724 439732 451372 465237 509554 540143 540577 541197 541856 542580 542591 543627 545373 550124 550128 550196 550201 563939 578642 582323 586563 589240 591487 599875 599914 599915 599945 599969 600017 600185 600268 600363 600995 601517 601579 601584 613146 615714 627807 631194 631249 632633 632645 632654 632669 632691 632703 632974 633736 633766 633792 634139 634145 634773 634786 634790 637043 637125 637442 637592 637741 639027 639792 639802 640762 640800 641681 642002 642018 642041 644962 647635 647885 647914 647936 648816 648825 649215 649583 650817 651148 651168 651599 666535 666545 666548 666881 666883 666892 666902 668526 668555 673570 674975 676112 677293 678135 680255 695126 696202 702677 702927 704226 704248 716878 718745 718766 748931 749340 750299 750527 750538 784242 788780 788789 788794 800588 801292 820759 820779 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pee sex"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pee секс"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pee секс"
]
|
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.