Query Metrics
7
Database Queries
7
Different statements
149.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.22 ms (83.59%) |
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 7108 7365 32874 32937 33443 37057 95788 96819 101841 151163 183126 193662 258915 327981 366283 382183 382344 385373 388094 389978 390318 397958 399389 400325 402547 417884 463953 464029 489276 498821 515691 530159 530397 535083 537630 558779 560456 561265 569160 576985 591626 604493 605203 606240 617074 618285 624329 630712 630985 638087 639315 642377 644246 650902 656544 669224 673776 678816 681609 688100 689161 689434 694476 698286 711005 712887 714040 715068 715360 716223 719950 720015 721407 722534 722552 726634 734049 735848 737720 739717 741306 744261 744443 744468 744991 744993 746837 754923 756382 756510 759362 764175 768944 772755 774058 780625 780710 782861 786749 786759 789094 789153 790955 791752 796598 797105 797385 797387 801829 802293 803136 803836 806121 806220 806460 807697 811574 817854 820849 828869 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (9.72%) |
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 638087 789094 791752 382183 390318 402547 385373 258915 820849 569160 656544 673776 678816 639315 644246 786749 746837 797387 735848 741306 744993 759362 764175 756510 772755 774058 618285 780710 801829 183126 400325 828869 535083 537630 561265 711005 719950 720015 694476 715068 576985 630985 796598 803136 797385 802293 744991 744443 605203 464029 790955 327981 95788 417884 712887 96819 399389 33443 7365 389978 817854 463953 489276 530159 515691 498821 560456 558779 681609 689434 714040 715360 722552 650902 669224 716223 721407 689161 624329 642377 591626 786759 789153 811574 780625 782861 737720 739717 744468 797105 803836 806121 806460 807697 754923 744261 726634 734049 756382 768944 617074 698286 722534 806220 382344 193662 32937 7108 530397 688100 604493 630712 606240 366283 101841 397958 151163 37057 32874 388094 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.91%) |
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 7108 7365 32874 32937 33443 37057 95788 96819 101841 151163 183126 193662 258915 327981 366283 382183 382344 385373 388094 389978 390318 397958 399389 400325 402547 417884 463953 464029 489276 498821 515691 530159 530397 535083 537630 558779 560456 561265 569160 576985 591626 604493 605203 606240 617074 618285 624329 630712 630985 638087 639315 642377 644246 650902 656544 669224 673776 678816 681609 688100 689161 689434 694476 698286 711005 712887 714040 715068 715360 716223 719950 720015 721407 722534 722552 726634 734049 735848 737720 739717 741306 744261 744443 744468 744991 744993 746837 754923 756382 756510 759362 764175 768944 772755 774058 780625 780710 782861 786749 786759 789094 789153 790955 791752 796598 797105 797385 797387 801829 802293 803136 803836 806121 806220 806460 807697 811574 817854 820849 828869 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black fuck"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black секс"
]
|
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.