Query Metrics
7
Database Queries
7
Different statements
188.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.18 ms (86.21%) |
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 233670 405806 407516 413472 413475 415346 428822 431376 446622 451434 457199 458012 463160 464389 467638 512999 519984 531434 532980 532991 533211 534851 538865 539480 539839 543792 544960 550050 550223 559074 564818 570146 570183 590903 596788 597101 598837 599997 601843 617190 620134 621319 621323 622377 634849 640403 641138 643095 643352 647984 649939 650494 651077 671701 673582 673649 678016 683541 683826 685646 693849 699025 705738 717724 718552 718560 719016 719112 721611 724633 725568 725581 726640 726831 726982 728798 732600 736393 740154 741308 743811 753204 756246 757244 760002 766743 770630 787443 789480 789689 795033 797646 800278 801182 801475 802741 802832 802849 803081 803088 808115 808626 813530 815237 815508 815555 815693 815769 815829 815866 816502 817295 817843 817915 817928 818386 818463 821194 821384 823358 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (8.36%) |
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 464389 550050 673582 673649 634849 622377 789689 808626 756246 770630 519984 815508 815769 816502 821384 815866 817295 538865 570146 543792 671701 678016 544960 597101 801182 789480 802849 766743 795033 803088 808115 726831 732600 753204 736393 757244 640403 428822 467638 233670 699025 617190 813530 823358 533211 718560 800278 413475 413472 415346 815693 818386 815555 815829 817915 817843 457199 446622 458012 534851 539839 532980 532991 539480 531434 559074 550223 564818 650494 683541 717724 683826 685646 647984 649939 651077 693849 621319 643352 596788 598837 599997 601843 643095 801475 802832 740154 760002 803081 724633 726982 725568 725581 743811 726640 728798 741308 621323 641138 705738 718552 719016 719112 787443 797646 802741 463160 405806 451434 512999 431376 620134 407516 818463 821194 817928 815237 570183 721611 590903 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.63%) |
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 233670 405806 407516 413472 413475 415346 428822 431376 446622 451434 457199 458012 463160 464389 467638 512999 519984 531434 532980 532991 533211 534851 538865 539480 539839 543792 544960 550050 550223 559074 564818 570146 570183 590903 596788 597101 598837 599997 601843 617190 620134 621319 621323 622377 634849 640403 641138 643095 643352 647984 649939 650494 651077 671701 673582 673649 678016 683541 683826 685646 693849 699025 705738 717724 718552 718560 719016 719112 721611 724633 725568 725581 726640 726831 726982 728798 732600 736393 740154 741308 743811 753204 756246 757244 760002 766743 770630 787443 789480 789689 795033 797646 800278 801182 801475 802741 802832 802849 803081 803088 808115 808626 813530 815237 815508 815555 815693 815769 815829 815866 816502 817295 817843 817915 817928 818386 818463 821194 821384 823358 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom ass kissing"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom жоп kissing"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom жоп kissing"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.82%) |
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.