Query Metrics
7
Database Queries
7
Different statements
157.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.91 ms (86.44%) |
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 469285 529981 531013 541994 544106 615906 678672 717249 718086 718603 718897 721899 721902 723645 725078 727071 728375 729367 729848 730021 731497 731608 733636 733676 737012 738050 739093 739374 739381 739730 741138 741377 744949 746728 746864 747267 748094 749045 750574 750957 751052 752074 752747 754729 754981 755175 757186 757193 757197 760340 760388 762040 762048 762161 762385 763020 763824 764803 764835 764911 765505 765608 766125 766243 768975 769622 769628 769691 770529 773144 777257 777771 778236 778253 778389 778400 778432 778439 778596 778764 780693 782035 782858 782886 783289 784321 785045 785518 786804 787644 788417 788615 789568 789576 790166 790273 791225 802920 804148 805060 805065 806605 807024 807026 814187 814434 816145 818570 821781 821785 823902 824119 824871 825335 825855 826497 826510 827440 827501 828587 ] |
||||||||||||||||||||||||||||||
|
11.07 ms (7.04%) |
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 748094 754729 763824 764911 766125 766243 768975 769622 769691 717249 718086 718603 721899 721902 778236 778432 778596 782035 789568 790273 541994 824871 828587 531013 544106 782886 784321 807024 782858 788417 749045 757186 760340 791225 731608 754981 762385 770529 733636 739381 747267 762161 764803 733676 783289 807026 824119 826510 821781 827440 821785 529981 718897 678672 615906 777771 778764 780693 787644 790166 778389 778439 786804 805060 725078 729367 729848 741377 746864 750574 750957 752074 760388 789576 802920 804148 806605 739730 755175 764835 752747 762040 762048 773144 730021 737012 739093 739374 746728 763020 765505 769628 741138 744949 751052 757193 757197 778253 785045 788615 805065 778400 785518 777257 765608 727071 738050 728375 731497 469285 814434 723645 826497 825855 825335 818570 823902 827501 814187 816145 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (2.31%) |
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 469285 529981 531013 541994 544106 615906 678672 717249 718086 718603 718897 721899 721902 723645 725078 727071 728375 729367 729848 730021 731497 731608 733636 733676 737012 738050 739093 739374 739381 739730 741138 741377 744949 746728 746864 747267 748094 749045 750574 750957 751052 752074 752747 754729 754981 755175 757186 757193 757197 760340 760388 762040 762048 762161 762385 763020 763824 764803 764835 764911 765505 765608 766125 766243 768975 769622 769628 769691 770529 773144 777257 777771 778236 778253 778389 778400 778432 778439 778596 778764 780693 782035 782858 782886 783289 784321 785045 785518 786804 787644 788417 788615 789568 789576 790166 790273 791225 802920 804148 805060 805065 806605 807024 807026 814187 814434 816145 818570 821781 821785 823902 824119 824871 825335 825855 826497 826510 827440 827501 828587 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тикток девушки"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет девушк"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"тикток социальн сет девушк"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
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.