Query Metrics
7
Database Queries
7
Different statements
272.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
248.67 ms (91.16%) |
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 346209 382585 393937 400996 411721 418544 427258 431465 436828 442136 446760 449421 453151 464954 486243 486551 498896 503176 503196 512034 539553 541461 544020 544694 545014 551727 556166 558715 561660 563857 565994 575433 576462 580989 581915 591420 596704 599398 604637 606372 609835 617844 622127 624015 626196 626878 629243 633917 639643 640219 642149 650797 651102 651636 660072 660286 669295 673497 674241 679053 693782 697770 705934 707145 708182 712809 712912 715265 715266 723538 731185 732128 732131 732793 733320 736493 738928 740954 741729 743745 744266 744509 747017 747082 760016 760604 762035 765941 766401 777278 784452 786352 788721 790243 791382 795219 798636 800019 800301 801725 802536 802649 803348 804757 805166 806447 807576 807781 810512 812317 812476 815597 816182 816300 818118 823617 824498 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (5.56%) |
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 803348 650797 464954 823617 486551 498896 697770 673497 639643 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 712809 418544 824498 512034 705934 806447 805166 784452 193883 651636 660072 802536 732793 807576 400996 544020 679053 596704 786352 732128 766401 736493 731185 800019 393937 442136 580989 561660 707145 642149 599398 810512 446760 449421 486243 575433 802649 760016 760604 741729 744509 744266 629243 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 747017 660286 640219 427258 563857 804757 738928 382585 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (0.94%) |
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 346209 382585 393937 400996 411721 418544 427258 431465 436828 442136 446760 449421 453151 464954 486243 486551 498896 503176 503196 512034 539553 541461 544020 544694 545014 551727 556166 558715 561660 563857 565994 575433 576462 580989 581915 591420 596704 599398 604637 606372 609835 617844 622127 624015 626196 626878 629243 633917 639643 640219 642149 650797 651102 651636 660072 660286 669295 673497 674241 679053 693782 697770 705934 707145 708182 712809 712912 715265 715266 723538 731185 732128 732131 732793 733320 736493 738928 740954 741729 743745 744266 744509 747017 747082 760016 760604 762035 765941 766401 777278 784452 786352 788721 790243 791382 795219 798636 800019 800301 801725 802536 802649 803348 804757 805166 806447 807576 807781 810512 812317 812476 815597 816182 816300 818118 823617 824498 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fun секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fun sex"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fun секс"
]
|
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.