Query Metrics
7
Database Queries
7
Different statements
162.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.44 ms (84.99%) |
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 561150 578592 585840 586181 594170 597544 603508 605580 606939 607785 610422 615475 616554 617344 618621 619961 620953 629596 631738 637258 640367 641064 669895 673825 685907 695911 700909 704662 704686 708020 709946 712116 715871 718461 719470 724697 724711 725028 726627 730229 733388 738219 739417 741266 741877 744175 744208 745324 746208 746562 746605 747083 747169 750771 752197 756094 756194 756699 758411 761281 761814 762020 762317 763428 764194 764776 766808 769057 769121 769130 769134 771842 772048 773354 774205 774782 777359 778222 779295 781040 782150 782536 783929 783989 784036 785788 786756 787925 788449 788482 788635 788751 789449 789976 790059 792586 793524 793780 794168 794193 794532 794754 794783 795984 796121 796584 797682 798313 799620 799668 801714 802491 802506 802553 803300 803307 804273 807008 807197 808078 ] |
||||||||||||||||||||||||||||||
|
13.37 ms (8.21%) |
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 669895 673825 685907 695911 700909 704662 704686 708020 709946 712116 715871 718461 719470 561150 578592 615475 617344 637258 603508 605580 610422 619961 620953 631738 640367 586181 607785 616554 618621 641064 585840 594170 597544 606939 629596 774782 777359 781040 782536 783989 788482 792586 793524 799620 802491 802506 804273 778222 779295 782150 784036 785788 786756 787925 788449 796121 796584 799668 801714 803307 807008 725028 730229 744175 744208 746562 746605 752197 756094 758411 761281 762317 763428 764776 769057 769130 769134 772048 783929 788635 788751 789449 789976 790059 793780 794168 794193 794532 794754 794783 795984 797682 798313 802553 803300 807197 808078 724711 738219 741266 741877 745324 750771 762020 769121 771842 773354 724697 726627 733388 739417 746208 747083 747169 756699 764194 766808 774205 756194 761814 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.87%) |
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 561150 578592 585840 586181 594170 597544 603508 605580 606939 607785 610422 615475 616554 617344 618621 619961 620953 629596 631738 637258 640367 641064 669895 673825 685907 695911 700909 704662 704686 708020 709946 712116 715871 718461 719470 724697 724711 725028 726627 730229 733388 738219 739417 741266 741877 744175 744208 745324 746208 746562 746605 747083 747169 750771 752197 756094 756194 756699 758411 761281 761814 762020 762317 763428 764194 764776 766808 769057 769121 769130 769134 771842 772048 773354 774205 774782 777359 778222 779295 781040 782150 782536 783929 783989 784036 785788 786756 787925 788449 788482 788635 788751 789449 789976 790059 792586 793524 793780 794168 794193 794532 794754 794783 795984 796121 796584 797682 798313 799620 799668 801714 802491 802506 802553 803300 803307 804273 807008 807197 808078 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"твои"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"тво"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.