Query Metrics
7
Database Queries
7
Different statements
151.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.38 ms (83.64%) |
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 53532 86313 229210 251147 383795 387160 388091 389315 398712 399039 399195 402982 403255 413770 427783 429508 437360 440737 462940 506216 515129 516646 528150 533527 538566 538996 543677 544636 547980 548857 548905 554191 555677 557963 559914 570120 587256 596507 601545 620631 622123 622349 625307 644655 649931 651323 651896 651944 653522 653551 653624 653912 654621 659339 672466 673050 673297 678539 679360 679549 681804 689107 689565 691616 692438 694607 694660 695932 697079 697645 709915 714410 717805 717870 718869 720385 720850 721188 721202 721784 722655 723504 723536 725096 734875 738908 741207 755191 755848 756219 757349 758973 761344 761638 762169 771755 774100 775789 775825 776927 789108 793427 795402 795919 798930 800894 801271 801548 805508 807148 807462 809651 813747 817114 818582 818932 821660 822981 827178 827932 ] |
||||||||||||||||||||||||||||||
|
14.51 ms (9.60%) |
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 822981 673050 625307 86313 651896 653912 758973 717870 795919 800894 757349 694607 801548 738908 694660 776927 714410 718869 827178 723536 548905 654621 538996 462940 651944 429508 559914 596507 723504 678539 402982 734875 383795 793427 437360 538566 689107 399195 755848 827932 653551 679360 755191 717805 697079 403255 721784 622349 601545 53532 651323 570120 659339 389315 533527 697645 762169 399039 515129 620631 807462 809651 548857 251147 818932 741207 543677 544636 557963 692438 720850 516646 547980 653624 679549 695932 798930 789108 807148 725096 818582 554191 672466 721202 761638 229210 413770 821660 722655 427783 689565 795402 721188 649931 622123 775789 720385 528150 673297 506216 709915 587256 801271 805508 555677 691616 761344 771755 387160 775825 653522 398712 388091 644655 440737 817114 756219 681804 813747 774100 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.93%) |
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 53532 86313 229210 251147 383795 387160 388091 389315 398712 399039 399195 402982 403255 413770 427783 429508 437360 440737 462940 506216 515129 516646 528150 533527 538566 538996 543677 544636 547980 548857 548905 554191 555677 557963 559914 570120 587256 596507 601545 620631 622123 622349 625307 644655 649931 651323 651896 651944 653522 653551 653624 653912 654621 659339 672466 673050 673297 678539 679360 679549 681804 689107 689565 691616 692438 694607 694660 695932 697079 697645 709915 714410 717805 717870 718869 720385 720850 721188 721202 721784 722655 723504 723536 725096 734875 738908 741207 755191 755848 756219 757349 758973 761344 761638 762169 771755 774100 775789 775825 776927 789108 793427 795402 795919 798930 800894 801271 801548 805508 807148 807462 809651 813747 817114 818582 818932 821660 822981 827178 827932 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"two girl sex"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"two девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"two девушк секс"
]
|
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.