Query Metrics
7
Database Queries
7
Different statements
486.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
248.75 ms (51.14%) |
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 3371 3631 5344 7206 7295 7389 66768 97571 104130 151062 183634 187843 188262 233608 382194 382446 382548 383636 384769 385582 388713 388756 390747 391678 394361 398935 398959 399038 400832 400842 401199 402232 404023 408502 408509 418013 419525 421471 426316 427207 432552 433066 435793 436694 439504 440746 441131 450344 455885 456078 456236 458925 460308 463156 464202 466175 468180 468267 469565 469587 476074 478446 482519 485344 488023 491830 491926 517662 530011 533986 534595 536388 536444 554553 560289 561836 564556 569211 576628 583581 587011 587229 587755 593625 603792 604222 604661 616700 617106 620268 620661 626569 639755 655280 662086 662537 673345 689582 689614 705277 706359 707472 709646 712094 717504 736822 742747 744968 750568 758114 760988 766787 788073 789317 791518 800329 809356 813181 823941 826095 ] |
||||||||||||||||||||||||||||||
|
228.04 ms (46.89%) |
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 382548 3371 151062 382446 388756 662086 662537 616700 604222 603792 788073 766787 758114 427207 7389 689614 385582 418013 464202 583581 455885 709646 476074 717504 404023 478446 436694 485344 560289 435793 712094 791518 760988 421471 466175 533986 536444 432552 450344 469565 517662 463156 789317 736822 384769 469587 408509 655280 742747 617106 482519 458925 569211 534595 382194 750568 233608 707472 3631 400832 66768 576628 460308 391678 587229 441131 626569 456236 439504 394361 97571 5344 673345 554553 620661 388713 813181 530011 689582 561836 400842 468267 536388 639755 809356 800329 604661 620268 564556 593625 587011 7295 188262 187843 408502 433066 705277 706359 587755 390747 183634 104130 440746 399038 7206 419525 398935 491830 823941 826095 401199 383636 488023 426316 744968 398959 468180 456078 491926 402232 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (0.54%) |
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 3371 3631 5344 7206 7295 7389 66768 97571 104130 151062 183634 187843 188262 233608 382194 382446 382548 383636 384769 385582 388713 388756 390747 391678 394361 398935 398959 399038 400832 400842 401199 402232 404023 408502 408509 418013 419525 421471 426316 427207 432552 433066 435793 436694 439504 440746 441131 450344 455885 456078 456236 458925 460308 463156 464202 466175 468180 468267 469565 469587 476074 478446 482519 485344 488023 491830 491926 517662 530011 533986 534595 536388 536444 554553 560289 561836 564556 569211 576628 583581 587011 587229 587755 593625 603792 604222 604661 616700 617106 620268 620661 626569 639755 655280 662086 662537 673345 689582 689614 705277 706359 707472 709646 712094 717504 736822 742747 744968 750568 758114 760988 766787 788073 789317 791518 800329 809356 813181 823941 826095 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal in stockings"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.32%) |
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.