Query Metrics
7
Database Queries
7
Different statements
199.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.09 ms (89.07%) |
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 13066 34580 47220 53553 68383 94796 96118 96250 97055 97288 134454 143085 221091 226028 285986 323581 350861 368131 382929 384595 385048 385205 388449 391933 395970 396012 401969 403243 408460 409024 409364 411030 412966 419627 421839 433231 433295 443094 453812 462685 465054 468638 468671 470483 478709 481162 495014 496792 502889 503044 506279 506823 509998 514841 519261 522357 527653 528053 528867 541721 541751 541885 543177 544746 549341 559181 573156 574410 580620 588792 590584 590906 595796 598111 601217 606778 624819 640614 641930 649139 649647 650109 667449 671748 672099 672987 674107 676522 682497 684251 699757 702047 705794 711689 724207 726431 731699 732299 736664 739062 743053 745493 748741 775783 775926 777303 782030 784685 786031 792486 793394 793406 793473 794703 799674 799929 802103 807549 815023 822003 ] |
||||||||||||||||||||||||||||||
|
12.04 ms (6.02%) |
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 411030 468638 506279 527653 395970 388449 408460 433295 409024 443094 433231 453812 465054 519261 522357 528867 506823 528053 574410 682497 650109 559181 580620 590906 595796 606778 641930 588792 745493 748741 640614 385205 412966 470483 462685 468671 396012 481162 503044 495014 496792 514841 502889 509998 541885 573156 541751 419627 421839 541721 382929 94796 96118 96250 143085 221091 323581 368131 34580 47220 649647 667449 684251 549341 590584 777303 782030 793473 799929 799674 726431 739062 731699 784685 350861 384595 391933 53553 68383 385048 226028 134454 285986 97288 13066 97055 401969 403243 409364 815023 822003 478709 543177 544746 699757 711689 671748 676522 649139 672099 672987 674107 702047 705794 598111 624819 601217 775783 775926 792486 793394 794703 802103 807549 786031 793406 743053 732299 736664 724207 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (1.86%) |
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 13066 34580 47220 53553 68383 94796 96118 96250 97055 97288 134454 143085 221091 226028 285986 323581 350861 368131 382929 384595 385048 385205 388449 391933 395970 396012 401969 403243 408460 409024 409364 411030 412966 419627 421839 433231 433295 443094 453812 462685 465054 468638 468671 470483 478709 481162 495014 496792 502889 503044 506279 506823 509998 514841 519261 522357 527653 528053 528867 541721 541751 541885 543177 544746 549341 559181 573156 574410 580620 588792 590584 590906 595796 598111 601217 606778 624819 640614 641930 649139 649647 650109 667449 671748 672099 672987 674107 676522 682497 684251 699757 702047 705794 711689 724207 726431 731699 732299 736664 739062 743053 745493 748741 775783 775926 777303 782030 784685 786031 792486 793394 793406 793473 794703 799674 799929 802103 807549 815023 822003 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2021 sex"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.59%) |
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.