Query Metrics
7
Database Queries
7
Different statements
601.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
413.15 ms (68.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy solo"
]
|
||||||||||||||||||||||||||||||
|
167.80 ms (27.88%) |
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 82307 133707 145666 263548 383080 385941 389766 398277 417608 436450 444086 466394 488908 493820 500287 510737 513851 514239 527469 527475 527482 530974 533302 535995 538286 538598 539403 553228 564955 569564 571204 581195 582505 588221 588233 598315 600277 606795 618547 629746 631183 631301 637303 642396 646819 648570 652052 661066 664723 665770 665948 666045 669855 669989 672840 674231 679499 686972 697540 706024 707394 707478 708594 708622 708748 709679 714687 715291 733400 734846 736070 736978 742303 742421 743658 749069 751389 752562 755354 755499 757518 760585 763467 766412 773029 774198 785857 786777 787697 788024 790275 791549 794054 798755 801643 803549 804300 804420 804678 804761 809295 813334 814352 814394 818752 819062 819239 819784 820082 820793 821517 823861 824858 824868 825866 827025 827391 827457 827635 827703 ] |
||||||||||||||||||||||||||||||
|
12.65 ms (2.10%) |
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 757518 618547 706024 709679 436450 263548 514239 385941 819062 818752 666045 553228 588233 606795 600277 733400 734846 760585 794054 82307 564955 814394 664723 466394 819784 488908 493820 661066 637303 809295 755354 773029 383080 825866 827025 827391 820082 821517 827457 827635 539403 530974 571204 646819 665948 714687 582505 629746 642396 631183 791549 804761 813334 798755 766412 774198 787697 788024 736070 755499 763467 749069 752562 786777 790275 814352 652052 669989 648570 686972 743658 736978 824868 527469 527475 513851 527482 538598 581195 665770 669855 674231 679499 697540 672840 708594 708622 707478 708748 715291 569564 598315 588221 804300 804678 803549 785857 742303 751389 742421 631301 707394 801643 804420 417608 444086 500287 510737 145666 133707 389766 398277 820793 827703 824858 819239 823861 533302 535995 538286 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (0.50%) |
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 82307 133707 145666 263548 383080 385941 389766 398277 417608 436450 444086 466394 488908 493820 500287 510737 513851 514239 527469 527475 527482 530974 533302 535995 538286 538598 539403 553228 564955 569564 571204 581195 582505 588221 588233 598315 600277 606795 618547 629746 631183 631301 637303 642396 646819 648570 652052 661066 664723 665770 665948 666045 669855 669989 672840 674231 679499 686972 697540 706024 707394 707478 708594 708622 708748 709679 714687 715291 733400 734846 736070 736978 742303 742421 743658 749069 751389 752562 755354 755499 757518 760585 763467 766412 773029 774198 785857 786777 787697 788024 790275 791549 794054 798755 801643 803549 804300 804420 804678 804761 809295 813334 814352 814394 818752 819062 819239 819784 820082 820793 821517 823861 824858 824868 825866 827025 827391 827457 827635 827703 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy соло"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy соло"
]
|
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.