Query Metrics
7
Database Queries
7
Different statements
142.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.43 ms (82.95%) |
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 232085 384497 389660 391101 397673 401948 482884 492164 501280 509784 534864 535359 535379 535396 535616 536068 540054 542721 543559 560493 562529 562936 573989 575383 581180 584360 589771 590606 592337 595086 606052 611413 611687 614215 614385 617242 618005 618072 618189 619414 619646 621168 622020 627655 627851 635057 635720 650037 661353 661387 665326 684055 689266 692824 695670 696053 696058 696664 696675 696687 696698 696716 697085 702347 702360 714040 716582 717224 718593 720470 724303 733511 734846 736498 741580 746481 751217 751381 751419 752477 753999 754635 758949 761160 768293 771514 773498 776359 777601 778765 779339 779692 780172 780902 781482 782668 785526 785533 787145 788892 789066 790647 791105 791494 791643 793050 797920 804169 807275 811637 812225 812246 814299 818752 824888 827557 828223 828244 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (9.74%) |
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 776359 741580 768293 733511 751217 752477 753999 751419 761160 782668 543559 482884 696058 779339 791105 791643 697085 811637 779692 818752 665326 812246 734846 751381 696053 622020 696664 780902 595086 724303 492164 785533 391101 684055 696698 696716 695670 696675 702347 716582 720470 589771 619414 804169 736498 754635 696687 718593 828009 501280 614215 618005 592337 780172 536068 540054 627655 606052 509784 401948 232085 827557 828244 389660 535379 824888 702360 542721 618189 535616 562936 785526 384497 828223 812225 746481 758949 534864 573989 650037 621168 635720 627851 535396 562529 575383 717224 778765 769831 771514 773498 581180 777601 787145 789066 814299 790647 807275 791494 793050 619646 781482 611687 797920 689266 692824 714040 661353 661387 584360 590606 611413 614385 618072 617242 635057 788892 397673 535359 560493 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.95%) |
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 232085 384497 389660 391101 397673 401948 482884 492164 501280 509784 534864 535359 535379 535396 535616 536068 540054 542721 543559 560493 562529 562936 573989 575383 581180 584360 589771 590606 592337 595086 606052 611413 611687 614215 614385 617242 618005 618072 618189 619414 619646 621168 622020 627655 627851 635057 635720 650037 661353 661387 665326 684055 689266 692824 695670 696053 696058 696664 696675 696687 696698 696716 697085 702347 702360 714040 716582 717224 718593 720470 724303 733511 734846 736498 741580 746481 751217 751381 751419 752477 753999 754635 758949 761160 768293 771514 773498 776359 777601 778765 779339 779692 780172 780902 781482 782668 785526 785533 787145 788892 789066 790647 791105 791494 791643 793050 797920 804169 807275 811637 812225 812246 814299 818752 824888 827557 828223 828244 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public amateur"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц любительск"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.21%) |
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.