Query Metrics
7
Database Queries
7
Different statements
189.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.46 ms (86.76%) |
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 4463 187636 187723 187956 188009 188093 188390 188447 188456 233340 233512 357595 358566 382431 382437 382874 385603 387026 387125 388200 388203 388204 388329 388364 388470 388713 388716 388723 388766 388784 388968 389860 390051 390580 390643 390954 391155 391156 391427 391592 392489 393097 393507 394211 397866 397870 397874 397878 397882 397884 397889 397890 398525 398535 398557 398935 409942 411347 411408 439786 439810 439812 440139 440222 440726 442545 442612 444344 444361 452234 452856 454184 470198 470201 472592 493177 506067 509204 533534 537261 559058 559071 561042 591006 604302 648199 678775 682811 703929 712311 716077 720693 721706 727740 728240 728305 728443 728446 728451 733291 737169 739955 740792 741896 748245 759808 765632 766669 766671 770139 774144 774187 774200 780634 789552 802463 817308 824019 824263 826784 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (8.24%) |
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 397866 604302 452856 703929 748245 472592 470201 439810 824019 444361 388204 682811 591006 770139 533534 454184 388784 397889 391592 493177 559071 452234 559058 440222 382437 442612 442545 439786 509204 440726 440139 537261 444344 439812 390643 391155 388364 391427 388723 390580 388716 187956 388329 728451 409942 397870 382431 733291 390051 389860 398557 393097 388470 358566 233512 740792 739955 411347 789552 382874 188009 780634 774200 398935 388713 648199 387026 802463 388200 388203 390954 774144 388766 817308 4463 826784 397874 506067 774187 824263 720693 678775 233340 398525 727740 765632 561042 385603 766669 737169 357595 470198 188456 188390 728305 716077 728240 398535 397890 712311 397878 393507 387125 397884 766671 741896 388968 391156 187636 187723 721706 392489 397882 394211 411408 188447 188093 759808 728443 728446 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.39%) |
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 4463 187636 187723 187956 188009 188093 188390 188447 188456 233340 233512 357595 358566 382431 382437 382874 385603 387026 387125 388200 388203 388204 388329 388364 388470 388713 388716 388723 388766 388784 388968 389860 390051 390580 390643 390954 391155 391156 391427 391592 392489 393097 393507 394211 397866 397870 397874 397878 397882 397884 397889 397890 398525 398535 398557 398935 409942 411347 411408 439786 439810 439812 440139 440222 440726 442545 442612 444344 444361 452234 452856 454184 470198 470201 472592 493177 506067 509204 533534 537261 559058 559071 561042 591006 604302 648199 678775 682811 703929 712311 716077 720693 721706 727740 728240 728305 728443 728446 728451 733291 737169 739955 740792 741896 748245 759808 765632 766669 766671 770139 774144 774187 774200 780634 789552 802463 817308 824019 824263 826784 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal fuck"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал секс"
]
|
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.