Query Metrics
7
Database Queries
7
Different statements
348.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.45 ms (61.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
111.74 ms (32.10%) |
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 712120 718445 729482 729853 730405 732232 732510 732936 732952 733260 733617 734179 734592 735069 735230 735439 735735 739662 739711 741144 741513 742705 742815 743488 743511 743569 743700 744024 744345 744523 746184 746195 746919 747225 747232 748850 749747 750150 751950 752025 752259 753128 754177 754729 757264 757844 759024 759222 759244 761937 762211 762387 762631 762845 763215 763807 763831 763938 764550 764911 765631 765980 766125 766451 766906 766962 768627 769215 769651 770052 771233 778284 778443 778489 779225 780861 782336 782815 784872 786092 786262 787262 788732 788733 789501 789576 790266 794764 794948 795097 797078 797475 798692 805244 816174 818312 819364 819755 819885 821790 821805 824246 824739 824907 825330 825372 825374 825408 825520 826699 826717 826899 827199 827277 827503 ] |
||||||||||||||||||||||||||||||
|
11.94 ms (3.43%) |
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 739662 748850 752025 751950 754177 763807 797475 729482 763831 797078 778284 789576 786092 819364 816174 819755 819885 821805 825983 826699 825520 826717 818312 821790 825408 827199 827277 827503 825372 825374 824739 824907 825330 825336 824246 826899 718445 712120 778443 784872 786262 788732 794764 794948 798692 805244 778489 779225 780861 782336 782815 788733 790266 795097 729853 733260 733617 734179 734592 741144 742815 744345 746184 749747 757264 759024 762631 766451 769215 787262 789501 730405 732232 739711 741513 743488 744523 759244 761937 762211 768627 732936 732952 734751 735230 735439 735735 743511 746195 747225 747232 750150 753128 763938 764550 770052 771233 744024 752259 757844 759222 762387 762845 763215 764465 765980 766906 766962 769651 732510 735069 742705 743569 743700 746919 754729 763261 764911 765631 766125 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (0.84%) |
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 712120 718445 729482 729853 730405 732232 732510 732936 732952 733260 733617 734179 734592 735069 735230 735439 735735 739662 739711 741144 741513 742705 742815 743488 743511 743569 743700 744024 744345 744523 746184 746195 746919 747225 747232 748850 749747 750150 751950 752025 752259 753128 754177 754729 757264 757844 759024 759222 759244 761937 762211 762387 762631 762845 763215 763807 763831 763938 764550 764911 765631 765980 766125 766451 766906 766962 768627 769215 769651 770052 771233 778284 778443 778489 779225 780861 782336 782815 784872 786092 786262 787262 788732 788733 789501 789576 790266 794764 794948 795097 797078 797475 798692 805244 816174 818312 819364 819755 819885 821790 821805 824246 824739 824907 825330 825372 825374 825408 825520 826699 826717 826899 827199 827277 827503 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tiktok homemade"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.43%) |
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.