Query Metrics
7
Database Queries
7
Different statements
159.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.62 ms (85.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 193895 238115 382130 382637 383498 385923 398954 418997 423299 425971 433704 457993 460477 479885 481662 490395 513721 529691 531788 533602 533976 536352 540138 551527 592843 593605 604850 609177 618402 620238 657791 681613 705353 709346 714750 715448 716245 717113 720179 724034 724632 724636 724811 726603 726650 732795 733129 734379 736539 740556 744651 745554 750030 750770 751455 752512 752533 753057 753645 757848 759938 760714 761151 761303 762443 764250 765145 765369 766179 768681 769950 771968 774040 778080 789489 792778 792781 794106 794282 795950 799928 799979 800902 801785 804158 804368 804944 806972 807129 810480 810889 811102 815590 816735 816932 817035 817295 817791 818511 818652 819354 819525 819960 820092 820178 821139 823336 823445 823829 823943 823984 824712 826385 826492 826508 826705 827176 827266 827699 828178 ] |
||||||||||||||||||||||||||||||
|
14.07 ms (8.84%) |
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 795950 799979 800902 804944 810889 724632 724811 768681 769950 724034 733129 734379 745554 752533 753057 759938 760714 765145 736539 750770 752512 753645 757848 761151 762443 765369 766179 774040 726650 732795 750030 751455 761303 609177 705353 709346 714750 715448 717113 720179 778080 789489 792778 792781 794282 799928 801785 804158 806972 807129 810480 811102 425971 423299 817295 460477 457993 513721 536352 551527 681613 593605 592843 604850 618402 794106 740556 771968 726603 744651 764250 620238 716245 804368 398954 479885 657791 724636 385923 383498 238115 193895 382637 382130 418997 433704 817791 819354 819960 820178 826508 826492 826705 816735 818511 819525 823336 823943 823984 827176 815590 816932 817035 820092 821139 826385 818652 823445 823829 824712 828178 827266 827699 490395 481662 533976 529691 531788 533602 540138 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.70%) |
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 193895 238115 382130 382637 383498 385923 398954 418997 423299 425971 433704 457993 460477 479885 481662 490395 513721 529691 531788 533602 533976 536352 540138 551527 592843 593605 604850 609177 618402 620238 657791 681613 705353 709346 714750 715448 716245 717113 720179 724034 724632 724636 724811 726603 726650 732795 733129 734379 736539 740556 744651 745554 750030 750770 751455 752512 752533 753057 753645 757848 759938 760714 761151 761303 762443 764250 765145 765369 766179 768681 769950 771968 774040 778080 789489 792778 792781 794106 794282 795950 799928 799979 800902 801785 804158 804368 804944 806972 807129 810480 810889 811102 815590 816735 816932 817035 817295 817791 818511 818652 819354 819525 819960 820092 820178 821139 823336 823445 823829 823943 823984 824712 826385 826492 826508 826705 827176 827266 827699 828178 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf in glasses"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf очкастая"
]
|
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.