Query Metrics
7
Database Queries
7
Different statements
244.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.77 ms (89.59%) |
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 414779 455860 489829 492542 509163 510902 520201 524894 527459 552287 559709 563949 564574 574116 583294 588550 592114 603012 607253 609516 610058 616727 616809 626344 627143 633674 638476 653110 656167 659399 666665 667165 668707 672419 672795 673663 674607 675149 676610 678647 682652 693579 693709 699681 701506 703395 703687 706784 711269 712643 715378 716631 718502 719986 721240 722435 724728 730154 730212 730525 730675 731025 731265 731433 735884 738497 739184 741860 743072 743887 744794 745536 745679 752176 757274 759751 760148 763873 764981 765036 765820 767799 769106 772672 775542 776372 777559 779358 779772 780052 780176 781289 781325 781603 782634 783964 785020 787117 787475 790251 791612 791629 793442 794272 794567 797023 800898 801135 802007 804381 809884 811587 820646 823150 824972 826086 826223 828453 ] |
||||||||||||||||||||||||||||||
|
15.30 ms (6.26%) |
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 574116 563949 672419 674607 676610 678647 693709 706784 712643 682652 653110 666665 588550 616809 609516 776372 781289 775542 780176 782634 785020 790251 791629 794272 802007 763873 765820 772672 787475 800898 730675 731433 741860 744794 760148 764981 767799 773295 738497 743887 730154 735884 724728 730212 730525 731265 743072 765036 610058 779358 779772 797023 801135 809884 811587 489829 510902 455860 414779 520201 820646 823150 824972 826086 826223 828453 492542 509163 524894 527459 552287 559709 564574 581420 583294 672795 693579 699681 703395 703687 715378 722435 673663 675149 701506 711269 716631 718502 721240 656167 659399 667165 668707 719986 592114 626344 603012 607253 633674 616727 627143 638476 781603 777559 780052 781325 783964 787117 791612 793442 794567 739184 752176 757274 804381 731025 745536 745679 759751 769106 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.29%) |
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 414779 455860 489829 492542 509163 510902 520201 524894 527459 552287 559709 563949 564574 574116 583294 588550 592114 603012 607253 609516 610058 616727 616809 626344 627143 633674 638476 653110 656167 659399 666665 667165 668707 672419 672795 673663 674607 675149 676610 678647 682652 693579 693709 699681 701506 703395 703687 706784 711269 712643 715378 716631 718502 719986 721240 722435 724728 730154 730212 730525 730675 731025 731265 731433 735884 738497 739184 741860 743072 743887 744794 745536 745679 752176 757274 759751 760148 763873 764981 765036 765820 767799 769106 772672 775542 776372 777559 779358 779772 780052 780176 781289 781325 781603 782634 783964 785020 787117 787475 790251 791612 791629 793442 794272 794567 797023 800898 801135 802007 804381 809884 811587 820646 823150 824972 826086 826223 828453 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"she cum"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"she cum"
]
|
||||||||||||||||||||||||||||||
|
1.16 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"she cum"
]
|
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.