Query Metrics
7
Database Queries
7
Different statements
187.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.17 ms (86.15%) |
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 69871 125934 132984 172224 191511 197757 233677 365993 386408 387717 388075 390640 396546 398213 402515 406210 412582 458224 466598 470487 487234 510186 512635 515544 515579 520377 521222 525337 526373 527468 530107 533692 533693 535909 536515 540281 540706 541360 542248 545923 551190 553905 557985 558660 559171 560751 564753 565718 567470 568055 570128 576436 577822 579671 584935 587921 589086 589509 598040 598164 599030 599463 607176 610628 613924 617275 620257 622773 624265 645142 647077 650393 652221 657950 658433 671488 698758 704487 705963 709076 720040 728875 730677 732063 734574 736008 738131 738941 739706 742254 743569 743700 744945 746598 751485 754380 754613 754975 755238 755242 764106 764796 767119 768402 768901 771471 772649 774319 776695 781929 786545 788447 789194 797037 797199 803085 803482 813691 813907 814354 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (7.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 771471 774319 732063 738941 744945 754975 764106 767119 728875 730677 738131 739706 742254 751485 755238 755242 764796 768402 768901 734574 736008 743569 743700 746598 754380 754613 772649 624265 698758 704487 705963 709076 720040 776695 781929 786545 788447 789194 797037 797199 803085 803482 69871 233677 365993 412582 197757 172224 388075 466598 398213 521222 526373 551190 557985 565718 577822 658433 568055 589086 598164 613924 617275 599463 607176 610628 620257 587921 589509 598040 599030 622773 458224 406210 470487 515579 525337 527468 510186 515544 386408 132984 125934 191511 390640 387717 396546 402515 813907 814354 813691 487234 512635 530107 533693 536515 520377 540281 533692 535909 540706 541360 542248 553905 576436 559171 564753 570128 584935 545923 558660 560751 567470 579671 645142 647077 650393 652221 657950 671488 ] |
||||||||||||||||||||||||||||||
|
3.94 ms (2.10%) |
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 69871 125934 132984 172224 191511 197757 233677 365993 386408 387717 388075 390640 396546 398213 402515 406210 412582 458224 466598 470487 487234 510186 512635 515544 515579 520377 521222 525337 526373 527468 530107 533692 533693 535909 536515 540281 540706 541360 542248 545923 551190 553905 557985 558660 559171 560751 564753 565718 567470 568055 570128 576436 577822 579671 584935 587921 589086 589509 598040 598164 599030 599463 607176 610628 613924 617275 620257 622773 624265 645142 647077 650393 652221 657950 658433 671488 698758 704487 705963 709076 720040 728875 730677 732063 734574 736008 738131 738941 739706 742254 743569 743700 744945 746598 751485 754380 754613 754975 755238 755242 764106 764796 767119 768402 768901 771471 772649 774319 776695 781929 786545 788447 789194 797037 797199 803085 803482 813691 813907 814354 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"свое"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сво"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сво"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
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.