Query Metrics
7
Database Queries
7
Different statements
156.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.04 ms (82.96%) |
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 382507 389787 497056 506544 512424 514718 527075 530415 534619 546341 546814 550107 550172 550936 553674 553932 554209 554705 556093 562054 562631 564941 566737 575663 581038 589347 591211 592159 608679 618056 618662 622020 628623 632679 633408 633916 634221 635357 649837 652283 653820 655542 661342 663893 671098 672422 692683 692721 692763 694425 694432 695667 696055 696628 696673 696699 698802 707562 709932 712660 714042 719899 719907 723971 727448 728242 729564 732919 734030 736031 738427 739337 740747 742767 746967 748346 751240 754680 755662 757603 762061 768048 768770 769019 769508 779767 779843 780666 783525 783731 783761 786200 787021 788988 789069 790380 791308 791309 791317 797813 798667 798712 798746 799878 804389 804418 805072 805308 808710 809700 811987 812060 812228 814096 817519 821181 826903 828032 828137 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (10.89%) |
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 618662 530415 799878 740747 808710 754680 814096 812228 661342 546814 809700 755662 382507 497056 554705 564941 698802 692683 635357 591211 589347 791308 798712 786200 791309 746967 768048 694432 805072 727448 787021 512424 719899 821181 527075 546341 550936 562631 655542 692763 694425 696055 712660 672422 692721 695667 709932 652283 696628 696673 696699 707562 554209 632679 618056 592159 779767 783761 805308 778565 779843 739337 797813 728242 738427 751240 757603 762061 769508 732919 742767 783731 788988 812060 506544 553674 780666 790380 566737 789069 514718 826903 828137 828032 633916 581038 804418 736031 556093 768770 628623 817519 798746 798667 719907 575663 663893 804389 723971 748346 811987 649837 769019 534619 714042 633408 389787 553932 562054 550172 653820 783525 791317 734030 729564 550107 671098 608679 622020 634221 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.09%) |
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 382507 389787 497056 506544 512424 514718 527075 530415 534619 546341 546814 550107 550172 550936 553674 553932 554209 554705 556093 562054 562631 564941 566737 575663 581038 589347 591211 592159 608679 618056 618662 622020 628623 632679 633408 633916 634221 635357 649837 652283 653820 655542 661342 663893 671098 672422 692683 692721 692763 694425 694432 695667 696055 696628 696673 696699 698802 707562 709932 712660 714042 719899 719907 723971 727448 728242 729564 732919 734030 736031 738427 739337 740747 742767 746967 748346 751240 754680 755662 757603 762061 768048 768770 769019 769508 779767 779843 780666 783525 783731 783761 786200 787021 788988 789069 790380 791308 791309 791317 797813 798667 798712 798746 799878 804389 804418 805072 805308 808710 809700 811987 812060 812228 814096 817519 821181 826903 828032 828137 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public tits"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.91%) |
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.