Query Metrics
7
Database Queries
7
Different statements
164.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.10 ms (85.39%) |
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 50344 382507 405775 423128 465246 472812 494682 506544 509784 527075 527262 527339 528341 533729 539099 542721 543559 546341 546814 547073 547120 547126 550107 550595 550936 552283 553932 554209 556869 562054 562631 562936 565382 570931 592159 595086 599763 608679 610023 611687 618056 618189 632679 633916 634221 634376 652283 653820 655542 661342 661377 665330 666014 666991 669930 672422 677916 692721 692763 694425 694432 695667 696055 696628 696673 696699 697287 704669 707562 709932 712660 716137 719905 724303 727448 728242 729564 732919 734030 738427 739337 739339 742767 751240 754680 755662 757603 759106 760932 762061 767495 769508 772836 778934 779767 779797 779829 779843 780827 783525 783731 783761 785526 787021 788988 791317 797813 798709 801589 805072 805308 808710 809700 812060 821181 826903 828032 828137 828212 ] |
||||||||||||||||||||||||||||||
|
14.29 ms (8.71%) |
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 382507 634376 783525 791317 734030 729564 704669 533729 528341 547073 719905 556869 506544 539099 423128 509784 527339 562054 543559 565382 472812 828212 547126 665330 697287 653820 547120 759106 821181 527075 546341 550936 562631 655542 661377 692763 694425 696055 712660 672422 692721 695667 709932 652283 661342 666991 669930 694432 696628 696673 696699 707562 716137 546814 550595 554209 632679 618056 592159 779767 783761 801589 805308 778565 779843 739337 797813 805072 808710 809700 727448 728242 738427 751240 757603 762061 755662 754680 769508 732919 742767 783731 787021 788988 812060 405775 50344 562936 767495 550107 553932 570931 677916 599763 610023 778934 779829 780827 739339 772836 760932 608679 779797 798709 552283 542721 611687 618189 785526 465246 666014 595086 634221 724303 494682 527262 826903 828137 828032 633916 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.52%) |
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 50344 382507 405775 423128 465246 472812 494682 506544 509784 527075 527262 527339 528341 533729 539099 542721 543559 546341 546814 547073 547120 547126 550107 550595 550936 552283 553932 554209 556869 562054 562631 562936 565382 570931 592159 595086 599763 608679 610023 611687 618056 618189 632679 633916 634221 634376 652283 653820 655542 661342 661377 665330 666014 666991 669930 672422 677916 692721 692763 694425 694432 695667 696055 696628 696673 696699 697287 704669 707562 709932 712660 716137 719905 724303 727448 728242 729564 732919 734030 738427 739337 739339 742767 751240 754680 755662 757603 759106 760932 762061 767495 769508 772836 778934 779767 779797 779829 779843 780827 783525 783731 783761 785526 787021 788988 791317 797813 798709 801589 805072 805308 808710 809700 812060 821181 826903 828032 828137 828212 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx public"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx на улиц"
]
|
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.