Query Metrics
7
Database Queries
7
Different statements
198.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.64 ms (86.01%) |
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 282218 386142 387366 389171 394488 396236 396308 400138 410682 410995 411468 416288 418494 418958 420398 426030 427786 429880 439638 445220 445228 445803 446331 448711 450226 451452 454212 455504 456865 458974 460752 463673 465162 465333 466386 467934 469303 474875 476349 481162 483502 484607 486259 486763 489691 490380 491290 491508 491535 496182 496397 500077 500571 500995 505639 506044 506821 507211 508856 510612 512322 512369 512606 512843 512897 513781 514797 515745 521492 521759 521820 522284 522767 524052 524109 524456 526663 526774 526818 526886 529171 529187 538237 540779 545622 548191 549159 551617 560470 561470 561985 562775 565565 567382 567677 570407 570839 570878 571464 576052 576344 577377 588376 590345 594087 596453 600456 601364 601551 602971 611290 617188 622704 654786 657768 661989 693965 739090 795880 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (8.89%) |
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 446331 456865 282218 400138 389171 394488 410995 469303 418958 465162 522767 513781 538237 524052 549159 491290 521492 657768 529171 507211 416288 445228 455504 486259 571464 601364 463673 506044 505639 427786 474875 512369 515745 476349 561470 560470 654786 567382 596453 590345 622704 617188 467934 396236 450226 420398 486763 483502 512606 522284 491535 500571 500995 739090 387366 521820 567677 576052 576344 693965 661989 565565 577377 600456 602971 594087 460752 445220 458974 466386 411468 418494 429880 526818 484607 496182 506821 512322 510612 524109 508856 529187 386142 448711 445803 496397 521759 570407 570839 588376 611290 426030 451452 439638 500077 524456 490380 514797 489691 526886 512897 795880 551617 561985 454212 548191 570878 545622 562775 601551 465333 481162 526663 491508 512843 526774 766674 396308 410682 540779 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.38%) |
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 282218 386142 387366 389171 394488 396236 396308 400138 410682 410995 411468 416288 418494 418958 420398 426030 427786 429880 439638 445220 445228 445803 446331 448711 450226 451452 454212 455504 456865 458974 460752 463673 465162 465333 466386 467934 469303 474875 476349 481162 483502 484607 486259 486763 489691 490380 491290 491508 491535 496182 496397 500077 500571 500995 505639 506044 506821 507211 508856 510612 512322 512369 512606 512843 512897 513781 514797 515745 521492 521759 521820 522284 522767 524052 524109 524456 526663 526774 526818 526886 529171 529187 538237 540779 545622 548191 549159 551617 560470 561470 561985 562775 565565 567382 567677 570407 570839 570878 571464 576052 576344 577377 588376 590345 594087 596453 600456 601364 601551 602971 611290 617188 622704 654786 657768 661989 693965 739090 795880 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"в комнат"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в комнат"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.