Query Metrics
7
Database Queries
7
Different statements
174.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.76 ms (87.10%) |
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 391317 408620 424198 424762 424764 427035 429540 434306 443843 445972 446788 454516 454711 454725 454899 471031 473087 473096 478516 479351 490592 490599 490622 499865 499927 521242 528943 529004 530422 533495 537545 540860 540862 541136 543317 549640 550356 554305 557348 557709 559412 562440 563598 565808 571049 571050 573996 575391 579247 581130 584304 585784 585806 588615 588748 588811 589868 589936 589991 592531 595964 600548 603525 609585 611066 613002 623696 641176 641652 645389 652986 659475 659476 661063 661511 661514 661534 661540 662424 666101 666455 667987 670265 680718 680764 680788 715103 720133 726457 739949 742335 743231 743234 743236 743246 743247 743251 743256 743262 743268 743270 743271 743272 749493 749593 750514 752473 753630 754602 780886 780889 793033 796071 796397 803189 810498 810889 811917 812238 820026 ] |
||||||||||||||||||||||||||||||
|
12.09 ms (6.94%) |
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 743234 424762 652986 623696 641652 589868 743246 549640 661540 666101 557348 585806 609585 793033 803189 810498 752473 662424 659476 661514 661534 611066 743262 796397 749493 743272 749593 715103 810889 811917 743247 540860 490622 571049 645389 585784 613002 588748 726457 743268 424764 471031 588615 528943 533495 589991 429540 661511 563598 743236 603525 641176 820026 537545 754602 743251 743231 521242 573996 600548 812238 739949 743271 753630 445972 473096 667987 588811 750514 443843 434306 490592 427035 454899 391317 446788 499927 541136 581130 584304 575391 659475 670265 680764 796071 454725 454711 529004 530422 562440 661063 666455 680788 720133 554305 579247 595964 780889 743256 743270 742335 780886 408620 454516 478516 559412 473087 571050 540862 565808 680718 557709 592531 589936 424198 479351 499865 490599 543317 550356 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (2.00%) |
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 391317 408620 424198 424762 424764 427035 429540 434306 443843 445972 446788 454516 454711 454725 454899 471031 473087 473096 478516 479351 490592 490599 490622 499865 499927 521242 528943 529004 530422 533495 537545 540860 540862 541136 543317 549640 550356 554305 557348 557709 559412 562440 563598 565808 571049 571050 573996 575391 579247 581130 584304 585784 585806 588615 588748 588811 589868 589936 589991 592531 595964 600548 603525 609585 611066 613002 623696 641176 641652 645389 652986 659475 659476 661063 661511 661514 661534 661540 662424 666101 666455 667987 670265 680718 680764 680788 715103 720133 726457 739949 742335 743231 743234 743236 743246 743247 743251 743256 743262 743268 743270 743271 743272 749493 749593 750514 752473 753630 754602 780886 780889 793033 796071 796397 803189 810498 810889 811917 812238 820026 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo skinny hairy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло худые волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло худые волосатая"
]
|
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.