Query Metrics
7
Database Queries
7
Different statements
170.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.06 ms (82.31%) |
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 13229 187800 187851 188122 188655 224587 326115 362726 384124 385581 387104 387524 387856 388714 388740 388785 391287 393481 395861 403324 409312 413678 415147 421866 421883 422171 426515 428155 432625 432803 439634 439662 439722 439791 439856 440911 440996 441583 441921 442814 451497 455882 459649 461081 464198 467124 468338 468373 471685 473325 474109 474260 475294 477133 478378 481124 483656 497730 498081 500963 519071 522508 523338 530402 531556 535441 537264 542950 544108 549237 555103 555282 559359 564285 564296 564297 570402 586963 591333 595425 627361 646289 680434 710560 711744 715952 725619 733251 734390 735031 735880 735936 736099 736174 742351 742633 743829 749245 756241 758122 758192 759878 759946 773312 784066 787870 788543 791624 813085 816382 817886 818542 824164 824360 826265 827492 827632 827973 828380 828553 ] |
||||||||||||||||||||||||||||||
|
19.18 ms (11.27%) |
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 432803 468338 421866 421883 461081 395861 471685 519071 385581 387524 441921 441583 432625 455882 595425 474260 500963 388714 409312 467124 710560 759946 627361 788543 481124 387856 388785 403324 384124 478378 483656 522508 426515 415147 459649 393481 549237 586963 422171 451497 535441 188655 224587 413678 816382 824360 824164 817886 542950 564285 787870 735880 759878 734390 784066 13229 464198 187851 391287 474109 388740 428155 523338 715952 742633 497730 498081 818542 827632 646289 362726 387104 826265 827492 828553 711744 564296 758192 773312 791624 475294 187800 439634 439662 439856 439722 439791 442814 440996 591333 440911 188122 326115 828380 827973 473325 477133 468373 531556 537264 530402 544108 559359 555282 564297 570402 680434 555103 813085 742351 749245 736174 756241 735031 743829 733251 735936 725619 736099 758122 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.67%) |
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 13229 187800 187851 188122 188655 224587 326115 362726 384124 385581 387104 387524 387856 388714 388740 388785 391287 393481 395861 403324 409312 413678 415147 421866 421883 422171 426515 428155 432625 432803 439634 439662 439722 439791 439856 440911 440996 441583 441921 442814 451497 455882 459649 461081 464198 467124 468338 468373 471685 473325 474109 474260 475294 477133 478378 481124 483656 497730 498081 500963 519071 522508 523338 530402 531556 535441 537264 542950 544108 549237 555103 555282 559359 564285 564296 564297 570402 586963 591333 595425 627361 646289 680434 710560 711744 715952 725619 733251 734390 735031 735880 735936 736099 736174 742351 742633 743829 749245 756241 758122 758192 759878 759946 773312 784066 787870 788543 791624 813085 816382 817886 818542 824164 824360 826265 827492 827632 827973 828380 828553 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак анал mature"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy anal mature"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак анал mature"
]
|
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.