Query Metrics
7
Database Queries
7
Different statements
182.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.39 ms (86.16%) |
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 450278 452939 454174 454888 458485 459277 460182 461147 461669 461939 464149 465088 465945 466842 467110 467860 473449 473560 474053 474452 476316 478577 479701 484076 486167 486197 487682 488679 491132 491623 493045 494698 496095 497181 504441 506654 511311 511623 512816 513812 514905 517026 520152 521235 523419 524026 525993 526299 526584 527230 529674 530511 532980 534741 534767 537100 537927 541394 543369 543433 544893 545052 545486 546652 547659 549235 549691 550379 550408 551227 552136 552303 552336 552337 552700 554068 554246 555790 558037 558042 558366 558368 558832 559335 560539 560609 560957 561464 561653 562237 567535 569846 569858 569913 570018 570188 570282 570447 570500 570584 571932 572155 572159 572339 572402 573067 573692 573697 574539 574589 575219 576662 577250 579145 581573 581940 582399 582634 583230 645618 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (8.35%) |
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 450278 458485 461147 461669 473449 454174 459277 461939 464149 466842 467110 474452 452939 454888 460182 467860 473560 476316 478577 484076 487682 488679 491132 491623 496095 497181 512816 520152 524026 529674 530511 511311 514905 517026 526584 527230 532980 504441 511623 513812 521235 525993 534741 537100 494698 506654 523419 526299 534767 537927 465088 465945 474053 479701 486167 486197 493045 541394 543433 545052 552337 554246 558042 558366 560609 570018 570188 571932 572159 572339 575219 577250 581573 543369 545486 549691 550379 552700 558368 560539 560957 562237 569846 569858 570500 572402 573067 573692 573697 574539 574589 576662 581940 582634 544893 546652 547659 549235 550408 551227 552136 552303 552336 554068 555790 558037 558832 559335 561464 561653 567535 569913 570282 570447 570584 572155 579145 582399 583230 645618 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.75%) |
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 450278 452939 454174 454888 458485 459277 460182 461147 461669 461939 464149 465088 465945 466842 467110 467860 473449 473560 474053 474452 476316 478577 479701 484076 486167 486197 487682 488679 491132 491623 493045 494698 496095 497181 504441 506654 511311 511623 512816 513812 514905 517026 520152 521235 523419 524026 525993 526299 526584 527230 529674 530511 532980 534741 534767 537100 537927 541394 543369 543433 544893 545052 545486 546652 547659 549235 549691 550379 550408 551227 552136 552303 552336 552337 552700 554068 554246 555790 558037 558042 558366 558368 558832 559335 560539 560609 560957 561464 561653 562237 567535 569846 569858 569913 570018 570188 570282 570447 570500 570584 571932 572155 572159 572339 572402 573067 573692 573697 574539 574589 575219 576662 577250 579145 581573 581940 582399 582634 583230 645618 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"нов"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"новое 2024"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.79%) |
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.