Query Metrics
7
Database Queries
7
Different statements
156.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.82 ms (82.41%) |
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 187800 188420 382549 391565 404678 407362 407835 411249 411777 411781 419146 439627 439702 439784 439786 442377 442545 442612 442912 443278 443731 444045 444361 444502 450305 451985 452145 452936 454080 454212 454245 457791 459128 459131 462076 463761 464214 464334 466011 466215 466836 467045 467457 467524 471390 471421 473818 474022 474627 474810 474844 475683 476246 479030 479082 484620 484660 485442 485768 485978 485989 486346 487326 488619 490418 490430 490846 490926 491899 491910 493127 504423 506042 506052 509554 509620 510882 512536 512943 515068 515986 517013 518927 519046 535436 560905 563087 563134 564816 571809 581931 589681 590418 602974 614523 617440 623831 633115 665960 681301 681312 714613 722281 726483 727742 728345 731804 731844 732253 733265 733375 739178 742786 746052 756241 761191 768330 796094 797259 811118 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (10.92%) |
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 623831 727742 731804 756241 728345 726483 733375 614523 459131 391565 479030 407835 485978 491910 411781 474810 471421 452145 473818 474844 485768 450305 488619 474022 476246 560905 564816 443731 444502 485989 509620 517013 581931 681312 722281 665960 633115 797259 731844 742786 761191 768330 746052 617440 404678 486346 490926 411249 187800 510882 512536 732253 467457 467045 491899 485442 535436 188420 463761 464334 457791 519046 515068 475683 563134 681301 590418 459128 462076 504423 518927 493127 464214 714613 796094 733265 811118 739178 490846 407362 512943 571809 382549 467524 484620 509554 589681 602974 442545 439627 439784 439786 466836 439702 442912 444361 452936 454212 454245 474627 442377 442612 443278 444045 484660 490430 451985 506052 563087 466215 454080 466011 479082 506042 490418 515986 487326 411777 419146 471390 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.81%) |
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 187800 188420 382549 391565 404678 407362 407835 411249 411777 411781 419146 439627 439702 439784 439786 442377 442545 442612 442912 443278 443731 444045 444361 444502 450305 451985 452145 452936 454080 454212 454245 457791 459128 459131 462076 463761 464214 464334 466011 466215 466836 467045 467457 467524 471390 471421 473818 474022 474627 474810 474844 475683 476246 479030 479082 484620 484660 485442 485768 485978 485989 486346 487326 488619 490418 490430 490846 490926 491899 491910 493127 504423 506042 506052 509554 509620 510882 512536 512943 515068 515986 517013 518927 519046 535436 560905 563087 563134 564816 571809 581931 589681 590418 602974 614523 617440 623831 633115 665960 681301 681312 714613 722281 726483 727742 728345 731804 731844 732253 733265 733375 739178 742786 746052 756241 761191 768330 796094 797259 811118 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big vagina mature"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие вагин mature"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
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.