Query Metrics
7
Database Queries
7
Different statements
198.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.19 ms (86.13%) |
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 530364 535961 537574 537705 538861 538950 538953 540460 544334 544344 544357 544380 546390 547259 547264 547287 547293 547295 547301 547317 547324 547325 547326 547327 547335 547338 547346 547348 547351 548120 548269 548292 549288 549360 549394 549408 549409 549434 549887 549888 549892 549898 549900 549905 549909 549916 549917 549920 549928 549931 549936 549955 549975 549988 551021 551705 551707 551711 551715 566680 566805 566806 566891 570787 570800 570806 570808 570814 570818 570826 571177 571183 572581 572588 572590 572612 572638 573214 573322 573427 574194 577254 579169 579910 579923 583812 583822 583830 583841 583847 586816 586833 586921 592513 612110 626552 628137 628322 642793 642809 668150 668419 668423 668425 668434 668444 681040 684202 687096 687132 698460 699677 700742 703517 707273 708093 712703 713477 756313 790088 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (6.98%) |
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 544380 548120 549905 549920 551711 579910 579923 547264 549288 549887 570800 547259 547338 551707 570808 572590 583822 703517 668423 668434 684202 712703 549892 549900 551705 570826 583841 586833 586921 592513 612110 535961 570814 572581 572588 573427 570818 573322 668150 668425 668444 547287 547326 549975 537705 530364 537574 538950 538953 540460 546390 547325 549360 549409 549955 566891 570806 572638 549394 547317 549916 549988 566805 573214 681040 687096 687132 700742 549434 549898 628322 628137 586816 642793 790088 756313 699677 707273 566680 547324 547346 547351 547348 549909 549931 538861 547295 547301 547335 549936 566806 544344 544357 551021 570787 571177 571183 583847 544334 547327 548269 548292 551715 583830 668419 698460 713477 708093 547293 549408 549888 549917 549928 572612 574194 577254 579169 583812 626552 642809 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (1.87%) |
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 530364 535961 537574 537705 538861 538950 538953 540460 544334 544344 544357 544380 546390 547259 547264 547287 547293 547295 547301 547317 547324 547325 547326 547327 547335 547338 547346 547348 547351 548120 548269 548292 549288 549360 549394 549408 549409 549434 549887 549888 549892 549898 549900 549905 549909 549916 549917 549920 549928 549931 549936 549955 549975 549988 551021 551705 551707 551711 551715 566680 566805 566806 566891 570787 570800 570806 570808 570814 570818 570826 571177 571183 572581 572588 572590 572612 572638 573214 573322 573427 574194 577254 579169 579910 579923 583812 583822 583830 583841 583847 586816 586833 586921 592513 612110 626552 628137 628322 642793 642809 668150 668419 668423 668425 668434 668444 681040 684202 687096 687132 698460 699677 700742 703517 707273 708093 712703 713477 756313 790088 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (1.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фильм xxx"
]
|
||||||||||||||||||||||||||||||
|
2.42 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм xxx"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"films xxx"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.98%) |
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.