Query Metrics
7
Database Queries
7
Different statements
142.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.41 ms (82.33%) |
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 491814 491826 519235 524966 524987 540256 541309 541620 541642 541644 541647 541664 541683 541740 541780 541808 542190 542196 542461 542487 544270 544290 544301 544304 544321 544355 544356 546779 547345 547353 547552 547568 547862 549305 549336 549341 549355 549362 549370 549401 549406 549911 549912 549970 550044 551937 556858 556986 566681 566973 567368 570776 570786 572550 572575 574189 574238 574282 576636 576693 576722 577231 579918 579959 583643 583853 583855 592391 592539 593635 596576 600557 626556 628131 628291 629286 629902 638560 644287 667998 668384 672092 673041 674005 674542 674555 684268 690823 696168 699580 701345 702461 702888 702893 703113 703221 708101 709207 711294 719134 722142 722452 722698 729127 736957 739478 742152 742246 742515 742911 744311 744527 755465 756283 789016 799517 801192 801362 816088 817959 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (10.34%) |
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 789016 755465 742152 729127 744311 742515 756283 629286 629902 702888 703113 799517 541647 541780 541808 541683 542196 541642 541644 541664 541740 816088 817959 519235 540256 491814 541309 544304 547568 549911 551937 566973 542487 544290 544321 549305 549370 549912 549970 550044 566681 574189 574238 574282 583855 542461 544270 544301 544355 544356 549336 570776 577231 579959 667998 674542 674555 696168 708101 711294 668384 672092 673041 699580 722142 722698 674005 684268 690823 703221 722452 547345 547862 549341 549355 549401 556858 556986 570786 572575 579918 583643 583853 592539 600557 628291 592391 596576 626556 593635 628131 638560 644287 801362 739478 742911 744527 801192 742246 736957 701345 702461 702893 709207 719134 491826 524966 524987 541620 542190 546779 547353 547552 567368 572550 576636 576693 576722 549362 549406 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.09%) |
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 491814 491826 519235 524966 524987 540256 541309 541620 541642 541644 541647 541664 541683 541740 541780 541808 542190 542196 542461 542487 544270 544290 544301 544304 544321 544355 544356 546779 547345 547353 547552 547568 547862 549305 549336 549341 549355 549362 549370 549401 549406 549911 549912 549970 550044 551937 556858 556986 566681 566973 567368 570776 570786 572550 572575 574189 574238 574282 576636 576693 576722 577231 579918 579959 583643 583853 583855 592391 592539 593635 596576 600557 626556 628131 628291 629286 629902 638560 644287 667998 668384 672092 673041 674005 674542 674555 684268 690823 696168 699580 701345 702461 702888 702893 703113 703221 708101 709207 711294 719134 722142 722452 722698 729127 736957 739478 742152 742246 742515 742911 744311 744527 755465 756283 789016 799517 801192 801362 816088 817959 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"film 1993"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.18%) |
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.