Query Metrics
7
Database Queries
7
Different statements
171.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.25 ms (87.49%) |
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 398387 413029 413391 413404 413731 421763 424651 446510 447792 449472 449502 449517 454030 461313 461762 463239 463497 469768 476990 477067 481701 485862 488475 506473 512547 516226 527263 529115 536107 542700 556075 556669 563015 563626 563684 577287 578760 583778 585588 591744 591948 592066 593634 607589 608121 617682 620533 622065 622886 625299 628596 630136 651702 655132 659052 661950 665622 674916 675829 695319 696167 700819 706454 708311 718089 719109 720192 722928 725062 725252 729216 730112 730407 733176 734293 736361 738818 740815 741785 744820 746495 748620 754253 756629 757167 759179 760301 763529 764004 765100 766263 768615 768670 769296 771045 772353 779573 786217 787851 788954 789058 790592 791195 791279 792374 793680 795301 795599 795998 797665 802067 804602 805189 806011 806574 811919 813034 814116 819334 ] |
||||||||||||||||||||||||||||||
|
12.07 ms (7.03%) |
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 722928 795599 797665 806011 424651 481701 516226 802067 421763 814116 819334 826156 449472 454030 461762 463497 469768 512547 488475 563015 563684 577287 661950 719109 720192 655132 696167 700819 706454 556075 592066 617682 628596 630136 620533 622065 607589 791195 792374 793680 811919 730112 769296 789058 733176 734293 744820 748620 765100 730407 760301 764004 746495 754253 763529 772353 736361 740815 756629 795301 806574 477067 446510 461313 527263 398387 413731 413029 413391 413404 449502 449517 476990 447792 463239 485862 529115 536107 506473 542700 583778 563626 674916 675829 651702 665622 708311 659052 695319 718089 556669 578760 591948 593634 608121 625299 622886 585588 591744 787851 790592 804602 805189 779573 788954 791279 813034 725252 757167 766263 786217 795998 725062 759179 729216 768615 768670 738818 741785 771045 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.47%) |
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 398387 413029 413391 413404 413731 421763 424651 446510 447792 449472 449502 449517 454030 461313 461762 463239 463497 469768 476990 477067 481701 485862 488475 506473 512547 516226 527263 529115 536107 542700 556075 556669 563015 563626 563684 577287 578760 583778 585588 591744 591948 592066 593634 607589 608121 617682 620533 622065 622886 625299 628596 630136 651702 655132 659052 661950 665622 674916 675829 695319 696167 700819 706454 708311 718089 719109 720192 722928 725062 725252 729216 730112 730407 733176 734293 736361 738818 740815 741785 744820 746495 748620 754253 756629 757167 759179 760301 763529 764004 765100 766263 768615 768670 769296 771045 772353 779573 786217 787851 788954 789058 790592 791195 791279 792374 793680 795301 795599 795998 797665 802067 804602 805189 806011 806574 811919 813034 814116 819334 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in creampie"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum creampie"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum creampie"
]
|
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.