Query Metrics
7
Database Queries
7
Different statements
172.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.97 ms (84.67%) |
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 17058 142823 401583 401586 405420 442121 449316 451566 456957 519243 523988 526132 528199 528421 528669 530529 535824 535827 539614 540403 544479 576175 579921 579922 590932 630329 648222 675801 678568 678579 679051 679053 679058 679088 679090 679095 679098 679099 679113 683308 686188 690817 690853 690860 691501 691531 692209 692224 692234 692250 692259 692296 692319 692333 692804 692805 693032 693034 693049 693862 693868 694071 694188 694219 694464 694498 694564 695234 695264 695278 695939 695940 697261 697278 697352 697359 697364 697828 697973 698398 698428 698526 698536 699385 699684 699734 699738 699744 699745 699762 699775 700282 704268 712695 715438 716674 720738 728050 737162 759668 761274 771137 771164 774514 780050 781899 814797 815152 815257 815454 815511 815674 815919 816061 816405 816516 816535 816890 816962 819767 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (9.10%) |
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 694071 694564 695278 697278 698398 704268 819767 679088 692250 699684 697359 692224 780050 728050 699745 699762 456957 816405 815511 528199 535827 523988 679099 690860 697828 720738 692259 697261 692804 698526 699734 699744 401583 815454 816890 815152 816061 693862 679113 693032 694464 695264 679053 690817 694498 590932 405420 815257 816962 816516 519243 528421 535824 544479 679051 683308 692209 699738 692805 693868 698428 712695 690853 693034 694219 695939 576175 579921 771137 781899 759668 771164 449316 816535 526132 530529 579922 692234 692319 691501 715438 761274 697352 699385 451566 401586 815919 698536 142823 695234 697973 679090 678568 691531 442121 814797 540403 539614 692296 716674 692333 648222 675801 679095 694188 630329 774514 737162 17058 815674 528669 678579 679058 686188 695940 697364 699775 700282 679098 693049 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (2.12%) |
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 17058 142823 401583 401586 405420 442121 449316 451566 456957 519243 523988 526132 528199 528421 528669 530529 535824 535827 539614 540403 544479 576175 579921 579922 590932 630329 648222 675801 678568 678579 679051 679053 679058 679088 679090 679095 679098 679099 679113 683308 686188 690817 690853 690860 691501 691531 692209 692224 692234 692250 692259 692296 692319 692333 692804 692805 693032 693034 693049 693862 693868 694071 694188 694219 694464 694498 694564 695234 695264 695278 695939 695940 697261 697278 697352 697359 697364 697828 697973 698398 698428 698526 698536 699385 699684 699734 699738 699744 699745 699762 699775 700282 704268 712695 715438 716674 720738 728050 737162 759668 761274 771137 771164 774514 780050 781899 814797 815152 815257 815454 815511 815674 815919 816061 816405 816516 816535 816890 816962 819767 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2023 sex scene"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс scene"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс scene"
]
|
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.