Query Metrics
7
Database Queries
7
Different statements
166.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.20 ms (85.23%) |
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 397780 400226 401935 412907 425935 448180 455801 461123 465543 469503 476971 506548 521447 522561 523044 524648 527339 530397 530651 530664 533700 533711 533712 535371 535407 536082 539751 539752 539962 540705 543559 545798 561511 563408 564860 565382 575615 581028 588596 589799 595086 608151 611687 618189 618600 621230 622022 625750 627191 627896 628772 629774 632086 633664 638502 644850 647200 648572 651648 666014 683570 684055 689868 690410 695670 695671 696044 696053 696058 696698 696701 707973 709452 709517 711320 713951 716582 720470 721755 722993 726049 734377 734386 736498 736514 746481 750345 752765 757557 768598 770164 771406 777327 780210 781930 783535 785526 789112 791105 791497 791643 794489 798964 799010 799017 799822 802816 802927 809767 810757 813802 821525 824277 828039 828158 828171 828425 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (8.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 822935 530664 789112 768598 799010 539752 539751 533712 536082 530651 533700 535371 535407 648572 647200 799822 780210 757557 581028 589799 628772 770164 711320 781930 783535 828425 828039 561511 689868 734377 632086 813802 469503 709517 563408 802816 726049 527339 543559 565382 611687 618189 785526 455801 465543 709452 651648 627896 771406 425935 690410 564860 476971 810757 794489 397780 448180 696044 799017 750345 695671 644850 530397 540705 533711 523044 798964 791497 736514 621230 696701 777327 401935 824277 828158 506548 545798 734386 809767 752765 461123 400226 232085 746481 683570 721755 521447 821525 608151 713951 802927 588596 828171 828054 622022 638502 666014 595086 412907 524648 522561 539962 575615 684055 696053 696058 696698 722993 695670 707973 716582 720470 633664 625750 618600 627191 629774 791105 791643 736498 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.61%) |
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 397780 400226 401935 412907 425935 448180 455801 461123 465543 469503 476971 506548 521447 522561 523044 524648 527339 530397 530651 530664 533700 533711 533712 535371 535407 536082 539751 539752 539962 540705 543559 545798 561511 563408 564860 565382 575615 581028 588596 589799 595086 608151 611687 618189 618600 621230 622022 625750 627191 627896 628772 629774 632086 633664 638502 644850 647200 648572 651648 666014 683570 684055 689868 690410 695670 695671 696044 696053 696058 696698 696701 707973 709452 709517 711320 713951 716582 720470 721755 722993 726049 734377 734386 736498 736514 746481 750345 752765 757557 768598 770164 771406 777327 780210 781930 783535 785526 789112 791105 791497 791643 794489 798964 799010 799017 799822 802816 802927 809767 810757 813802 821525 824277 828039 828158 828171 828425 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public agen big"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на agen улиц большие"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на agen улиц большие"
]
|
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.