Query Metrics
7
Database Queries
7
Different statements
233.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.30 ms (89.96%) |
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 459049 487621 504118 536203 542116 546415 558491 583937 584574 595058 602789 603280 612979 618407 630880 643472 651996 660036 661711 662520 666178 672883 674245 679895 689020 689134 693905 698879 703748 706391 709574 716941 720569 723957 725088 725204 726848 728947 729045 730974 735481 735735 735984 736285 737807 738560 739240 741073 742421 744163 746321 746393 746745 746777 747566 747990 747994 748003 748406 750635 758760 760589 761872 761915 762230 765396 768651 770980 771740 777500 780217 781009 782642 783839 785668 786708 787414 787573 787740 789152 789554 790260 793301 793516 794438 795257 796218 796701 797567 800972 801571 802429 803936 808254 808828 813034 813421 813527 813560 817593 817999 819024 819040 819310 819748 824128 824318 824332 824336 824600 824641 824774 824779 825400 825484 826565 826619 826775 827207 ] |
||||||||||||||||||||||||||||||
|
12.33 ms (5.27%) |
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 795257 813034 794438 735481 736285 761872 770980 771740 747566 762230 741073 742421 602789 716941 783839 803936 459049 487621 504118 817999 819040 819310 824318 824641 813560 826619 826565 824774 824779 825400 825484 827207 819024 819748 824128 824332 824336 817593 823840 824600 826775 536203 546415 584574 542116 583937 689020 693905 703748 720569 651996 660036 661711 674245 679895 689134 698879 706391 709574 662520 666178 672883 558491 595058 618407 643472 603280 612979 630880 781009 782642 796218 802429 777500 780217 785668 786708 787414 787573 787740 789152 793301 796701 797567 801571 808254 725088 726848 746321 746393 746745 750635 758760 760589 789554 790260 793516 800972 808828 813421 813527 725204 728947 730974 735984 737807 747990 747994 768651 723957 729045 735735 739240 748406 761915 765396 738560 744163 746777 748003 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.49%) |
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 459049 487621 504118 536203 542116 546415 558491 583937 584574 595058 602789 603280 612979 618407 630880 643472 651996 660036 661711 662520 666178 672883 674245 679895 689020 689134 693905 698879 703748 706391 709574 716941 720569 723957 725088 725204 726848 728947 729045 730974 735481 735735 735984 736285 737807 738560 739240 741073 742421 744163 746321 746393 746745 746777 747566 747990 747994 748003 748406 750635 758760 760589 761872 761915 762230 765396 768651 770980 771740 777500 780217 781009 782642 783839 785668 786708 787414 787573 787740 789152 789554 790260 793301 793516 794438 795257 796218 796701 797567 800972 801571 802429 803936 808254 808828 813034 813421 813527 813560 817593 817999 819024 819040 819310 819748 824128 824318 824332 824336 824600 824641 824774 824779 825400 825484 826565 826619 826775 827207 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum pussy"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum pussy"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum pussy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.