Query Metrics
7
Database Queries
7
Different statements
157.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.36 ms (85.47%) |
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 28568 187542 282542 325867 382579 392971 393350 393550 414720 427543 441424 463868 506257 518366 531175 541359 552748 564301 601102 604186 604303 607261 624209 629174 634138 635339 646211 652927 656085 656615 657230 660714 661411 668091 671594 672629 678813 680284 698124 710909 715124 715396 715657 719524 720682 720768 720811 723934 726176 726217 728735 728762 729835 731280 734990 736336 737643 738021 748434 752148 752545 752717 754584 759796 760481 762228 766776 766785 766800 769749 769754 769822 770306 771352 773268 773421 773751 777132 778850 779681 779730 780849 781341 781368 782544 782573 783345 783618 786199 788661 788912 790531 790548 791216 791506 791849 793138 793449 794859 794877 794908 796920 800903 801297 802152 804550 810323 811148 811655 812049 812094 814502 816679 816985 817215 819719 821136 823611 827685 827966 ] |
||||||||||||||||||||||||||||||
|
13.41 ms (8.53%) |
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 564301 778850 414720 531175 814502 791216 782573 187542 392971 783618 821136 601102 541359 766785 810323 715657 816679 646211 720811 759796 734990 760481 827966 710909 790548 769822 819719 652927 788912 794859 552748 779730 726217 773421 794908 427543 325867 656615 698124 661411 729835 518366 800903 719524 780849 794877 769754 604303 770306 766776 802152 28568 393550 393350 816985 823611 827685 817215 790531 726176 728762 773268 754584 656085 660714 678813 812094 752545 811655 801297 791506 748434 779681 796920 680284 728735 441424 786199 781341 657230 624209 737643 782544 736336 738021 635339 791849 793138 629174 762228 723934 672629 771352 773751 720682 811148 752717 668091 766800 804550 781368 788661 793449 731280 715396 720768 783345 752148 604186 715124 634138 607261 671594 777132 282542 769749 463868 506257 382579 812049 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.85%) |
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 28568 187542 282542 325867 382579 392971 393350 393550 414720 427543 441424 463868 506257 518366 531175 541359 552748 564301 601102 604186 604303 607261 624209 629174 634138 635339 646211 652927 656085 656615 657230 660714 661411 668091 671594 672629 678813 680284 698124 710909 715124 715396 715657 719524 720682 720768 720811 723934 726176 726217 728735 728762 729835 731280 734990 736336 737643 738021 748434 752148 752545 752717 754584 759796 760481 762228 766776 766785 766800 769749 769754 769822 770306 771352 773268 773421 773751 777132 778850 779681 779730 780849 781341 781368 782544 782573 783345 783618 786199 788661 788912 790531 790548 791216 791506 791849 793138 793449 794859 794877 794908 796920 800903 801297 802152 804550 810323 811148 811655 812049 812094 814502 816679 816985 817215 819719 821136 823611 827685 827966 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard anal sex"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard анал секс"
]
|
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.