Query Metrics
7
Database Queries
7
Different statements
179.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.02 ms (88.98%) |
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 124062 147173 150608 355294 443522 446800 453291 464344 464984 489778 494760 532054 534122 536866 560223 573381 590318 591117 592543 599049 607144 613373 617665 618409 628297 628516 634827 646337 649621 659075 665213 665219 666321 667686 668188 675480 678596 684920 688591 695614 704022 709539 714173 714654 715512 716697 717098 722148 722336 726075 726471 727254 727490 730550 732652 738441 738520 740799 742911 745442 752196 753656 754261 754659 754792 754891 756240 759736 760774 761380 761415 761997 763039 763077 763301 763311 763508 767901 768241 770015 772513 773801 776843 777181 778136 778189 778603 779482 780324 780657 783264 787037 789412 790609 791969 791980 791991 792717 797500 797779 797876 802859 807608 808207 808351 810653 811390 812090 813495 815677 816173 816313 818161 818490 821604 822560 825706 827302 ] |
||||||||||||||||||||||||||||||
|
10.61 ms (5.90%) |
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 695614 704022 667686 688591 722148 618409 780324 787037 797500 797779 780657 742911 783264 790609 761380 763301 754261 763063 770015 754891 763508 726075 738520 768241 777181 789412 792717 443522 124062 628297 726471 464984 827302 822560 534122 532054 494760 536866 778189 752196 756240 763039 810653 147173 453291 560223 646337 666321 812090 772513 753656 760774 767901 464344 717098 715512 776843 797876 811390 761997 773801 732652 759736 778603 599049 714654 355294 446800 816173 818161 815677 816313 825706 818490 821604 659075 665213 668188 709539 665219 675480 678596 684920 722336 649621 716697 592543 607144 613373 628516 591117 778136 791991 802859 791969 808207 808351 727490 740799 761415 781324 807608 813495 754659 763311 730550 745442 738441 754792 617665 634827 779482 791980 727254 150608 573381 714173 489778 590318 763077 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.55%) |
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 124062 147173 150608 355294 443522 446800 453291 464344 464984 489778 494760 532054 534122 536866 560223 573381 590318 591117 592543 599049 607144 613373 617665 618409 628297 628516 634827 646337 649621 659075 665213 665219 666321 667686 668188 675480 678596 684920 688591 695614 704022 709539 714173 714654 715512 716697 717098 722148 722336 726075 726471 727254 727490 730550 732652 738441 738520 740799 742911 745442 752196 753656 754261 754659 754792 754891 756240 759736 760774 761380 761415 761997 763039 763077 763301 763311 763508 767901 768241 770015 772513 773801 776843 777181 778136 778189 778603 779482 780324 780657 783264 787037 789412 790609 791969 791980 791991 792717 797500 797779 797876 802859 807608 808207 808351 810653 811390 812090 813495 815677 816173 816313 818161 818490 821604 822560 825706 827302 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"to cock dick"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock член"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock член"
]
|
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.