Query Metrics
7
Database Queries
7
Different statements
175.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.97 ms (87.18%) |
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 383415 391190 406445 416016 428940 430607 444192 473692 542953 547187 552002 552145 552151 552186 552192 552222 552226 552243 562201 562256 562280 566618 569868 570006 570015 570245 570246 570256 570299 570351 570375 570385 570498 571510 571643 571652 571885 571913 572085 572151 572483 573046 573577 573598 573695 573826 575632 580271 580673 584893 586932 589346 593239 596625 597811 597825 598039 598547 623175 628021 633908 639243 648595 654576 654650 654706 655652 655673 656475 656948 657401 657638 657701 657712 658301 658566 658690 658740 659524 659544 659655 659774 660546 662833 668729 672677 678551 691879 710491 713251 715103 718658 723392 723451 731893 738925 739914 740482 743157 744796 750360 751287 751376 754264 764054 771772 782520 790242 810752 811131 818111 818199 828059 828161 828392 828504 ] |
||||||||||||||||||||||||||||||
|
11.99 ms (6.84%) |
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 575632 823395 821981 658690 828161 570245 570256 552145 790242 391190 597811 648595 633908 738925 782520 598039 654706 654576 656475 658740 416016 598547 811131 828392 828504 668729 570351 570299 552186 569868 573695 552243 570015 570385 580271 406445 731893 584893 810752 473692 751376 750360 573826 623175 566618 593239 672677 744796 572483 552192 662833 655673 723392 771772 751287 659544 678551 710491 383415 444192 818111 657638 655652 657401 657701 658566 660546 654650 656948 657712 659524 723451 586932 786797 743157 828059 715103 691879 430607 739914 571510 552002 818199 547187 659774 713251 658301 659655 570375 628021 552226 573577 562280 571913 573598 562256 428940 562201 569904 570246 572151 542953 570006 571643 552151 552222 571885 570498 571652 572085 580673 589346 596625 597825 639243 740482 754264 764054 573046 718658 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (1.98%) |
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 383415 391190 406445 416016 428940 430607 444192 473692 542953 547187 552002 552145 552151 552186 552192 552222 552226 552243 562201 562256 562280 566618 569868 570006 570015 570245 570246 570256 570299 570351 570375 570385 570498 571510 571643 571652 571885 571913 572085 572151 572483 573046 573577 573598 573695 573826 575632 580271 580673 584893 586932 589346 593239 596625 597811 597825 598039 598547 623175 628021 633908 639243 648595 654576 654650 654706 655652 655673 656475 656948 657401 657638 657701 657712 658301 658566 658690 658740 659524 659544 659655 659774 660546 662833 668729 672677 678551 691879 710491 713251 715103 718658 723392 723451 731893 738925 739914 740482 743157 744796 750360 751287 751376 754264 764054 771772 782520 790242 810752 811131 818111 818199 828059 828161 828392 828504 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"маленькие сиськи девушка"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ девушк"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.74%) |
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.