Query Metrics
7
Database Queries
7
Different statements
191.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.89 ms (89.04%) |
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 427240 443763 454254 472312 519218 519227 524987 524990 526114 538817 538831 538902 538926 540446 541403 543733 543818 544265 544272 544287 544289 544492 544573 544577 544587 545403 546625 550321 551009 551878 554783 556986 560087 563151 565345 566299 566672 566674 568030 568172 568269 571837 572424 573215 576122 576715 579260 581278 581294 581318 581329 584232 587973 590575 592391 592428 592444 592476 592489 592539 592550 597218 609208 609566 613521 614321 614354 614989 620144 620175 621715 622352 622370 624754 624816 624958 625488 626556 628291 628300 638334 641747 643033 644127 644287 644368 644881 687192 690823 690850 690931 691521 692214 692331 693040 693060 693985 698396 701427 701458 719134 720378 720795 722452 735931 740296 742138 742911 743851 745314 745993 747102 748423 771477 780605 780609 785339 790991 800530 805118 ] |
||||||||||||||||||||||||||||||
|
11.41 ms (5.95%) |
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 687192 690823 690850 690931 691521 692214 692331 693040 693060 693985 698396 722452 556986 565345 566672 568172 568269 572424 576122 581329 584232 587973 592539 597218 609208 621715 622370 624754 624958 628291 628300 592391 592428 614321 614989 620144 620175 622352 626556 644127 590575 624816 643033 609566 614354 625488 641747 644287 644368 780605 742911 743851 771477 805118 740296 742138 745314 735931 745993 747102 748423 613521 638334 701427 701458 719134 720378 780609 785339 790991 800530 526114 427240 524987 524990 538817 554783 563151 576715 720795 592489 592444 592476 592550 454254 472312 443763 519218 519227 644881 538831 538902 540446 538926 543733 543818 544265 544272 544287 544289 551878 560087 568030 571837 573215 579260 581294 581318 544492 544573 544587 566299 566674 581278 541403 544577 545403 546625 550321 551009 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.32%) |
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 427240 443763 454254 472312 519218 519227 524987 524990 526114 538817 538831 538902 538926 540446 541403 543733 543818 544265 544272 544287 544289 544492 544573 544577 544587 545403 546625 550321 551009 551878 554783 556986 560087 563151 565345 566299 566672 566674 568030 568172 568269 571837 572424 573215 576122 576715 579260 581278 581294 581318 581329 584232 587973 590575 592391 592428 592444 592476 592489 592539 592550 597218 609208 609566 613521 614321 614354 614989 620144 620175 621715 622352 622370 624754 624816 624958 625488 626556 628291 628300 638334 641747 643033 644127 644287 644368 644881 687192 690823 690850 690931 691521 692214 692331 693040 693060 693985 698396 701427 701458 719134 720378 720795 722452 735931 740296 742138 742911 743851 745314 745993 747102 748423 771477 780605 780609 785339 790991 800530 805118 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"винтаж 1993"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 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.