Query Metrics
7
Database Queries
7
Different statements
513.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
488.60 ms (95.07%) |
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 24374 388777 389966 391911 391992 398968 401214 405070 405252 411747 420178 421326 422235 423332 424410 424444 425967 426295 427241 428174 428238 429916 437305 443184 447895 450794 451491 452244 453062 453178 454177 454234 454247 458000 458419 460593 460680 460757 460908 462572 463973 464373 466051 467034 470768 470918 471075 472640 473391 475289 475683 483250 484362 489187 493980 494978 496063 496550 499862 501553 505460 505671 508254 509637 509679 512542 512947 513857 517444 517687 517697 520682 526213 527088 528100 528474 530530 531538 536637 537870 543708 543938 554883 559350 566076 567418 569300 569832 573196 576616 577132 578323 578733 578798 580841 581098 583966 583990 584352 584627 594560 595097 605513 605702 607034 618952 618969 619140 619604 625172 628582 632083 635336 646243 667344 690882 740277 746686 792580 823956 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (3.33%) |
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 508254 509637 499862 512542 517444 517697 531538 501553 512947 513857 530530 460680 493980 543708 554883 577132 584627 573196 566076 567418 578733 578798 583990 667344 690882 580841 618952 628582 618969 594560 605513 607034 619140 619604 595097 605702 792580 746686 740277 632083 635336 424410 454234 466051 470768 471075 405252 424444 454247 460908 462572 470918 391992 401214 420178 421326 429916 453062 460757 388777 398968 405070 443184 454177 458000 472640 422235 451491 496063 484362 489187 528474 460593 581098 463973 389966 467034 505671 24374 625172 473391 437305 475289 505460 823956 458419 494978 391911 423332 411747 426295 428238 425967 427241 428174 453178 464373 483250 447895 450794 452244 496550 526213 537870 527088 528100 520682 536637 509679 517687 475683 569832 578323 543938 559350 569300 583966 584352 646243 576616 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (0.55%) |
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 24374 388777 389966 391911 391992 398968 401214 405070 405252 411747 420178 421326 422235 423332 424410 424444 425967 426295 427241 428174 428238 429916 437305 443184 447895 450794 451491 452244 453062 453178 454177 454234 454247 458000 458419 460593 460680 460757 460908 462572 463973 464373 466051 467034 470768 470918 471075 472640 473391 475289 475683 483250 484362 489187 493980 494978 496063 496550 499862 501553 505460 505671 508254 509637 509679 512542 512947 513857 517444 517687 517697 520682 526213 527088 528100 528474 530530 531538 536637 537870 543708 543938 554883 559350 566076 567418 569300 569832 573196 576616 577132 578323 578733 578798 580841 581098 583966 583990 584352 584627 594560 595097 605513 605702 607034 618952 618969 619140 619604 625172 628582 632083 635336 646243 667344 690882 740277 746686 792580 823956 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf chubby hairy"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf chubby волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.16 ms (0.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf chubby волосатая"
]
|
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.