Query Metrics
7
Database Queries
7
Different statements
228.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.58 ms (90.33%) |
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 401621 424646 425285 431794 435774 437120 437393 438401 439250 441239 443151 443860 444558 450816 451791 463672 466325 473761 474895 474907 474996 475149 476433 477932 481150 482774 490009 490745 493472 493773 495868 498944 504777 505416 508598 514886 517281 519479 522074 525763 526362 526961 542540 542945 544062 545917 546879 546908 547256 548593 548782 549683 552249 552865 555556 555585 555803 556011 556021 556209 558006 558680 558809 559503 559833 560584 561743 562472 562993 563352 564423 565599 565809 566219 566743 566938 568163 569235 570415 574807 574913 575185 579957 580291 581409 581969 582077 585207 586789 588111 589110 590319 591093 591367 593659 595361 597917 599727 600737 607558 607966 609838 614612 614954 617087 617686 623814 624391 625521 640895 674306 717898 721795 738050 741762 744947 746167 799239 803112 813276 ] |
||||||||||||||||||||||||||||||
|
13.63 ms (5.96%) |
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 431794 435774 439250 441239 443151 444558 437393 438401 482774 450816 474895 474996 481150 476433 490009 451791 466325 493773 504777 495868 525763 526961 498944 508598 514886 519479 505416 517281 522074 526362 490745 493472 542540 542945 544062 545917 547256 548593 558809 559503 565599 565809 568163 579957 580291 548782 552865 555585 556011 561743 562472 566938 570415 582077 555556 555803 558006 558680 559833 560584 562993 563352 564423 566219 569235 574807 575185 581409 581969 717898 674306 546879 546908 549683 552249 556021 556209 566743 574913 586789 591367 597917 600737 607558 614612 625521 590319 595361 599727 617087 640895 585207 593659 607966 588111 589110 591093 623814 624391 803112 813276 741762 746167 799239 744947 738050 609838 614954 617686 721795 401621 424646 425285 437120 443860 463672 473761 474907 475149 477932 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.97%) |
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 401621 424646 425285 431794 435774 437120 437393 438401 439250 441239 443151 443860 444558 450816 451791 463672 466325 473761 474895 474907 474996 475149 476433 477932 481150 482774 490009 490745 493472 493773 495868 498944 504777 505416 508598 514886 517281 519479 522074 525763 526362 526961 542540 542945 544062 545917 546879 546908 547256 548593 548782 549683 552249 552865 555556 555585 555803 556011 556021 556209 558006 558680 558809 559503 559833 560584 561743 562472 562993 563352 564423 565599 565809 566219 566743 566938 568163 569235 570415 574807 574913 575185 579957 580291 581409 581969 582077 585207 586789 588111 589110 590319 591093 591367 593659 595361 597917 599727 600737 607558 607966 609838 614612 614954 617087 617686 623814 624391 625521 640895 674306 717898 721795 738050 741762 744947 746167 799239 803112 813276 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"утра"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"утр"
]
|
||||||||||||||||||||||||||||||
|
1.34 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.