Query Metrics
7
Database Queries
7
Different statements
161.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.28 ms (85.73%) |
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 393798 416162 445716 504625 506626 529831 535281 544029 544882 544904 545155 546163 546181 546232 546243 548343 550426 550548 550923 551774 552532 553218 553220 553222 553226 554675 554679 554698 554708 556114 559418 561792 562584 572636 572723 572728 575922 576584 576610 577033 577247 577278 577952 588022 602287 617163 617535 627563 630961 631899 650609 651797 666389 669257 685305 706117 706643 707724 710150 711695 720570 726138 726172 728888 732936 733899 734203 734841 736724 740255 744143 744815 745295 746367 747990 748630 748966 749045 760569 761249 767746 769096 772439 775648 781268 786877 788297 791854 792339 793247 794457 803564 804684 806806 809679 809731 817363 819687 820161 821757 823744 824073 824655 824850 824853 824885 824926 825028 825125 825128 825182 826357 826564 826956 826979 827171 827207 827225 827438 827529 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (8.73%) |
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 803564 824926 576610 577278 746367 823744 793247 416162 529831 825128 820161 544882 576584 775648 825125 546181 827529 824655 827171 559418 588022 824073 826956 553222 561792 562584 554708 685305 666389 669257 546243 575922 577952 627563 748966 506626 553218 711695 761249 572723 651797 827225 827438 821757 825028 825182 535281 552532 554698 572728 553220 553226 577033 733899 769096 781268 747990 732936 740255 734841 602287 788297 791854 826357 827207 826979 548343 545155 794457 806806 804684 748630 809679 734203 767746 744143 504625 577247 710150 650609 706117 546163 546232 617535 631899 617163 630961 706643 707724 550548 572636 760569 393798 826564 824885 824853 445716 544029 544904 550426 550923 554679 551774 720570 792339 744815 749045 772439 786877 726172 728888 736724 745295 726138 809731 817363 819687 824850 554675 556114 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.61%) |
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 393798 416162 445716 504625 506626 529831 535281 544029 544882 544904 545155 546163 546181 546232 546243 548343 550426 550548 550923 551774 552532 553218 553220 553222 553226 554675 554679 554698 554708 556114 559418 561792 562584 572636 572723 572728 575922 576584 576610 577033 577247 577278 577952 588022 602287 617163 617535 627563 630961 631899 650609 651797 666389 669257 685305 706117 706643 707724 710150 711695 720570 726138 726172 728888 732936 733899 734203 734841 736724 740255 744143 744815 745295 746367 747990 748630 748966 749045 760569 761249 767746 769096 772439 775648 781268 786877 788297 791854 792339 793247 794457 803564 804684 806806 809679 809731 817363 819687 820161 821757 823744 824073 824655 824850 824853 824885 824926 825028 825125 825128 825182 826357 826564 826956 826979 827171 827207 827225 827438 827529 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"clit homemade"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"clit домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.84%) |
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.