Query Metrics
7
Database Queries
7
Different statements
189.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.75 ms (86.49%) |
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 358200 384106 403131 417226 422243 423948 426148 426648 436829 439578 439909 441334 445926 451008 454843 454865 460761 462944 463496 463772 466081 466228 466879 467914 468328 469284 470184 470867 473136 477739 485969 499527 500176 504321 511818 517566 520271 520277 521936 522053 527898 533553 540948 544568 557245 594023 594195 603941 609809 622252 650642 663834 668741 676415 685220 689145 691358 691998 693234 695838 698081 701928 704336 705440 706547 706752 707692 707695 709581 714966 715140 722088 724370 725455 726215 726700 734629 739616 743003 745154 745966 749972 750525 753602 753966 757262 760858 764032 768550 771778 772850 780369 780589 783427 783801 787321 788514 790605 792223 793817 794504 796530 799991 800183 800189 800203 802853 803904 804144 814327 814521 816697 819142 819657 824006 824206 824508 826312 826645 826888 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (7.63%) |
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 466228 722088 676415 693234 698081 709581 463772 706752 466081 441334 454843 477739 417226 423948 473136 469284 468328 499527 520271 520277 826312 824006 824206 804144 793817 760858 734629 780369 403131 540948 701928 695838 783427 467914 819657 790605 650642 603941 745966 753602 792223 358200 826645 796530 724370 743003 426648 422243 436829 511818 544568 485969 594023 500176 522053 527898 384106 685220 803904 753966 750525 707692 622252 439578 460761 466879 707695 504321 826888 816697 824508 783801 799991 800203 802853 725455 787321 739616 768550 745154 726215 749972 757262 771778 772850 715140 800183 726700 689145 663834 668741 691358 788514 691998 794504 463496 445926 451008 470184 557245 594195 462944 439909 517566 521936 800189 814521 780589 426148 454865 470867 533553 704336 706547 705440 609809 819142 814327 714966 764032 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (1.85%) |
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 358200 384106 403131 417226 422243 423948 426148 426648 436829 439578 439909 441334 445926 451008 454843 454865 460761 462944 463496 463772 466081 466228 466879 467914 468328 469284 470184 470867 473136 477739 485969 499527 500176 504321 511818 517566 520271 520277 521936 522053 527898 533553 540948 544568 557245 594023 594195 603941 609809 622252 650642 663834 668741 676415 685220 689145 691358 691998 693234 695838 698081 701928 704336 705440 706547 706752 707692 707695 709581 714966 715140 722088 724370 725455 726215 726700 734629 739616 743003 745154 745966 749972 750525 753602 753966 757262 760858 764032 768550 771778 772850 780369 780589 783427 783801 787321 788514 790605 792223 793817 794504 796530 799991 800183 800189 800203 802853 803904 804144 814327 814521 816697 819142 819657 824006 824206 824508 826312 826645 826888 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 mature homemade"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз mature 69 домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз mature 69 домашн любительск"
]
|
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.