Query Metrics
7
Database Queries
7
Different statements
249.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.53 ms (88.77%) |
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 213561 270386 386050 391045 396958 421113 426839 457594 457639 503977 507084 521780 532367 535332 537104 539429 543688 547233 547939 547954 552049 555439 557162 557731 560504 560516 562131 566574 571744 572672 576175 581405 585089 586416 586973 588019 591151 606532 608398 609771 622090 622179 633965 635872 649226 651216 651906 653619 656603 659284 665114 665342 665440 672898 678986 680622 683126 688247 692470 693421 698088 700105 701195 704220 710119 712634 713853 714320 716848 717789 719812 720881 722489 728455 730669 730968 732535 734098 735089 742678 742876 746242 748815 752183 754198 756400 760998 761119 763040 766944 767168 771321 771490 775731 775947 776513 777217 779939 780930 785211 786569 788274 789108 799983 800816 800934 801095 801129 802213 802577 804188 805053 807371 807453 807555 808359 809698 811181 812785 813863 ] |
||||||||||||||||||||||||||||||
|
12.20 ms (4.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дел"
]
|
||||||||||||||||||||||||||||||
|
8.23 ms (3.30%) |
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 771321 735089 609771 698088 775731 776513 785211 800816 802213 213561 585089 457639 507084 521780 537104 532367 560516 543688 552049 562131 656603 665114 683126 692470 701195 672898 678986 710119 665440 693421 591151 586416 622179 588019 635872 586973 606532 608398 633965 786569 801095 802577 807371 807453 811181 777217 779939 788274 789108 807555 808359 812785 746242 754198 756400 766944 801129 804188 809698 752183 760998 728455 742678 742876 730968 732535 763040 767168 771490 730669 734098 748815 761119 700105 720881 775947 780930 799983 800934 805053 386050 270386 426839 391045 396958 421113 813863 457594 503977 535332 539429 555439 547954 557731 560504 581405 547939 557162 572672 649226 659284 704220 714320 653619 665342 680622 688247 712634 717789 651216 651906 713853 716848 719812 722489 547233 566574 571744 576175 622090 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.07%) |
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 213561 270386 386050 391045 396958 421113 426839 457594 457639 503977 507084 521780 532367 535332 537104 539429 543688 547233 547939 547954 552049 555439 557162 557731 560504 560516 562131 566574 571744 572672 576175 581405 585089 586416 586973 588019 591151 606532 608398 609771 622090 622179 633965 635872 649226 651216 651906 653619 656603 659284 665114 665342 665440 672898 678986 680622 683126 688247 692470 693421 698088 700105 701195 704220 710119 712634 713853 714320 716848 717789 719812 720881 722489 728455 730669 730968 732535 734098 735089 742678 742876 746242 748815 752183 754198 756400 760998 761119 763040 766944 767168 771321 771490 775731 775947 776513 777217 779939 780930 785211 786569 788274 789108 799983 800816 800934 801095 801129 802213 802577 804188 805053 807371 807453 807555 808359 809698 811181 812785 813863 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"делится"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.55%) |
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.