Query Metrics
7
Database Queries
7
Different statements
133.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.44 ms (85.26%) |
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 50344 232085 384497 389660 401948 423128 486044 492164 501280 509784 530641 534864 535379 535396 535616 536068 539962 540054 541190 542721 552587 562529 562936 573989 575383 575615 577026 578937 589771 590606 592337 606052 611687 614215 614385 617885 618005 618071 618189 618600 619414 621168 627191 627655 627851 629774 635720 650037 666978 684055 689266 692752 692824 695670 696053 696058 696642 696664 696675 696687 696698 696716 697085 701708 702347 702360 705709 707973 709512 716582 717224 718593 720470 731147 733511 736498 741580 745074 746481 751217 751419 753999 758949 761160 768293 771514 773498 775250 775815 776359 778765 779324 779692 779820 780172 780734 780902 781438 785526 785533 788892 790647 791105 791494 791643 793050 795992 804169 809987 812225 813329 813545 814299 824888 826343 827557 828223 828244 ] |
||||||||||||||||||||||||||||||
|
10.07 ms (7.57%) |
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 539962 530641 575615 577026 666978 684055 696053 696058 696698 705709 709512 696716 692752 695670 696675 701708 702347 707973 716582 720470 589771 618071 619414 618600 627191 629774 775250 781438 791105 776359 791643 804169 736498 741580 768293 733511 751217 753999 751419 761160 617885 696664 696687 697085 718593 780902 578937 828244 486044 779692 828009 492164 501280 614215 618005 785533 401948 702360 592337 780172 389660 535379 535616 535396 573989 650037 790647 778765 791494 788892 384497 232085 824888 827557 828223 536068 540054 627655 606052 812225 746481 509784 813545 552587 689266 692824 590606 614385 779324 780734 809987 745074 731147 779820 813329 795992 542721 611687 618189 785526 423128 562936 814299 534864 562529 575383 541190 696642 717224 621168 635720 758949 793050 769831 771514 773498 627851 775815 50344 826343 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (2.15%) |
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 50344 232085 384497 389660 401948 423128 486044 492164 501280 509784 530641 534864 535379 535396 535616 536068 539962 540054 541190 542721 552587 562529 562936 573989 575383 575615 577026 578937 589771 590606 592337 606052 611687 614215 614385 617885 618005 618071 618189 618600 619414 621168 627191 627655 627851 629774 635720 650037 666978 684055 689266 692752 692824 695670 696053 696058 696642 696664 696675 696687 696698 696716 697085 701708 702347 702360 705709 707973 709512 716582 717224 718593 720470 731147 733511 736498 741580 745074 746481 751217 751419 753999 758949 761160 768293 771514 773498 775250 775815 776359 778765 779324 779692 779820 780172 780734 780902 781438 785526 785533 788892 790647 791105 791494 791643 793050 795992 804169 809987 812225 813329 813545 814299 824888 826343 827557 828223 828244 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public russian"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц русск"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (1.03%) |
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.