Query Metrics
7
Database Queries
7
Different statements
166.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.84 ms (85.68%) |
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 907 285023 394130 405814 413431 424762 483690 501020 510566 512325 516114 527274 538269 553367 561341 584889 588541 589218 598534 599954 607098 609090 609829 626571 629981 631767 635404 636702 640046 649768 656518 661694 662844 671498 688093 689771 696092 700261 704915 706685 708588 708647 709311 711930 718639 718889 719355 720215 720813 722275 725580 726246 728793 730334 731679 733254 734998 735708 735826 744871 746077 748682 748901 750210 750232 751383 752836 753625 753681 753695 755441 756094 756652 761064 761757 762442 763068 767211 768361 768509 769892 770436 773054 773919 773929 775711 776533 776662 777099 778597 779095 779284 779351 779974 783104 783232 788548 789252 789921 789999 792323 802273 802491 803992 806651 807123 807474 810755 813315 813928 814509 814697 815059 816737 817316 819160 821650 826144 826474 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (7.73%) |
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 753625 753695 755441 756652 762442 768509 773929 750210 750232 751383 772615 773054 609829 635404 640046 706685 708588 718639 777099 778597 779095 779284 792323 810755 813315 285023 907 821650 656518 688093 696092 709311 711930 722275 607098 775711 783104 802491 756094 767211 773919 761064 768361 726246 735708 769892 730334 748901 753681 733254 761757 776662 789252 589218 735826 424762 817316 527274 501020 538269 510566 553367 561341 584889 689771 700261 649768 661694 671498 708647 719355 662844 609090 626571 599954 631767 588541 598534 636702 789921 789999 776533 783232 802273 803992 725580 728793 748682 807474 731679 744871 746077 752836 763068 734998 629981 720215 779351 779974 806651 413431 512325 516114 394130 704915 718889 788548 807123 770436 720813 483690 405814 826474 815059 826144 814509 814697 816737 819160 813928 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (2.24%) |
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 907 285023 394130 405814 413431 424762 483690 501020 510566 512325 516114 527274 538269 553367 561341 584889 588541 589218 598534 599954 607098 609090 609829 626571 629981 631767 635404 636702 640046 649768 656518 661694 662844 671498 688093 689771 696092 700261 704915 706685 708588 708647 709311 711930 718639 718889 719355 720215 720813 722275 725580 726246 728793 730334 731679 733254 734998 735708 735826 744871 746077 748682 748901 750210 750232 751383 752836 753625 753681 753695 755441 756094 756652 761064 761757 762442 763068 767211 768361 768509 769892 770436 773054 773919 773929 775711 776533 776662 777099 778597 779095 779284 779351 779974 783104 783232 788548 789252 789921 789999 792323 802273 802491 803992 806651 807123 807474 810755 813315 813928 814509 814697 815059 816737 817316 819160 821650 826144 826474 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 you"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 you"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 you"
]
|
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.