Query Metrics
7
Database Queries
7
Different statements
176.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.55 ms (89.36%) |
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 389787 391101 401948 431497 465246 476564 494682 499681 506544 512424 514718 522772 527262 527339 530641 533756 535379 539328 540054 543559 546341 546814 550107 550936 553610 553674 553932 554209 562054 562631 570931 577026 581038 592159 595086 608666 608679 610023 618071 622020 627655 628669 632679 633916 634221 643699 649484 649837 652283 653820 655542 655545 659472 665326 666014 669874 671098 672422 677916 692752 694425 694432 695667 696055 696628 696673 696699 707562 709932 712660 716137 724303 727448 728242 729564 732919 734030 734846 739337 739339 742767 751240 751381 755662 757603 759106 762061 769508 772836 778934 779767 779797 779829 779843 780666 780827 783525 783731 783761 788988 790380 791317 791496 797813 798709 805072 805308 809700 812225 812246 818752 819314 823841 824888 826903 827557 828032 828137 828508 ] |
||||||||||||||||||||||||||||||
|
9.59 ms (5.44%) |
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 546341 550936 562631 655542 694425 696055 712660 672422 695667 709932 652283 694432 696628 696673 696699 707562 716137 546814 554209 632679 592159 779767 783761 805308 778565 779843 739337 797813 805072 809700 727448 728242 751240 757603 762061 755662 769508 732919 742767 783731 788988 512424 780666 553610 759106 506544 671098 389787 826903 828137 828032 633916 790380 581038 553674 628669 818752 522772 665326 643699 812246 734846 791496 550107 570931 608679 649837 476564 514718 533756 539328 530641 499681 577026 655545 669874 649484 659472 692752 608666 618071 666014 527262 622020 653820 535379 401948 783525 791317 734030 729564 819314 823841 828508 751381 824888 827557 540054 627655 812225 553932 677916 610023 778934 779829 780827 739339 772836 779797 798709 527339 562054 543559 465246 595086 634221 724303 494682 391101 431497 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.57%) |
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 389787 391101 401948 431497 465246 476564 494682 499681 506544 512424 514718 522772 527262 527339 530641 533756 535379 539328 540054 543559 546341 546814 550107 550936 553610 553674 553932 554209 562054 562631 570931 577026 581038 592159 595086 608666 608679 610023 618071 622020 627655 628669 632679 633916 634221 643699 649484 649837 652283 653820 655542 655545 659472 665326 666014 669874 671098 672422 677916 692752 694425 694432 695667 696055 696628 696673 696699 707562 709932 712660 716137 724303 727448 728242 729564 732919 734030 734846 739337 739339 742767 751240 751381 755662 757603 759106 762061 769508 772836 778934 779767 779797 779829 779843 780666 780827 783525 783731 783761 788988 790380 791317 791496 797813 798709 805072 805308 809700 812225 812246 818752 819314 823841 824888 826903 827557 828032 828137 828508 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц соло"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public solo"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц соло"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.82%) |
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.