Query Metrics
7
Database Queries
7
Different statements
147.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.82 ms (84.37%) |
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 404051 458356 478183 480613 485990 487541 536196 541287 549051 551134 551588 556171 584520 587104 606859 609572 618208 622460 627059 627624 632886 642288 642854 644138 660652 676695 683877 686521 693367 693511 695780 695800 697205 700814 700915 704167 707540 709834 713690 715401 715655 716060 721782 723574 726287 726739 730030 732616 732789 732850 733949 735965 736328 737365 738299 741174 742773 750328 755144 755146 757285 757587 757634 761477 762098 762956 764126 765480 765932 768023 770071 770454 770645 770747 772778 777674 778450 778717 778905 779737 779932 780378 782767 782799 784570 784805 784844 785264 785830 786283 787194 787655 787874 788061 788966 791968 792139 794470 795048 795618 796290 796902 802015 802102 813836 814233 817547 818000 818320 818981 819760 820185 823821 825528 825715 826071 826685 827140 827705 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (9.86%) |
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 700814 709834 697205 757285 788061 795618 732616 733949 764126 770645 770071 736328 704167 787874 794470 796902 404051 819760 826685 823821 827140 827705 813836 826071 825528 541287 551588 556171 693511 686521 627624 777674 780378 784844 786283 778905 788966 726739 735965 757634 765480 757587 715655 721782 761477 732850 551134 676695 584520 644138 791968 770454 779932 817547 713690 695800 700915 632886 779737 741174 755144 772778 726287 742773 787655 723574 536196 660652 693367 715401 716060 606859 622460 587104 642854 778450 778717 782767 784805 792139 796290 732789 755146 765932 770747 750328 737365 802102 818000 825715 485990 478183 480613 695780 683877 618208 782799 785830 785264 762956 795048 738299 762098 730030 768023 707540 784570 818981 820185 818320 814233 826133 487541 458356 549051 627059 642288 609572 787194 802015 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.94%) |
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 404051 458356 478183 480613 485990 487541 536196 541287 549051 551134 551588 556171 584520 587104 606859 609572 618208 622460 627059 627624 632886 642288 642854 644138 660652 676695 683877 686521 693367 693511 695780 695800 697205 700814 700915 704167 707540 709834 713690 715401 715655 716060 721782 723574 726287 726739 730030 732616 732789 732850 733949 735965 736328 737365 738299 741174 742773 750328 755144 755146 757285 757587 757634 761477 762098 762956 764126 765480 765932 768023 770071 770454 770645 770747 772778 777674 778450 778717 778905 779737 779932 780378 782767 782799 784570 784805 784844 785264 785830 786283 787194 787655 787874 788061 788966 791968 792139 794470 795048 795618 796290 796902 802015 802102 813836 814233 817547 818000 818320 818981 819760 820185 823821 825528 825715 826071 826685 827140 827705 ] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"came секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"came sex"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"came секс"
]
|
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.