Query Metrics
7
Database Queries
7
Different statements
179.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.94 ms (88.21%) |
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 56632 485886 490810 491814 491826 519235 537756 541309 542461 542487 544270 544290 544301 544304 544321 544345 544346 544355 544356 544448 544577 544587 547300 547302 547314 547345 547568 547862 549258 549263 549271 549295 549305 549336 549341 549355 549370 549380 549393 549401 549911 549912 549970 550044 550321 551710 551937 556858 556986 566681 566800 566973 570776 570777 570786 570795 570811 570827 571025 571837 572561 572575 572595 572600 572604 573215 574183 574189 574227 574238 574277 574282 576656 577231 579918 579959 580896 583643 583853 583855 592391 592539 593635 596576 600557 626556 628131 628291 638560 644287 667998 668384 672092 673041 674005 674542 674555 684268 690823 696168 699580 701345 702461 702893 703221 708101 709207 711294 719134 722142 722452 722698 736957 739478 742246 742911 744527 801192 816088 817959 ] |
||||||||||||||||||||||||||||||
|
12.01 ms (6.71%) |
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 566800 571837 573215 574277 580896 544345 544587 549258 549271 549380 572561 576656 544346 544448 544577 549295 550321 570795 574183 549393 570777 571025 572600 574227 490810 547314 551710 547300 572595 547302 549263 570811 56632 485886 537756 816088 817959 519235 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 739478 742911 744527 801192 742246 736957 701345 702461 702893 709207 719134 491826 570827 572604 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.52%) |
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 56632 485886 490810 491814 491826 519235 537756 541309 542461 542487 544270 544290 544301 544304 544321 544345 544346 544355 544356 544448 544577 544587 547300 547302 547314 547345 547568 547862 549258 549263 549271 549295 549305 549336 549341 549355 549370 549380 549393 549401 549911 549912 549970 550044 550321 551710 551937 556858 556986 566681 566800 566973 570776 570777 570786 570795 570811 570827 571025 571837 572561 572575 572595 572600 572604 573215 574183 574189 574227 574238 574277 574282 576656 577231 579918 579959 580896 583643 583853 583855 592391 592539 593635 596576 600557 626556 628131 628291 638560 644287 667998 668384 672092 673041 674005 674542 674555 684268 690823 696168 699580 701345 702461 702893 703221 708101 709207 711294 719134 722142 722452 722698 736957 739478 742246 742911 744527 801192 816088 817959 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"film xxx 2022"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм xxx"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фильм xxx"
]
|
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.