Query Metrics
7
Database Queries
7
Different statements
225.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.71 ms (88.94%) |
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 282626 426734 426929 444829 458718 464243 493083 495206 501513 521221 523071 524179 527915 530143 532673 533550 534466 535100 535606 541090 541462 542349 542370 544571 544939 544975 545214 545480 545944 546341 546377 546827 547700 549004 549406 549538 550049 550574 551074 551984 553810 554082 554597 555826 555829 556431 559089 559185 559186 559233 561064 561740 562214 565800 567416 568479 569726 569740 569744 569763 571671 574421 585244 588716 589928 593330 596882 596976 597183 604336 605446 614654 624230 633077 637771 638141 642212 651696 652081 660694 660704 667338 683054 687955 696865 700272 700284 705215 716635 717969 717990 719981 720818 722101 725524 729776 729962 731384 740620 742856 742898 745279 745383 745502 745660 748746 765742 780533 782776 787634 787983 788867 789801 808705 809072 810465 810791 812305 817144 827083 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (6.46%) |
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 567416 282626 544571 559089 574421 571671 527915 545480 546377 565800 700284 729776 559233 549406 596882 458718 545944 556431 562214 765742 544939 546341 596976 745279 521221 561740 667338 605446 809072 808705 547700 683054 717990 827083 687955 740620 593330 549538 780533 569740 633077 722101 551984 717969 787634 535606 464243 810791 638141 660704 660694 554597 541462 568479 745502 555826 731384 549004 716635 589928 588716 729962 545214 532673 782776 651696 426929 533550 559185 550574 569763 817144 614654 569726 555829 745383 559186 720818 652081 550049 501513 534466 495206 569744 789801 524179 787983 745660 523071 542370 725524 742898 426734 530143 546827 544975 810465 493083 642212 742856 585244 624230 444829 541090 554082 535100 696865 597183 604336 788867 812305 748746 637771 542349 551074 561064 700272 705215 719981 553810 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.09%) |
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 282626 426734 426929 444829 458718 464243 493083 495206 501513 521221 523071 524179 527915 530143 532673 533550 534466 535100 535606 541090 541462 542349 542370 544571 544939 544975 545214 545480 545944 546341 546377 546827 547700 549004 549406 549538 550049 550574 551074 551984 553810 554082 554597 555826 555829 556431 559089 559185 559186 559233 561064 561740 562214 565800 567416 568479 569726 569740 569744 569763 571671 574421 585244 588716 589928 593330 596882 596976 597183 604336 605446 614654 624230 633077 637771 638141 642212 651696 652081 660694 660704 667338 683054 687955 696865 700272 700284 705215 716635 717969 717990 719981 720818 722101 725524 729776 729962 731384 740620 742856 742898 745279 745383 745502 745660 748746 765742 780533 782776 787634 787983 788867 789801 808705 809072 810465 810791 812305 817144 827083 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк доминирован"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl slave"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.75%) |
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.