Query Metrics
7
Database Queries
7
Different statements
211.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.72 ms (87.86%) |
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 131772 396796 398524 450108 450125 454176 459406 459949 462099 466374 466394 466699 466902 469906 470768 471461 473400 474113 474261 477936 492992 496854 506516 507263 509192 509659 510945 523380 527624 527773 531869 534563 544489 547868 550222 557896 558175 571132 572350 589622 590525 615950 626889 687666 698249 698253 698255 706889 715370 717697 724475 725201 725251 725462 726596 726837 728146 728597 730186 732901 733060 733109 733132 733473 734725 734730 734848 735908 735925 735981 738339 740986 746200 747245 761011 787654 789686 790327 790330 790336 790840 793488 794156 794745 795055 795959 796857 797260 800729 800734 800749 801700 802051 803507 803510 804435 804445 804452 804593 808125 817575 817774 818760 819096 819729 823778 824293 824407 824868 825164 825393 826048 826379 826489 826505 826691 826880 827218 827298 827489 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (7.05%) |
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 733109 733132 734848 474261 477936 506516 466374 496854 824868 450125 572350 740986 725462 706889 715370 547868 589622 804445 728146 734725 558175 473400 466699 466394 826489 826691 819096 825393 818760 819729 824293 825164 826379 466902 527773 687666 698255 717697 790327 790330 725201 730186 733473 795055 797260 804593 808125 728597 733060 734730 738339 732901 735981 795959 803510 544489 726837 470768 474113 131772 827489 450108 724475 726596 527624 398524 459949 523380 534563 531869 550222 735908 794745 746200 804435 804452 462099 469906 509192 471461 510945 557896 492992 459406 454176 396796 826048 826505 826880 827298 817575 817774 824407 823778 827218 507263 509659 571132 698253 698249 615950 590525 626889 789686 794156 800729 800749 801700 787654 793488 800734 803507 725251 735925 747245 761011 790336 790840 796857 802051 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.40%) |
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 131772 396796 398524 450108 450125 454176 459406 459949 462099 466374 466394 466699 466902 469906 470768 471461 473400 474113 474261 477936 492992 496854 506516 507263 509192 509659 510945 523380 527624 527773 531869 534563 544489 547868 550222 557896 558175 571132 572350 589622 590525 615950 626889 687666 698249 698253 698255 706889 715370 717697 724475 725201 725251 725462 726596 726837 728146 728597 730186 732901 733060 733109 733132 733473 734725 734730 734848 735908 735925 735981 738339 740986 746200 747245 761011 787654 789686 790327 790330 790336 790840 793488 794156 794745 795055 795959 796857 797260 800729 800734 800749 801700 802051 803507 803510 804435 804445 804452 804593 808125 817575 817774 818760 819096 819729 823778 824293 824407 824868 825164 825393 826048 826379 826489 826505 826691 826880 827218 827298 827489 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature вебкамер pussy"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature webcam pussy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature вебкамер pussy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.