Query Metrics
7
Database Queries
7
Different statements
154.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.34 ms (83.47%) |
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 229460 388819 389360 390363 395752 395845 396450 399396 403900 403907 404829 405105 405252 406917 406973 408715 417877 418354 419873 422642 422665 424841 425684 428450 432337 442358 442679 443216 449566 449880 451896 452444 456883 460078 466939 470778 472429 478048 479197 481581 481965 484669 485941 489461 489971 490569 492247 494040 494771 496032 510577 514939 519093 522592 525691 530530 530834 536332 539841 540307 543886 549422 549778 561131 565539 565992 574231 581281 583835 583878 585103 587795 588019 590949 597840 598661 604066 604567 605344 606793 607662 619470 620130 620164 622054 622230 622645 624227 624468 632023 640022 654290 662197 666049 667875 670093 671756 682478 688035 688604 691820 692786 703080 724147 805687 806019 807187 807557 811870 815297 815451 815543 815645 816594 816968 818387 818460 818998 819565 821179 ] |
||||||||||||||||||||||||||||||
|
15.70 ms (10.13%) |
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 405105 428450 452444 620164 806019 807557 607662 514939 489461 489971 432337 496032 442679 815297 485941 530530 470778 442358 688035 403900 404829 449566 484669 522592 443216 405252 494771 588019 654290 399396 406973 815451 682478 688604 622230 724147 807187 640022 229460 403907 818460 821179 451896 472429 481965 536332 478048 565992 662197 691820 624227 395752 425684 395845 396450 494040 565539 620130 481581 519093 388819 390363 417877 418354 585103 818998 815645 466939 490569 510577 530834 549778 666049 670093 604567 598661 604066 632023 587795 622645 606793 811870 805687 389360 419873 422642 479197 449880 561131 624468 525691 422665 408715 406917 424841 816968 818387 819565 815543 816594 456883 492247 460078 539841 540307 543886 574231 581281 549422 583878 671756 667875 703080 692786 583835 590949 619470 597840 622054 605344 ] |
||||||||||||||||||||||||||||||
|
3.23 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 229460 388819 389360 390363 395752 395845 396450 399396 403900 403907 404829 405105 405252 406917 406973 408715 417877 418354 419873 422642 422665 424841 425684 428450 432337 442358 442679 443216 449566 449880 451896 452444 456883 460078 466939 470778 472429 478048 479197 481581 481965 484669 485941 489461 489971 490569 492247 494040 494771 496032 510577 514939 519093 522592 525691 530530 530834 536332 539841 540307 543886 549422 549778 561131 565539 565992 574231 581281 583835 583878 585103 587795 588019 590949 597840 598661 604066 604567 605344 606793 607662 619470 620130 620164 622054 622230 622645 624227 624468 632023 640022 654290 662197 666049 667875 670093 671756 682478 688035 688604 691820 692786 703080 724147 805687 806019 807187 807557 811870 815297 815451 815543 815645 816594 816968 818387 818460 818998 819565 821179 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy threesome"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.92%) |
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.