Query Metrics
7
Database Queries
7
Different statements
188.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.40 ms (84.60%) |
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 20190 20907 163133 192861 226286 327121 327421 382158 382874 386738 387647 387720 388888 389231 390288 390574 390970 396989 397045 397129 397678 399738 401122 401851 403904 410606 412749 416294 420201 420231 421520 422568 422924 423068 427449 430977 443497 443523 443550 443582 446499 448536 457980 459149 459229 473774 475250 478454 497420 497448 510669 511266 515884 544535 551962 552638 554298 556418 576991 585781 590949 592027 592323 600537 600539 604747 608662 615005 616025 618483 623608 632605 635061 637115 662078 662200 671302 674216 683878 689688 701753 709738 712718 713113 715125 717892 717921 727853 727903 732304 733852 733910 733913 735602 735898 740928 741106 743069 743436 744090 747119 747237 747956 755341 758725 758731 761552 761580 765679 766626 766792 767044 767285 767287 771601 800303 800710 810416 815131 826299 ] |
||||||||||||||||||||||||||||||
|
17.12 ms (9.09%) |
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 390288 382158 397129 443550 421520 744090 604747 443497 390574 608662 733852 758731 747119 386738 771601 767287 709738 388888 815131 387720 556418 701753 671302 826299 765679 382874 226286 800710 412749 767044 683878 810416 416294 590949 615005 743069 551962 735898 732304 511266 717892 387647 497448 163133 689688 713113 327421 427449 443582 390970 766626 327121 758725 422568 448536 515884 635061 576991 715125 397045 662078 741106 20907 420201 497420 761552 397678 420231 727903 733910 401122 717921 800303 662200 473774 443523 459229 585781 740928 755341 430977 766792 554298 618483 600539 389231 478454 396989 446499 552638 592323 735602 743436 422924 616025 637115 632605 399738 459149 747237 733913 403904 475250 510669 767285 674216 727853 192861 592027 600537 747956 423068 623608 761580 20190 410606 712718 544535 457980 401851 ] |
||||||||||||||||||||||||||||||
|
4.98 ms (2.64%) |
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 20190 20907 163133 192861 226286 327121 327421 382158 382874 386738 387647 387720 388888 389231 390288 390574 390970 396989 397045 397129 397678 399738 401122 401851 403904 410606 412749 416294 420201 420231 421520 422568 422924 423068 427449 430977 443497 443523 443550 443582 446499 448536 457980 459149 459229 473774 475250 478454 497420 497448 510669 511266 515884 544535 551962 552638 554298 556418 576991 585781 590949 592027 592323 600537 600539 604747 608662 615005 616025 618483 623608 632605 635061 637115 662078 662200 671302 674216 683878 689688 701753 709738 712718 713113 715125 717892 717921 727853 727903 732304 733852 733910 733913 735602 735898 740928 741106 743069 743436 744090 747119 747237 747956 755341 758725 758731 761552 761580 765679 766626 766792 767044 767285 767287 771601 800303 800710 810416 815131 826299 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian fuck anal"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
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.