Query Metrics
7
Database Queries
7
Different statements
248.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.10 ms (89.07%) |
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 398508 398745 402718 403650 410090 411237 414365 415134 416523 416691 416700 417400 419272 419655 420038 421890 422237 422356 427273 427716 428159 428281 430188 432732 433322 435275 435355 435880 437518 437784 443042 443904 444180 444542 444814 446673 446894 447749 448680 448706 449687 453047 453162 454938 455140 456564 459366 460688 463645 464327 467951 470082 471861 471865 476409 479748 481998 488698 489484 490201 491611 493271 495467 496049 498641 500904 507695 508082 514800 517265 519553 521763 535531 536665 537221 544199 552169 558119 564390 565163 565254 566703 568088 568575 573788 573927 575063 576342 576414 576859 580631 581246 581349 583665 589424 590398 590802 591095 595867 597043 597961 598386 600248 605699 605874 609244 623211 628037 632298 644018 657128 659964 663527 687964 719600 720186 722514 730367 790365 793448 ] |
||||||||||||||||||||||||||||||
|
17.75 ms (7.15%) |
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 398508 443042 417400 508082 517265 496049 581246 720186 605874 644018 730367 453047 398745 435275 435880 428281 444814 479748 420038 460688 463645 493271 576859 521763 537221 535531 564390 628037 597043 591095 432732 573927 605699 595867 433322 790365 489484 476409 598386 632298 722514 455140 500904 514800 568088 421890 490201 403650 437518 422356 459366 446673 552169 583665 573788 719600 597961 600248 609244 589424 422237 427716 447749 427273 435355 456564 416523 449687 454938 495467 488698 471861 453162 565163 558119 565254 581349 568575 481998 444542 519553 623211 411237 414365 419272 443904 416700 437784 416691 491611 507695 467951 575063 576414 576342 793448 419655 448706 430188 402718 444180 470082 498641 471865 446894 657128 687964 663527 580631 590802 410090 464327 448680 544199 659964 590398 428159 536665 415134 566703 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.19%) |
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 398508 398745 402718 403650 410090 411237 414365 415134 416523 416691 416700 417400 419272 419655 420038 421890 422237 422356 427273 427716 428159 428281 430188 432732 433322 435275 435355 435880 437518 437784 443042 443904 444180 444542 444814 446673 446894 447749 448680 448706 449687 453047 453162 454938 455140 456564 459366 460688 463645 464327 467951 470082 471861 471865 476409 479748 481998 488698 489484 490201 491611 493271 495467 496049 498641 500904 507695 508082 514800 517265 519553 521763 535531 536665 537221 544199 552169 558119 564390 565163 565254 566703 568088 568575 573788 573927 575063 576342 576414 576859 580631 581246 581349 583665 589424 590398 590802 591095 595867 597043 597961 598386 600248 605699 605874 609244 623211 628037 632298 644018 657128 659964 663527 687964 719600 720186 722514 730367 790365 793448 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teen young"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teen young"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teen young"
]
|
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.