Query Metrics
7
Database Queries
7
Different statements
165.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.91 ms (78.53%) |
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 86241 308297 384585 387319 391729 392152 397166 398789 413898 417267 418294 418297 421731 425322 425497 434470 436058 437767 437901 444644 445343 451216 455531 457093 457862 458243 466594 468639 468769 472670 478068 481177 487251 487615 495663 502539 505364 511840 516175 516613 529889 534676 535567 542075 551521 552864 556552 559169 573277 581453 593894 595488 599981 600945 602572 604257 604724 609596 620211 620245 621099 623432 625729 630303 637513 648166 653313 655799 660248 660709 661907 664468 670801 671236 682923 686939 700885 715774 716628 716639 716828 723616 728922 734515 739632 743928 746536 747195 747228 748757 761668 765981 767553 768403 776479 778734 779563 780138 781598 782911 783017 783401 783657 784426 786921 787806 791110 791706 792423 793360 793425 808201 808241 809105 809329 814304 816805 817019 817137 818684 ] |
||||||||||||||||||||||||||||||
|
24.66 ms (14.91%) |
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 481177 716628 781598 743928 602572 478068 495663 682923 434470 808241 308297 817019 816805 559169 787806 779563 809329 715774 778734 437767 392152 397166 502539 600945 604724 472670 425322 767553 768403 761668 625729 817137 670801 451216 671236 468769 529889 573277 655799 809105 748757 86241 437901 516175 384585 425497 516613 664468 723616 595488 747195 747228 455531 458243 814304 620245 783657 604257 620211 417267 746536 487615 791110 734515 505364 660248 623432 739632 621099 487251 511840 556552 782911 792423 468639 466594 534676 783401 784426 786921 808201 765981 609596 793425 653313 700885 728922 387319 818684 660709 445343 457093 791706 793360 413898 457862 783017 436058 418297 418294 593894 716828 599981 421731 581453 535567 551521 542075 648166 661907 686939 716639 552864 630303 780138 637513 391729 398789 444644 776479 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.38 ms (1.44%) |
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 86241 308297 384585 387319 391729 392152 397166 398789 413898 417267 418294 418297 421731 425322 425497 434470 436058 437767 437901 444644 445343 451216 455531 457093 457862 458243 466594 468639 468769 472670 478068 481177 487251 487615 495663 502539 505364 511840 516175 516613 529889 534676 535567 542075 551521 552864 556552 559169 573277 581453 593894 595488 599981 600945 602572 604257 604724 609596 620211 620245 621099 623432 625729 630303 637513 648166 653313 655799 660248 660709 661907 664468 670801 671236 682923 686939 700885 715774 716628 716639 716828 723616 728922 734515 739632 743928 746536 747195 747228 748757 761668 765981 767553 768403 776479 778734 779563 780138 781598 782911 783017 783401 783657 784426 786921 787806 791110 791706 792423 793360 793425 808201 808241 809105 809329 814304 816805 817019 817137 818684 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur deep throat"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.12%) |
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.