Query Metrics
7
Database Queries
7
Different statements
204.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.63 ms (87.18%) |
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 150305 185011 193883 226028 346209 385342 393937 398902 400996 411721 418544 422384 431465 436828 442136 449421 453151 464954 486243 486551 498896 503176 503196 512034 539553 541461 544020 544694 545014 551727 556166 558715 561660 565994 575433 576462 580989 581915 584721 591420 599398 604637 606372 609835 617844 622127 624015 626196 626878 629243 633917 639643 642149 651102 651636 653807 660072 665346 669295 671004 674241 679053 693782 697770 705934 707145 708182 712809 712912 714542 715265 715266 723538 731185 732128 732131 732793 733320 736493 740954 741729 743745 744266 744509 747082 754448 760016 760604 762035 765941 766401 770268 770605 777278 786352 788721 790243 791382 795219 798636 798783 800019 800301 801725 802536 802649 803348 805166 807576 807584 807781 810512 811991 812317 812476 815597 816182 816300 818118 823617 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (7.39%) |
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 754448 770605 798783 811991 422384 226028 671004 714542 653807 665346 803348 464954 823617 486551 498896 697770 639643 807584 747082 436828 150305 346209 541461 715265 556166 626878 800301 185011 723538 503176 558715 626196 604637 812476 818118 816182 539553 544694 551727 693782 715266 545014 609835 617844 606372 788721 812317 795219 807781 743745 765941 740954 791382 584721 712809 418544 512034 705934 805166 385342 193883 651636 660072 802536 732793 807576 400996 544020 679053 786352 732128 766401 736493 731185 800019 393937 398902 442136 580989 561660 707145 642149 599398 810512 449421 486243 575433 802649 760016 760604 741729 744509 744266 629243 770268 815597 453151 565994 576462 581915 674241 651102 669295 633917 591420 622127 624015 801725 733320 762035 732131 708182 712912 777278 411721 431465 503196 816300 798636 790243 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.27%) |
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 150305 185011 193883 226028 346209 385342 393937 398902 400996 411721 418544 422384 431465 436828 442136 449421 453151 464954 486243 486551 498896 503176 503196 512034 539553 541461 544020 544694 545014 551727 556166 558715 561660 565994 575433 576462 580989 581915 584721 591420 599398 604637 606372 609835 617844 622127 624015 626196 626878 629243 633917 639643 642149 651102 651636 653807 660072 665346 669295 671004 674241 679053 693782 697770 705934 707145 708182 712809 712912 714542 715265 715266 723538 731185 732128 732131 732793 733320 736493 740954 741729 743745 744266 744509 747082 754448 760016 760604 762035 765941 766401 770268 770605 777278 786352 788721 790243 791382 795219 798636 798783 800019 800301 801725 802536 802649 803348 805166 807576 807584 807781 810512 811991 812317 812476 815597 816182 816300 818118 823617 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс fun"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex fun"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс fun"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.