Query Metrics
7
Database Queries
7
Different statements
150.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.75 ms (81.45%) |
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 445444 446086 448064 450637 451088 451614 452708 453236 454949 457021 459754 459968 460092 460129 460437 462903 463163 463547 466924 468982 472410 475847 477325 482121 482973 484876 485025 485847 485949 486266 487221 487534 489702 490402 490752 491094 494163 496334 497395 499005 499325 501352 504752 504764 505469 506127 507156 507879 509515 512590 514037 515263 525678 534837 535697 537105 542052 542087 542664 542920 544117 546002 546022 546580 546608 546817 546847 548593 548665 548729 548781 548872 550485 551798 552110 553685 553687 553931 553941 556019 556391 556879 557940 558377 558615 560485 561332 561439 561462 565859 565992 566345 568630 568845 569632 570710 571271 571713 573113 574425 575443 576137 577413 578856 579221 579605 581495 582477 584736 586656 591389 593376 598450 599320 621745 628161 681445 691713 701609 709428 ] |
||||||||||||||||||||||||||||||
|
17.68 ms (11.73%) |
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 466924 472410 475847 485025 485949 489702 445444 446086 451088 451614 452708 453236 459754 460129 460437 463163 463547 482121 484876 487221 491094 448064 450637 454949 457021 462903 468982 485847 486266 487534 490402 490752 497395 499005 504752 504764 506127 509515 512590 515263 525678 537105 494163 501352 507156 514037 534837 496334 499325 505469 507879 535697 459968 460092 477325 482973 542052 542920 548593 548781 552110 553931 553941 561462 571713 573113 575443 579605 542087 546817 546847 548665 553687 558377 560485 568845 569632 570710 574425 582477 542664 544117 546022 546608 548872 550485 551798 553685 556391 561332 561439 565992 566345 568630 571271 576137 578856 584736 691713 681445 701609 709428 546002 546580 548729 556019 556879 557940 558615 565859 577413 579221 581495 586656 598450 628161 591389 593376 599320 621745 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.16%) |
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 445444 446086 448064 450637 451088 451614 452708 453236 454949 457021 459754 459968 460092 460129 460437 462903 463163 463547 466924 468982 472410 475847 477325 482121 482973 484876 485025 485847 485949 486266 487221 487534 489702 490402 490752 491094 494163 496334 497395 499005 499325 501352 504752 504764 505469 506127 507156 507879 509515 512590 514037 515263 525678 534837 535697 537105 542052 542087 542664 542920 544117 546002 546022 546580 546608 546817 546847 548593 548665 548729 548781 548872 550485 551798 552110 553685 553687 553931 553941 556019 556391 556879 557940 558377 558615 560485 561332 561439 561462 565859 565992 566345 568630 568845 569632 570710 571271 571713 573113 574425 575443 576137 577413 578856 579221 579605 581495 582477 584736 586656 591389 593376 598450 599320 621745 628161 681445 691713 701609 709428 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ряд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ряд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ряд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
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.