Query Metrics
7
Database Queries
7
Different statements
400.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.43 ms (52.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina pov"
]
|
||||||||||||||||||||||||||||||
|
171.03 ms (42.69%) |
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 72499 387871 395530 403539 413735 454050 455261 455929 464410 489158 509770 512448 513057 522717 526235 531149 532207 536018 540435 553115 560103 577226 601222 602107 617174 623305 627123 627886 647897 667797 676150 691303 701407 701554 701687 708078 710189 730229 734500 735851 737315 757288 758901 759267 760678 761283 761462 761764 763054 763599 765394 765438 770700 771083 771249 776142 776613 777801 778834 780903 783277 784821 785162 785294 785547 787965 787981 793669 796683 797794 799242 799320 801618 803854 804061 804549 804968 805672 808078 808672 811728 811956 811962 812210 812873 812947 813023 813444 813669 813789 814328 815001 815098 817240 818537 820096 820664 820989 821431 821458 821484 821986 822057 822211 822231 822263 822553 822669 822850 823231 823332 823341 823426 823473 825310 825756 825915 827888 ] |
||||||||||||||||||||||||||||||
|
12.75 ms (3.18%) |
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 796683 805672 811728 812947 813444 730229 755642 757288 758901 761462 765438 783277 784821 785162 785294 787965 787981 793669 797794 799320 801618 804549 808078 811956 735851 759267 737315 760678 761283 763054 771083 763599 770700 602107 617174 627123 701687 710189 777801 778834 799242 804061 808672 811962 812210 812873 813023 489158 822553 823231 821986 560103 785547 72499 531149 701554 691303 553115 623305 761764 734500 774140 771249 765394 822211 540435 780903 803854 776142 776613 804968 395530 455929 387871 403539 413735 813789 820989 821484 822850 825915 813669 815098 823341 825756 814328 815001 818537 820096 822263 822669 823332 823426 823473 825310 817240 820664 821431 821458 822057 822231 827888 455261 454050 464410 513057 522717 509770 532207 512448 526235 536018 577226 647897 667797 676150 701407 708078 627886 601222 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (0.89%) |
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 72499 387871 395530 403539 413735 454050 455261 455929 464410 489158 509770 512448 513057 522717 526235 531149 532207 536018 540435 553115 560103 577226 601222 602107 617174 623305 627123 627886 647897 667797 676150 691303 701407 701554 701687 708078 710189 730229 734500 735851 737315 757288 758901 759267 760678 761283 761462 761764 763054 763599 765394 765438 770700 771083 771249 776142 776613 777801 778834 780903 783277 784821 785162 785294 785547 787965 787981 793669 796683 797794 799242 799320 801618 803854 804061 804549 804968 805672 808078 808672 811728 811956 811962 812210 812873 812947 813023 813444 813669 813789 814328 815001 815098 817240 818537 820096 820664 820989 821431 821458 821484 821986 822057 822211 822231 822263 822553 822669 822850 823231 823332 823341 823426 823473 825310 825756 825915 827888 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская пов"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская пов"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.37%) |
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.