Query Metrics
7
Database Queries
7
Different statements
193.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.21 ms (83.73%) |
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 546163 546384 549439 550177 550905 554695 556745 556898 566730 588074 588823 589604 589868 591780 592966 593242 594306 595964 598240 599773 600650 600718 600778 600928 604642 605780 608107 615283 616009 616850 617541 617564 618537 618930 621085 622046 626092 626174 627941 628694 628761 629027 629427 630322 631305 631403 636138 636440 637197 638045 639109 639632 640906 640943 641924 642240 642526 646348 647132 647173 651618 665602 668831 669867 671200 671769 681196 687341 689252 693085 695857 696459 700860 701339 702068 706763 712221 712336 713427 713779 717323 774658 775317 776823 777272 777771 777835 778730 780314 780412 780414 781017 781024 782050 782100 782590 782656 782950 783835 784509 785100 785164 785652 785894 786888 788931 790242 790414 791882 791890 792458 796390 796411 801830 804806 806515 807024 810514 812474 813341 ] |
||||||||||||||||||||||||||||||
|
21.31 ms (11.00%) |
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 695857 696459 701339 712221 713427 713779 717323 646348 647132 647173 651618 665602 668831 669867 671200 671769 681196 687341 689252 693085 700860 702068 706763 712336 546163 546384 549439 550177 550905 554695 556745 556898 566730 599773 600778 605780 608107 615283 616009 616850 622046 626092 628694 628761 629427 631403 636138 591780 592966 600718 618537 621085 626174 629027 636440 637197 642526 588823 589868 593242 600928 627941 638045 639632 588074 589604 594306 595964 598240 600650 604642 617541 617564 618930 630322 631305 639109 640906 640943 641924 642240 774658 775317 777272 777771 777835 780314 780412 780414 781017 782050 784509 785100 785164 785652 785894 786888 788931 790242 790414 791882 791890 792458 796390 796411 801830 804806 806515 807024 810514 812474 813341 776823 778730 781024 782100 782590 782656 782950 783835 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.53%) |
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 546163 546384 549439 550177 550905 554695 556745 556898 566730 588074 588823 589604 589868 591780 592966 593242 594306 595964 598240 599773 600650 600718 600778 600928 604642 605780 608107 615283 616009 616850 617541 617564 618537 618930 621085 622046 626092 626174 627941 628694 628761 629027 629427 630322 631305 631403 636138 636440 637197 638045 639109 639632 640906 640943 641924 642240 642526 646348 647132 647173 651618 665602 668831 669867 671200 671769 681196 687341 689252 693085 695857 696459 700860 701339 702068 706763 712221 712336 713427 713779 717323 774658 775317 776823 777272 777771 777835 778730 780314 780412 780414 781017 781024 782050 782100 782590 782656 782950 783835 784509 785100 785164 785652 785894 786888 788931 790242 790414 791882 791890 792458 796390 796411 801830 804806 806515 807024 810514 812474 813341 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo pussy"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло pussy"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло pussy"
]
|
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.