Query Metrics
7
Database Queries
7
Different statements
167.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.00 ms (79.51%) |
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 394376 396280 401378 402079 406041 409585 409682 413890 414177 424798 424917 425079 432715 437996 440771 441692 442204 442301 444468 446587 446713 446968 447828 449228 449897 450319 459225 460197 460262 462994 463623 463624 463630 463691 465312 466812 467662 468629 476861 478186 482629 484300 485460 489325 492268 496266 497104 497117 503075 506829 507890 510233 514263 515877 516444 516886 518054 518847 523478 524262 524397 526591 526611 527066 527088 529170 529335 537130 543773 548489 549739 551816 554253 555971 559678 560512 560879 561948 564173 565195 565631 568098 575272 577811 580061 581092 587072 588755 591442 598999 602742 606621 610828 611977 613864 619717 620300 621356 623754 624288 625088 659986 719353 736627 748210 748244 756209 756714 761275 790015 790022 799360 803055 804988 808675 825662 827880 828545 828730 ] |
||||||||||||||||||||||||||||||
|
23.65 ms (14.14%) |
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 543773 577811 659986 748210 619717 437996 449897 529170 485460 526611 554253 478186 527066 402079 401378 441692 463691 581092 548489 623754 719353 396280 828730 432715 444468 424798 446968 446587 449228 476861 462994 516444 518847 497117 510233 524262 529335 507890 537130 460262 555971 561948 549739 588755 606621 613864 620300 808675 790022 761275 756209 756714 621356 625088 790015 799360 424917 440771 463624 425079 414177 463623 526591 516886 484300 503075 506829 527088 460197 560512 560879 587072 447828 465312 489325 523478 496266 524397 803055 442301 467662 510295 580061 568098 591442 736627 611977 459225 482629 497104 514263 492268 409682 825662 827880 828545 804988 394376 409585 413890 442204 446713 466812 468629 450319 515877 518054 565195 575272 564173 551816 559678 565631 602742 610828 598999 624288 748244 463630 406041 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.63%) |
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 394376 396280 401378 402079 406041 409585 409682 413890 414177 424798 424917 425079 432715 437996 440771 441692 442204 442301 444468 446587 446713 446968 447828 449228 449897 450319 459225 460197 460262 462994 463623 463624 463630 463691 465312 466812 467662 468629 476861 478186 482629 484300 485460 489325 492268 496266 497104 497117 503075 506829 507890 510233 514263 515877 516444 516886 518054 518847 523478 524262 524397 526591 526611 527066 527088 529170 529335 537130 543773 548489 549739 551816 554253 555971 559678 560512 560879 561948 564173 565195 565631 568098 575272 577811 580061 581092 587072 588755 591442 598999 602742 606621 610828 611977 613864 619717 620300 621356 623754 624288 625088 659986 719353 736627 748210 748244 756209 756714 761275 790015 790022 799360 803055 804988 808675 825662 827880 828545 828730 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step ass"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step жоп"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step жоп"
]
|
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.