Query Metrics
7
Database Queries
7
Different statements
201.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.28 ms (86.29%) |
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 382140 382186 386531 389813 403928 413161 416791 419220 428300 428653 429188 429266 430709 431504 444337 444414 450321 453548 454092 454605 458390 463810 468369 470412 472536 473166 475465 479779 481591 482195 484532 486288 487359 488811 491749 492247 492275 493269 494438 499860 508942 510241 512471 513894 513910 514105 515123 517180 518465 523654 524596 527686 528324 530850 552252 554275 561451 565678 566138 573941 579761 580221 580225 584990 585366 586244 595803 599637 602548 602636 602967 606649 607704 617360 618525 621343 623250 628758 630909 634515 638040 639774 642525 643960 649789 662633 676313 684096 703472 703494 703642 709260 721187 732074 733317 764869 776611 778393 784275 785624 786526 788828 793042 797075 797439 801234 801668 807599 811005 811062 813520 813881 814313 814781 814878 815159 816803 818119 821365 ] |
||||||||||||||||||||||||||||||
|
17.02 ms (8.43%) |
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 638040 643960 776611 778393 785624 788828 793042 801668 419220 428300 429188 444414 486288 492275 618525 709260 813881 649789 470412 482195 444337 508942 488811 389813 403928 429266 814313 818119 815159 821365 487359 492247 463810 473166 484532 454605 517180 518465 527686 528324 494438 499860 530850 524596 472536 552252 579761 561451 580221 662633 676313 703642 721187 684096 703494 554275 565678 580225 602548 617360 585366 602636 642525 586244 595803 599637 602967 607704 623250 628758 606649 621343 634515 807599 811062 784275 801234 813520 732074 764869 733317 630909 703472 786526 797439 811005 468369 386531 416791 491749 639774 584990 573941 430709 512471 523654 824638 797075 382140 382186 413161 428653 431504 816803 814781 814878 450321 458390 453548 454092 475465 479779 493269 510241 513910 515123 513894 514105 481591 566138 ] |
||||||||||||||||||||||||||||||
|
3.25 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 382140 382186 386531 389813 403928 413161 416791 419220 428300 428653 429188 429266 430709 431504 444337 444414 450321 453548 454092 454605 458390 463810 468369 470412 472536 473166 475465 479779 481591 482195 484532 486288 487359 488811 491749 492247 492275 493269 494438 499860 508942 510241 512471 513894 513910 514105 515123 517180 518465 523654 524596 527686 528324 530850 552252 554275 561451 565678 566138 573941 579761 580221 580225 584990 585366 586244 595803 599637 602548 602636 602967 606649 607704 617360 618525 621343 623250 628758 630909 634515 638040 639774 642525 643960 649789 662633 676313 684096 703472 703494 703642 709260 721187 732074 733317 764869 776611 778393 784275 785624 786526 788828 793042 797075 797439 801234 801668 807599 811005 811062 813520 813881 814313 814781 814878 815159 816803 818119 821365 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina hot"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская hot"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская hot"
]
|
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.