Query Metrics
7
Database Queries
7
Different statements
205.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.42 ms (86.64%) |
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 4450 61635 166116 334847 359134 387895 390134 391002 395134 395141 401766 409668 422806 425656 426012 434193 443734 445667 446286 447416 460679 462469 467800 480833 484387 488302 489257 493094 505970 509473 510022 516473 534228 545694 549163 549583 550616 550653 555750 555793 557158 564802 565144 565826 567537 570395 571004 588546 593186 607192 609697 614832 615015 618462 622198 644679 649082 650494 652187 656761 660918 662222 663884 664321 664958 665100 665455 666020 666093 666777 667017 667317 668141 669768 677027 683924 684963 693341 694610 700659 700752 712821 718203 726561 728483 739687 742235 747216 747954 748229 748337 750782 770093 773024 775148 775811 775830 776020 779452 779798 780701 780707 788440 788734 790256 795578 803017 807490 808474 810728 812299 815010 815713 816561 816764 817394 817463 818444 821102 823196 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (7.76%) |
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 443734 488302 534228 489257 684963 447416 516473 510022 484387 509473 545694 570395 550653 565144 564802 666777 694610 666093 668141 677027 712821 700752 550616 555793 571004 609697 644679 607192 588546 618462 622198 808474 742235 739687 748229 748337 750782 726561 728483 747954 614832 718203 387895 334847 467800 480833 446286 549583 667017 567537 593186 615015 462469 409668 664958 395141 395134 390134 391002 817394 816561 815010 493094 649082 549163 779798 780707 790256 795578 807490 775148 775830 776020 788734 812299 788440 803017 810728 770093 747216 773024 775811 779452 780701 4450 61635 359134 422806 166116 401766 425656 426012 434193 818444 816764 817463 823196 815713 821102 460679 445667 505970 555750 557158 565826 650494 652187 656761 664321 665455 667317 669768 683924 693341 700659 660918 662222 663884 665100 666020 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (1.98%) |
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 4450 61635 166116 334847 359134 387895 390134 391002 395134 395141 401766 409668 422806 425656 426012 434193 443734 445667 446286 447416 460679 462469 467800 480833 484387 488302 489257 493094 505970 509473 510022 516473 534228 545694 549163 549583 550616 550653 555750 555793 557158 564802 565144 565826 567537 570395 571004 588546 593186 607192 609697 614832 615015 618462 622198 644679 649082 650494 652187 656761 660918 662222 663884 664321 664958 665100 665455 666020 666093 666777 667017 667317 668141 669768 677027 683924 684963 693341 694610 700659 700752 712821 718203 726561 728483 739687 742235 747216 747954 748229 748337 750782 770093 773024 775148 775811 775830 776020 779452 779798 780701 780707 788440 788734 790256 795578 803017 807490 808474 810728 812299 815010 815713 816561 816764 817394 817463 818444 821102 823196 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob old"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член old"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член old"
]
|
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.