Query Metrics
7
Database Queries
7
Different statements
188.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.35 ms (84.67%) |
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 145335 163761 311237 359011 365962 382387 382405 382937 388570 388769 389860 395133 395938 396887 405409 407835 409901 411604 453091 460040 474122 476266 476346 490903 544466 544504 552582 555022 555076 566327 570909 614789 641652 665219 666111 693399 710579 717711 718996 720008 720583 720591 726476 726479 726503 726557 728337 728442 728451 731818 732258 733079 736386 736402 738327 739955 740792 741437 741780 741896 742879 743811 744211 744801 758430 766669 772120 773550 774187 774766 780634 780673 781932 785922 789531 789537 794698 795045 797278 800976 802147 804030 807336 808049 808518 808527 808690 810056 812505 816771 817772 817810 818593 818966 818980 819006 819014 819015 820384 820687 820689 823691 823800 823857 823915 824021 824145 824265 824320 824905 825137 825143 826235 826346 826784 827054 827083 827085 827326 828612 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (8.80%) |
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 789537 824320 145335 544466 807336 772120 736402 728442 824145 789531 794698 742879 818593 395133 825137 570909 720008 781932 816771 544504 476346 718996 766669 395938 614789 804030 810056 738327 726476 726479 726557 411604 566327 808527 396887 802147 774766 382937 819014 409901 826235 693399 758430 785922 808518 476266 817810 826346 828612 827054 728451 820384 826784 823915 665219 710579 797278 736386 717711 382387 825143 552582 800976 731818 827083 820687 795045 812505 808049 823857 720583 774187 405409 827326 474122 555076 726503 741437 741780 808690 453091 460040 388769 407835 490903 823800 819006 818966 823691 773550 163761 359011 382405 824265 666111 720591 732258 311237 365962 388570 389860 780634 740792 741896 739955 743811 824905 827085 819015 820689 817772 824021 818980 555022 641652 780673 744211 744801 728337 733079 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.24%) |
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 145335 163761 311237 359011 365962 382387 382405 382937 388570 388769 389860 395133 395938 396887 405409 407835 409901 411604 453091 460040 474122 476266 476346 490903 544466 544504 552582 555022 555076 566327 570909 614789 641652 665219 666111 693399 710579 717711 718996 720008 720583 720591 726476 726479 726503 726557 728337 728442 728451 731818 732258 733079 736386 736402 738327 739955 740792 741437 741780 741896 742879 743811 744211 744801 758430 766669 772120 773550 774187 774766 780634 780673 781932 785922 789531 789537 794698 795045 797278 800976 802147 804030 807336 808049 808518 808527 808690 810056 812505 816771 817772 817810 818593 818966 818980 819006 819014 819015 820384 820687 820689 823691 823800 823857 823915 824021 824145 824265 824320 824905 825137 825143 826235 826346 826784 827054 827083 827085 827326 828612 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature pussy"
]
|
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.