Query Metrics
7
Database Queries
7
Different statements
157.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.71 ms (84.97%) |
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 384541 515844 536269 539571 543222 543452 545609 550408 551292 552243 560784 562276 562280 562322 563542 569883 570015 570228 570245 570256 570299 570345 570351 570375 570385 570571 571188 571470 571861 571891 571913 572045 572089 572149 572383 572450 572471 573076 573577 573598 573695 573828 579596 592516 598039 604467 608015 611922 621451 621662 624830 644341 654822 655723 656022 656082 656358 656396 656471 656678 656701 657052 657063 657093 657096 657105 657307 657394 657443 657573 657697 657928 657972 658050 658072 658088 658301 658305 658346 658364 658400 658415 658424 658703 658704 659083 659149 659544 659578 659641 659647 659655 659685 659702 659744 659757 659774 659791 660476 661107 670162 670171 671101 671325 674784 686072 691879 703163 713251 714458 718696 722295 725342 748663 748667 786713 819533 828390 828738 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (8.28%) |
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 560784 571188 550408 545609 563542 718696 598039 608015 828391 571861 572471 572149 570345 571891 579596 656022 656358 657928 658088 658415 659083 659149 659641 659774 660476 670171 674784 713251 656471 656678 657063 657394 658050 658301 658305 658424 659647 659655 671101 654822 655723 656082 657052 657307 657972 658703 658704 659544 659685 659744 661107 670162 686072 691879 722295 570228 570375 644341 725342 621662 703163 592516 570351 570571 570245 570256 570299 573577 562280 571913 573598 573695 671325 552243 570015 570385 621451 748663 748667 611922 786713 819533 515844 536269 551292 714458 384541 604467 624830 828738 828390 539571 562322 569883 572089 543222 543452 572383 573076 562276 571470 572045 572450 573828 656396 656701 657093 657096 657105 657443 657573 657697 658072 658346 658364 658400 659578 659702 659757 659791 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.64%) |
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 384541 515844 536269 539571 543222 543452 545609 550408 551292 552243 560784 562276 562280 562322 563542 569883 570015 570228 570245 570256 570299 570345 570351 570375 570385 570571 571188 571470 571861 571891 571913 572045 572089 572149 572383 572450 572471 573076 573577 573598 573695 573828 579596 592516 598039 604467 608015 611922 621451 621662 624830 644341 654822 655723 656022 656082 656358 656396 656471 656678 656701 657052 657063 657093 657096 657105 657307 657394 657443 657573 657697 657928 657972 658050 658072 658088 658301 658305 658346 658364 658400 658415 658424 658703 658704 659083 659149 659544 659578 659641 659647 659655 659685 659702 659744 659757 659774 659791 660476 661107 670162 670171 671101 671325 674784 686072 691879 703163 713251 714458 718696 722295 725342 748663 748667 786713 819533 828390 828738 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая большие"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая большие"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small big"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.13%) |
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.