Query Metrics
7
Database Queries
7
Different statements
386.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.35 ms (54.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
152.98 ms (39.55%) |
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 121824 131517 154123 319091 396037 398911 402602 417425 418568 455357 467138 488130 508703 510559 522166 528921 529804 530324 532697 535371 539751 540565 542259 544965 545923 547004 548024 548305 553854 557174 563900 565117 568112 573209 575980 576640 581267 596853 603354 604805 610118 619472 629971 639578 639986 641435 644127 647306 651074 658846 661049 664252 672826 686601 721178 725518 725582 732979 734097 738837 744474 746260 748014 752511 759703 761939 764366 769217 776819 776879 781153 786136 787011 787171 787254 791903 794289 794586 797637 797784 798269 799147 800414 801887 802966 803621 804606 804779 806972 807437 809030 809789 810618 811383 811928 812969 813768 814898 815526 815684 816063 817088 817942 819137 819160 819297 819313 820119 821521 823764 824674 826017 826211 826980 828620 828636 828651 828857 828858 ] |
||||||||||||||||||||||||||||||
|
11.84 ms (3.06%) |
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 547004 568112 573209 542259 575980 639578 797784 746260 752511 734097 812969 530324 803621 826211 488130 557174 759703 508703 797637 603354 121824 319091 820119 817088 828636 540565 548024 563900 619472 809030 791903 798269 809789 811383 787171 528921 661049 776819 776879 418568 814898 824674 819137 821521 467138 553854 644127 629971 794289 804779 738837 725518 806972 641435 826017 581267 545923 725582 610118 154123 810618 819160 664252 672826 455357 417425 828620 828634 510559 604805 828857 828858 131517 396037 813768 823764 828651 548305 647306 576640 596853 639986 799147 802966 807437 786136 787254 801887 804606 811928 748014 761939 744474 769217 764366 732979 721178 781153 787011 800414 402602 815526 819313 532697 535371 658846 794586 398911 815684 817942 816063 826980 819297 522166 529804 539751 544965 565117 651074 686601 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (1.04%) |
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 121824 131517 154123 319091 396037 398911 402602 417425 418568 455357 467138 488130 508703 510559 522166 528921 529804 530324 532697 535371 539751 540565 542259 544965 545923 547004 548024 548305 553854 557174 563900 565117 568112 573209 575980 576640 581267 596853 603354 604805 610118 619472 629971 639578 639986 641435 644127 647306 651074 658846 661049 664252 672826 686601 721178 725518 725582 732979 734097 738837 744474 746260 748014 752511 759703 761939 764366 769217 776819 776879 781153 786136 787011 787171 787254 791903 794289 794586 797637 797784 798269 799147 800414 801887 802966 803621 804606 804779 806972 807437 809030 809789 810618 811383 811928 812969 813768 814898 815526 815684 816063 817088 817942 819137 819160 819297 819313 820119 821521 823764 824674 826017 826211 826980 828620 828636 828651 828857 828858 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf большие boobs"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf big boobs"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf большие boobs"
]
|
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.