Query Metrics
7
Database Queries
7
Different statements
840.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
481.33 ms (57.29%) |
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 632706 817613 827592 520879 664602 670405 596222 800119 791003 757217 804371 738326 741221 745998 635812 801810 814302 672764 710026 757237 768059 741881 755057 774666 775815 672755 739561 543652 542549 646176 639796 600297 599833 634784 635215 698133 554859 618864 606484 772107 740472 718924 827279 824664 540111 566973 580868 666991 575358 633244 607217 784246 765812 735828 744765 729253 741402 751390 798273 818291 667471 704896 618870 811887 782745 790158 731762 734350 768683 715888 793723 737883 789111 732869 727969 800920 576453 632750 793438 807881 736396 800763 809925 545389 678095 666894 641953 639719 630552 639060 642006 632579 610199 820347 824196 827591 817864 671773 672401 719649 719829 685511 690942 554843 642226 809358 753656 751453 729187 753707 738694 758145 608679 752840 747069 721949 814285 542423 546049 631396 ] |
||||||||||||||||||||||||||||||
|
212.22 ms (25.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss on tits"
]
|
||||||||||||||||||||||||||||||
|
137.75 ms (16.40%) |
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 520879 540111 542423 542549 543652 545389 546049 554843 554859 566973 575358 576453 580868 596222 599833 600297 606484 607217 608679 610199 618864 618870 630552 631396 632579 632706 632750 633244 634784 635215 635812 639060 639719 639796 641953 642006 642226 646176 664602 666894 666991 667471 670405 671773 672401 672755 672764 678095 685511 690942 698133 704896 710026 715888 718924 719649 719829 721949 727969 729187 729253 731762 732869 734350 735828 736396 737883 738326 738694 739561 740472 741221 741402 741881 744765 745998 747069 751390 751453 752840 753656 753707 755057 757217 757237 758145 765812 768059 768683 772107 774666 775815 782745 784246 789111 790158 791003 793438 793723 798273 800119 800763 800920 801810 804371 807881 809358 809925 811887 814285 814302 817613 817864 818291 820347 824196 824664 827279 827591 827592 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (0.39%) |
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 520879 540111 542423 542549 543652 545389 546049 554843 554859 566973 575358 576453 580868 596222 599833 600297 606484 607217 608679 610199 618864 618870 630552 631396 632579 632706 632750 633244 634784 635215 635812 639060 639719 639796 641953 642006 642226 646176 664602 666894 666991 667471 670405 671773 672401 672755 672764 678095 685511 690942 698133 704896 710026 715888 718924 719649 719829 721949 727969 729187 729253 731762 732869 734350 735828 736396 737883 738326 738694 739561 740472 741221 741402 741881 744765 745998 747069 751390 751453 752840 753656 753707 755057 757217 757237 758145 765812 768059 768683 772107 774666 775815 782745 784246 789111 790158 791003 793438 793723 798273 800119 800763 800920 801810 804371 807881 809358 809925 811887 814285 814302 817613 817864 818291 820347 824196 824664 827279 827591 827592 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.19%) |
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.