Query Metrics
7
Database Queries
7
Different statements
208.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.91 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.66 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жены оргазм"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.21 ms |
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 540118 501061 535100 549661 575369 543993 714091 662165 693761 693801 598623 630270 604226 784626 787774 794030 796071 808652 811221 795395 724943 729567 753199 784127 785087 794680 797857 800429 803960 736017 748624 765360 714079 719902 796327 810377 440898 434382 437970 455134 493352 502780 508154 588650 795820 764081 680323 766155 417083 820180 825649 826234 825227 529933 795006 800389 734415 637549 798791 810089 768890 768701 564120 398824 402628 434326 441615 442510 540868 823368 813822 456939 449300 456127 489312 489324 449992 452341 498278 536470 527194 486065 558879 582558 584623 548534 564510 555998 567077 580207 662129 708062 713918 714028 545001 561979 586965 585618 600539 637959 638737 639102 778866 782096 789042 795983 782821 793671 806947 806952 810059 812495 784629 785503 786082 806943 812672 772941 739923 757393 ] |
||||||||||||||||||||||||||||||
| 4 | 2.81 ms |
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 398824 402628 417083 434326 434382 437970 440898 441615 442510 449300 449992 452341 455134 456127 456939 486065 489312 489324 493352 498278 501061 502780 508154 527194 529933 535100 536470 540118 540868 543993 545001 548534 549661 555998 558879 561979 564120 564510 567077 575369 580207 582558 584623 585618 586965 588650 598623 600539 604226 630270 637549 637959 638737 639102 662129 662165 680323 693761 693801 708062 713918 714028 714079 714091 719902 724943 729567 734415 736017 739923 748624 753199 757393 764081 765360 766155 768701 768890 772941 778866 782096 782821 784127 784626 784629 785087 785503 786082 787774 789042 793671 794030 794680 795006 795395 795820 795983 796071 796327 797857 798791 800389 800429 803960 806943 806947 806952 808652 810059 810089 810377 811221 812495 812672 813822 820180 823368 825227 825649 826234 ] |
||||||||||||||||||||||||||||||
| 5 | 185.30 ms |
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 398824 402628 417083 434326 434382 437970 440898 441615 442510 449300 449992 452341 455134 456127 456939 486065 489312 489324 493352 498278 501061 502780 508154 527194 529933 535100 536470 540118 540868 543993 545001 548534 549661 555998 558879 561979 564120 564510 567077 575369 580207 582558 584623 585618 586965 588650 598623 600539 604226 630270 637549 637959 638737 639102 662129 662165 680323 693761 693801 708062 713918 714028 714079 714091 719902 724943 729567 734415 736017 739923 748624 753199 757393 764081 765360 766155 768701 768890 772941 778866 782096 782821 784127 784626 784629 785087 785503 786082 787774 789042 793671 794030 794680 795006 795395 795820 795983 796071 796327 797857 798791 800389 800429 803960 806943 806947 806952 808652 810059 810089 810377 811221 812495 812672 813822 820180 823368 825227 825649 826234 ] |
||||||||||||||||||||||||||||||
| 6 | 2.00 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен оргазм"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.93 ms |
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.