Query Metrics
7
Database Queries
7
Different statements
148.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.71 ms (80.09%) |
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 31758 32030 32553 64934 386085 388024 388410 391371 418713 475636 477529 490592 498630 504625 505366 510894 518008 525729 528544 529831 533839 535281 542529 544029 544882 545155 546229 548343 550530 552532 553217 553218 553220 553222 553226 554675 554679 554689 554698 556057 559418 560500 561792 562584 572722 572723 572728 576569 576584 576610 577010 577033 583651 588022 602287 638471 640878 642966 651797 660315 662867 666389 669257 670399 673045 685305 709676 732936 733899 734203 734841 738248 740255 742080 743193 748297 753607 753711 760569 761249 767746 769096 781268 781775 784065 784620 786909 791433 791854 794457 802221 804684 806806 809577 809679 810397 812336 816131 817363 817566 818205 819687 820161 823443 823744 824073 824573 824655 824850 824853 824885 824926 826357 826564 826979 827225 827438 827529 828319 ] |
||||||||||||||||||||||||||||||
|
20.77 ms (14.01%) |
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 391371 510894 490592 826562 418713 505366 477529 556057 577010 550530 560500 583651 812336 498630 528544 828319 791433 553222 761249 518008 542529 475636 673045 546229 553217 576569 544882 824926 823744 818205 576610 64934 640878 732936 827529 823443 820161 824655 529831 576584 638471 525729 554679 824073 553218 559418 561792 743193 738248 32553 31758 32030 554675 802221 760569 388410 826357 827225 827438 817566 824573 826979 535281 548343 552532 554698 545155 562584 572723 572728 651797 660315 685305 666389 669257 670399 553220 553226 572722 577033 794457 806806 804684 733899 769096 781268 809679 734203 753711 767746 740255 734841 753607 602287 781775 791854 662867 588022 386085 816131 709676 554689 786909 784065 784620 810397 748297 742080 642966 809577 388024 826564 817363 824885 819687 824853 824850 504625 533839 544029 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.45%) |
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 31758 32030 32553 64934 386085 388024 388410 391371 418713 475636 477529 490592 498630 504625 505366 510894 518008 525729 528544 529831 533839 535281 542529 544029 544882 545155 546229 548343 550530 552532 553217 553218 553220 553222 553226 554675 554679 554689 554698 556057 559418 560500 561792 562584 572722 572723 572728 576569 576584 576610 577010 577033 583651 588022 602287 638471 640878 642966 651797 660315 662867 666389 669257 670399 673045 685305 709676 732936 733899 734203 734841 738248 740255 742080 743193 748297 753607 753711 760569 761249 767746 769096 781268 781775 784065 784620 786909 791433 791854 794457 802221 804684 806806 809577 809679 810397 812336 816131 817363 817566 818205 819687 820161 823443 823744 824073 824573 824655 824850 824853 824885 824926 826357 826564 826979 827225 827438 827529 828319 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"clit masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"clit мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"clit мастурбац"
]
|
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.