Query Metrics
7
Database Queries
7
Different statements
154.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.93 ms (83.01%) |
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 339821 382777 383051 384789 386205 386314 393723 393758 393765 393777 394240 397208 398805 400442 400453 400471 402257 403496 408745 413114 416965 418407 418495 429342 430286 430287 430289 432136 445037 446886 447705 453248 464277 464315 464317 464322 466154 467324 471518 480437 484129 484956 488302 488324 488330 488361 491790 511018 515116 515120 515179 515185 515190 515195 515200 515219 515245 515252 515254 520716 520718 520720 523008 525117 528342 529117 548581 550442 550612 551425 558066 559044 566515 566534 568600 569661 569667 569684 569688 578464 585997 587902 597807 605467 610576 624858 638482 644697 665226 665502 669436 670566 682539 693073 700547 700654 701345 714432 714480 722654 722916 733172 743120 743134 744298 744319 744329 755219 759563 759585 759600 759656 759658 759662 778614 789038 789300 823152 823802 825184 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (11.12%) |
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 569667 823802 515254 789038 759600 605467 550442 393758 701345 408745 464277 548581 669436 525117 480437 429342 466154 559044 515252 430287 491790 568600 644697 430286 418407 393777 551425 515195 529117 566534 569684 393723 402257 418495 520718 515116 488330 515190 386205 382777 400471 403496 430289 464315 558066 578464 665226 566515 585997 733172 714432 400453 467324 394240 471518 488361 484956 825184 759585 520720 515200 432136 400442 416965 700547 624858 744329 722916 445037 488302 515219 515179 714480 464322 446886 464317 520716 569661 693073 638482 587902 610576 778614 743120 743134 413114 484129 823152 515245 665502 722654 759656 759662 744298 339821 523008 528342 759563 515185 453248 550612 789300 386314 383051 384789 700654 398805 397208 488324 447705 511018 515120 569688 670566 682539 597807 744319 755219 759658 393765 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.68%) |
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 339821 382777 383051 384789 386205 386314 393723 393758 393765 393777 394240 397208 398805 400442 400453 400471 402257 403496 408745 413114 416965 418407 418495 429342 430286 430287 430289 432136 445037 446886 447705 453248 464277 464315 464317 464322 466154 467324 471518 480437 484129 484956 488302 488324 488330 488361 491790 511018 515116 515120 515179 515185 515190 515195 515200 515219 515245 515252 515254 520716 520718 520720 523008 525117 528342 529117 548581 550442 550612 551425 558066 559044 566515 566534 568600 569661 569667 569684 569688 578464 585997 587902 597807 605467 610576 624858 638482 644697 665226 665502 669436 670566 682539 693073 700547 700654 701345 714432 714480 722654 722916 733172 743120 743134 744298 744319 744329 755219 759563 759585 759600 759656 759658 759662 778614 789038 789300 823152 823802 825184 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дед и молодая порно"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старый молодая девушк порн"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.92%) |
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.