Query Metrics
7
Database Queries
7
Different statements
187.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.24 ms (87.74%) |
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 12708 64314 80653 81412 81637 87363 107874 223442 311697 327981 337234 343503 382254 382657 382756 384095 385199 387374 401599 401627 401738 402427 403823 406658 424870 426911 456682 458489 469720 480043 482557 494849 515300 523061 534376 542721 545319 548067 554741 555732 560264 567258 567639 571702 574409 577950 585692 592258 593855 594626 602763 603731 616060 628615 630572 634007 636556 636561 637505 654397 661035 706659 710843 713945 714969 720378 723151 726295 726325 726356 726438 727505 733249 733381 736907 740091 740171 740864 743860 744400 745314 746277 747396 747546 748938 749028 757605 761242 767751 769338 777621 777628 779028 779958 782578 785985 787493 789508 791009 791491 791494 792199 793740 794502 795641 798305 798594 799480 800252 800357 801057 803166 806149 807457 811360 812404 812424 813307 ] |
||||||||||||||||||||||||||||||
|
12.35 ms (6.60%) |
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 713945 654397 661035 710843 714969 723151 567258 567639 583788 628615 630572 594626 616060 634007 636556 637505 787493 798305 800252 811360 812424 777628 779958 791009 793740 795641 803166 806149 812404 733381 749028 761242 798594 800357 807457 746277 767751 726325 726356 726438 744400 745314 747396 763063 769338 726295 727505 733249 740091 740864 748938 736907 740171 743860 757605 636561 706659 720378 777621 779028 782578 785985 789508 813307 382254 87363 382756 387374 337234 382657 311697 343503 574409 555732 327981 80653 571702 592258 792199 107874 12708 402427 401738 401627 424870 456682 494849 482557 585692 603731 794502 801057 799480 64314 385199 401599 81637 403823 384095 469720 545319 602763 593855 577950 560264 542721 548067 534376 791494 791491 223442 406658 458489 747546 426911 81412 480043 523061 515300 554741 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.61%) |
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 12708 64314 80653 81412 81637 87363 107874 223442 311697 327981 337234 343503 382254 382657 382756 384095 385199 387374 401599 401627 401738 402427 403823 406658 424870 426911 456682 458489 469720 480043 482557 494849 515300 523061 534376 542721 545319 548067 554741 555732 560264 567258 567639 571702 574409 577950 585692 592258 593855 594626 602763 603731 616060 628615 630572 634007 636556 636561 637505 654397 661035 706659 710843 713945 714969 720378 723151 726295 726325 726356 726438 727505 733249 733381 736907 740091 740171 740864 743860 744400 745314 746277 747396 747546 748938 749028 757605 761242 767751 769338 777621 777628 779028 779958 782578 785985 787493 789508 791009 791491 791494 792199 793740 794502 795641 798305 798594 799480 800252 800357 801057 803166 806149 807457 811360 812404 812424 813307 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на лиц"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на лиц"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.