Query Metrics
7
Database Queries
7
Different statements
398.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.79 ms (54.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс тикток социальн сет"
]
|
||||||||||||||||||||||||||||||
|
160.72 ms (40.33%) |
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 418380 419185 444577 498760 529674 537487 558182 640346 694789 715242 717101 721112 723794 723917 726281 728123 728700 730190 730884 733520 733662 737235 745169 745172 745189 745197 745542 746072 746375 747802 747937 748783 750893 751418 752013 752029 752057 754871 759021 759350 760400 760497 762363 764388 764845 765159 765284 765373 765706 765957 765967 766778 767059 768171 769160 769389 772517 773721 775127 777006 778419 778507 778658 778670 782384 782388 782781 784062 785175 785204 785513 785517 785718 785820 787209 787911 788970 789370 790119 790148 790395 790689 790924 792190 792315 793856 795408 796372 797610 797750 799647 799885 803209 805727 806929 811752 813155 814411 814455 816148 816172 817644 821769 821803 821814 823900 824135 825108 825460 825705 825862 827213 827317 828016 828229 828290 828333 828403 ] |
||||||||||||||||||||||||||||||
|
12.92 ms (3.24%) |
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 795408 797750 813155 747937 765159 745542 737235 775127 787209 799647 814455 814411 782384 785517 790148 787911 760400 765284 733520 784062 785513 797610 529674 828016 799885 745172 778507 694789 640346 796372 785820 790689 769160 772517 785175 785204 762363 723917 728123 748783 765373 766778 751418 752029 759350 778419 778670 785718 805727 806929 823900 821803 816172 828290 828403 811752 726281 792315 537487 816148 827213 825108 782781 803209 793856 728700 730190 773721 765957 768171 745197 760497 715242 789370 558182 792190 777006 782388 790924 745169 750893 765706 721112 778658 717101 759021 788970 765967 769389 418380 444577 419185 498760 821814 821769 827317 817644 824135 828229 790119 754871 764845 752057 764910 730401 733662 747802 825862 746375 767059 730884 825460 825705 828333 790395 723794 764388 745189 752013 746072 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (0.73%) |
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 418380 419185 444577 498760 529674 537487 558182 640346 694789 715242 717101 721112 723794 723917 726281 728123 728700 730190 730884 733520 733662 737235 745169 745172 745189 745197 745542 746072 746375 747802 747937 748783 750893 751418 752013 752029 752057 754871 759021 759350 760400 760497 762363 764388 764845 765159 765284 765373 765706 765957 765967 766778 767059 768171 769160 769389 772517 773721 775127 777006 778419 778507 778658 778670 782384 782388 782781 784062 785175 785204 785513 785517 785718 785820 787209 787911 788970 789370 790119 790148 790395 790689 790924 792190 792315 793856 795408 796372 797610 797750 799647 799885 803209 805727 806929 811752 813155 814411 814455 816148 816172 817644 821769 821803 821814 823900 824135 825108 825460 825705 825862 827213 827317 828016 828229 828290 828333 828403 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex tik tok"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.49%) |
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.