Query Metrics
7
Database Queries
7
Different statements
143.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.75 ms (83.72%) |
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 23524 76011 258166 390039 398017 400737 460128 466735 490989 507862 518974 521449 523611 532805 532894 539363 540517 617403 686779 703887 716549 719120 726746 734650 735890 736491 736955 742003 743724 744343 745196 754235 755868 760886 771919 781962 789053 789152 794747 797176 797826 797861 798858 801530 804606 809273 812207 815230 815335 815407 815528 815633 815724 815780 816600 816865 816910 816953 817021 817504 818329 818485 818600 818622 818641 818646 818725 818767 818880 819108 819666 819921 819998 820015 820051 820285 820411 820541 821108 821168 821185 821244 821326 821564 821615 821663 821679 822055 822148 822217 822239 822262 822418 822545 822758 822814 823114 823130 823432 823525 823553 823571 823618 823690 823802 823864 823869 824376 824446 824470 824594 824622 825634 825802 826517 826544 826552 827010 827856 ] |
||||||||||||||||||||||||||||||
|
12.69 ms (8.88%) |
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 789152 797176 801530 742003 755868 760886 789053 797826 797861 804606 736491 736955 754235 770353 744343 771919 726746 735890 745196 734650 743724 617403 703887 716549 719120 794747 798858 809273 812207 398017 258166 23524 76011 818485 686779 781962 390039 400737 815335 816865 816910 817504 818600 818641 818880 821326 821663 822148 822217 822239 822545 822758 822814 823114 824446 824470 826544 826552 826517 815780 816600 818767 819921 819998 820051 820285 820541 821168 821185 821244 821564 821615 823553 823571 823802 825802 827010 815528 816953 817021 818329 818622 818646 818725 819108 820015 820411 821679 822418 823130 823432 823525 823869 824622 825634 815230 815407 815633 815724 819666 821108 822055 822262 823618 823690 823864 824376 824594 827856 490989 460128 466735 507862 521449 532805 518974 523611 532894 540517 539363 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (2.26%) |
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 23524 76011 258166 390039 398017 400737 460128 466735 490989 507862 518974 521449 523611 532805 532894 539363 540517 617403 686779 703887 716549 719120 726746 734650 735890 736491 736955 742003 743724 744343 745196 754235 755868 760886 771919 781962 789053 789152 794747 797176 797826 797861 798858 801530 804606 809273 812207 815230 815335 815407 815528 815633 815724 815780 816600 816865 816910 816953 817021 817504 818329 818485 818600 818622 818641 818646 818725 818767 818880 819108 819666 819921 819998 820015 820051 820285 820411 820541 821108 821168 821185 821244 821326 821564 821615 821663 821679 822055 822148 822217 822239 822262 822418 822545 822758 822814 823114 823130 823432 823525 823553 823571 823618 823690 823802 823864 823869 824376 824446 824470 824594 824622 825634 825802 826517 826544 826552 827010 827856 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob ass"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс жоп"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.15%) |
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.