Query Metrics
7
Database Queries
7
Different statements
140.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.52 ms (85.12%) |
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 383773 386060 386303 387268 391076 393749 393790 394184 399190 400436 400443 400471 402078 402254 411722 418493 429257 443365 445058 456885 458058 462306 463161 464145 465816 466635 467296 475453 484129 491646 494352 494356 503901 505288 505497 515124 515194 515201 515245 515294 519064 520716 520774 523274 541912 545526 550440 550445 550601 557330 558059 559344 561583 566514 566515 569661 570051 578464 586629 587929 590224 597574 598777 604048 605469 607193 610067 615112 621620 624276 628143 628303 641439 642779 663473 663883 665883 666163 669436 676472 676951 684205 689370 694600 695758 696313 707011 712794 714390 714432 718705 722114 722654 722673 722679 730254 730378 730851 732387 734842 738256 738766 740300 741646 743415 754895 759658 760925 767956 773540 777345 779832 789038 789304 814065 815780 817367 817677 818370 823802 ] |
||||||||||||||||||||||||||||||
|
12.49 ms (8.89%) |
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 696313 598777 610067 605469 730254 767956 604048 400436 393749 402078 523274 464145 624276 741646 429257 515294 815780 823802 665883 714390 722114 557330 561583 628143 628303 789038 730851 621620 743415 754895 760925 491646 505288 559344 386303 386060 383773 400443 400471 445058 467296 515124 550445 558059 570051 550601 550440 676951 669436 587929 590224 738766 734842 759658 642779 394184 463161 391076 393790 418493 475453 458058 503901 519064 402254 541912 684205 641439 738256 456885 817367 663883 722679 730378 387268 520716 578464 566514 569661 663473 545526 566515 597574 607193 777345 740300 732387 714432 462306 443365 466635 411722 494352 494356 505497 718705 615112 484129 515194 666163 773540 465816 520774 676472 695758 694600 779832 818370 707011 722673 399190 586629 515201 817677 814065 515245 712794 722654 689370 789304 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.49%) |
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 383773 386060 386303 387268 391076 393749 393790 394184 399190 400436 400443 400471 402078 402254 411722 418493 429257 443365 445058 456885 458058 462306 463161 464145 465816 466635 467296 475453 484129 491646 494352 494356 503901 505288 505497 515124 515194 515201 515245 515294 519064 520716 520774 523274 541912 545526 550440 550445 550601 557330 558059 559344 561583 566514 566515 569661 570051 578464 586629 587929 590224 597574 598777 604048 605469 607193 610067 615112 621620 624276 628143 628303 641439 642779 663473 663883 665883 666163 669436 676472 676951 684205 689370 694600 695758 696313 707011 712794 714390 714432 718705 722114 722654 722673 722679 730254 730378 730851 732387 734842 738256 738766 740300 741646 743415 754895 759658 760925 767956 773540 777345 779832 789038 789304 814065 815780 817367 817677 818370 823802 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young sex"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young секс"
]
|
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.