Query Metrics
7
Database Queries
7
Different statements
138.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.27 ms (82.25%) |
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 462785 488925 495210 496136 501080 506413 526978 533582 533826 534917 535976 538738 538758 542000 547119 548394 549443 549995 552713 553001 554690 557444 558979 567500 575404 576158 576424 579306 580998 581285 583779 587121 590306 606813 620707 622020 626202 627672 627833 630399 632792 633217 635640 639345 639881 644906 646727 648485 649840 661316 661327 661330 661358 661373 661378 661381 661575 664381 669868 671088 671098 672357 680741 687751 692435 692686 692713 695647 695654 695660 695677 695682 695814 695962 696019 696432 696688 697088 702359 705104 706067 718757 719876 719893 721956 726931 731002 745994 746633 768969 769931 770246 779605 779692 780114 780142 780155 780666 784163 789035 789345 790098 790175 791472 793044 798751 799723 802915 802921 802922 803948 810598 812217 812240 828041 828042 828071 828123 828269 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (9.14%) |
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 575404 462785 719893 661330 627672 547119 802921 538738 549443 793044 770246 697088 495210 661378 768969 590306 639881 790098 810598 661575 812217 769931 745994 803948 702359 798751 789035 828042 812240 488925 501080 526978 695647 719876 626202 587121 579306 632792 828041 552713 567500 695682 780155 726931 779605 828269 695814 784163 639345 664381 695654 549995 635640 576158 558979 671098 669868 620707 789345 680741 533582 671088 583779 746633 661327 799723 627833 630399 828156 496136 533826 542000 661381 646727 576424 633217 780666 790175 554690 780114 779692 548394 506413 649840 661358 606813 802915 802922 780142 791472 828123 828071 696019 706067 695660 692686 695962 580998 553001 696432 692713 696688 731002 622020 535976 644906 538758 534917 557444 581285 687751 695677 718757 648485 661316 661373 672357 692435 705104 721956 ] |
||||||||||||||||||||||||||||||
|
4.25 ms (3.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx на улиц"
]
|
||||||||||||||||||||||||||||||
|
2.40 ms (1.72%) |
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 462785 488925 495210 496136 501080 506413 526978 533582 533826 534917 535976 538738 538758 542000 547119 548394 549443 549995 552713 553001 554690 557444 558979 567500 575404 576158 576424 579306 580998 581285 583779 587121 590306 606813 620707 622020 626202 627672 627833 630399 632792 633217 635640 639345 639881 644906 646727 648485 649840 661316 661327 661330 661358 661373 661378 661381 661575 664381 669868 671088 671098 672357 680741 687751 692435 692686 692713 695647 695654 695660 695677 695682 695814 695962 696019 696432 696688 697088 702359 705104 706067 718757 719876 719893 721956 726931 731002 745994 746633 768969 769931 770246 779605 779692 780114 780142 780155 780666 784163 789035 789345 790098 790175 791472 793044 798751 799723 802915 802921 802922 803948 810598 812217 812240 828041 828042 828071 828123 828269 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx public"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.23%) |
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.