Query Metrics
7
Database Queries
7
Different statements
196.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.33 ms (88.82%) |
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 38068 142773 238809 383902 385751 391247 391689 393338 397122 405272 408998 414004 416123 425711 426406 438877 446344 447004 449809 451890 453327 454925 454944 465629 467163 468705 469351 471836 473037 474984 515096 520003 520809 522927 528825 529105 535540 544345 548091 549129 561351 575197 576393 579521 591708 603516 604064 610643 613643 620779 626308 628358 643415 646776 648118 649919 650993 661312 663550 671729 674891 676759 696168 699670 709406 710989 713945 720405 724185 727414 735682 737357 739482 742142 743327 744135 752196 752966 752974 758033 760529 760733 768338 771506 774736 779382 781934 783259 786812 789195 789424 791308 793507 797613 798719 804283 805019 805140 806980 807794 808508 815059 816036 817780 819122 819152 819465 819515 819637 819646 821009 821489 821546 822136 822229 822421 822768 823383 824887 825537 ] |
||||||||||||||||||||||||||||||
|
11.74 ms (5.98%) |
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 579521 650993 709406 628358 781934 789195 743327 760529 797613 807794 742142 752966 735682 774736 793507 676759 591708 752974 786812 393338 426406 643415 391247 405272 819637 825537 822768 515096 549129 671729 674891 661312 663550 804283 744135 710989 528825 620779 238809 425711 819515 469351 474984 453327 451890 438877 383902 414004 416123 454944 522927 535540 473037 467163 561351 576393 520003 789424 575197 446344 447004 454925 449809 529105 408998 471836 468705 391689 397122 142773 385751 38068 819646 815059 819122 821489 822229 823383 544345 699670 648118 720405 603516 604064 610643 613643 779382 760733 783259 737357 724185 739482 752196 771506 626308 806980 520809 548091 758033 646776 817780 822136 819465 822421 824887 816036 819152 821009 821546 465629 696168 713945 649919 791308 805140 798719 805019 768338 808508 727414 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.32%) |
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 38068 142773 238809 383902 385751 391247 391689 393338 397122 405272 408998 414004 416123 425711 426406 438877 446344 447004 449809 451890 453327 454925 454944 465629 467163 468705 469351 471836 473037 474984 515096 520003 520809 522927 528825 529105 535540 544345 548091 549129 561351 575197 576393 579521 591708 603516 604064 610643 613643 620779 626308 628358 643415 646776 648118 649919 650993 661312 663550 671729 674891 676759 696168 699670 709406 710989 713945 720405 724185 727414 735682 737357 739482 742142 743327 744135 752196 752966 752974 758033 760529 760733 768338 771506 774736 779382 781934 783259 786812 789195 789424 791308 793507 797613 798719 804283 805019 805140 806980 807794 808508 815059 816036 817780 819122 819152 819465 819515 819637 819646 821009 821489 821546 822136 822229 822421 822768 823383 824887 825537 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"девушки в бассейн порно"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк бассейн порн"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.77%) |
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.