Query Metrics
7
Database Queries
7
Different statements
178.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.61 ms (86.26%) |
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 428530 456729 487852 544009 567779 567798 587719 604505 611152 713872 716403 718933 722317 723228 724054 724916 725205 725754 729339 732543 734998 736938 737224 738051 743149 744460 745527 748093 749686 749964 751636 751786 752836 753916 753939 757183 757191 757932 762315 765285 765348 767011 767939 768061 768355 774067 775211 776115 778423 778434 778460 778514 778636 780867 783301 783327 784984 786344 787275 788778 789770 789857 789863 790049 791376 791386 791450 791696 791972 793375 794249 795434 796944 797203 799201 799798 802258 803207 803992 804182 805412 806075 806720 806730 812875 813487 816721 816725 817395 818108 824668 825524 825703 825724 825744 825746 825776 826399 826511 826514 826609 826617 826657 826989 828010 828205 828212 828217 828350 828357 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (7.62%) |
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 825375 826311 828239 487852 544009 604505 825958 825703 825776 825524 825724 826399 826617 828205 828357 725754 826511 826514 826609 816721 825746 817395 713872 716403 722317 587719 776115 778636 791386 791450 796944 799201 802258 804182 778460 788778 789770 793375 803992 813487 753916 753939 757191 762315 774027 783327 784984 787275 789857 790049 797203 744460 749686 749964 757932 767939 724054 765348 767011 768355 737224 751636 751786 752836 724916 732543 734998 736938 757183 765285 774067 718933 775211 778434 791696 806730 456729 818108 824599 826657 825744 824820 828010 828344 828212 828350 803207 748093 725205 567779 567798 428530 745527 768061 816725 826989 828217 824668 723228 611152 778514 790453 791376 795434 799798 806720 812875 778423 780867 783301 786344 789863 791972 791973 794249 805412 806075 729339 738051 743149 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (1.98%) |
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 428530 456729 487852 544009 567779 567798 587719 604505 611152 713872 716403 718933 722317 723228 724054 724916 725205 725754 729339 732543 734998 736938 737224 738051 743149 744460 745527 748093 749686 749964 751636 751786 752836 753916 753939 757183 757191 757932 762315 765285 765348 767011 767939 768061 768355 774067 775211 776115 778423 778434 778460 778514 778636 780867 783301 783327 784984 786344 787275 788778 789770 789857 789863 790049 791376 791386 791450 791696 791972 793375 794249 795434 796944 797203 799201 799798 802258 803207 803992 804182 805412 806075 806720 806730 812875 813487 816721 816725 817395 818108 824668 825524 825703 825724 825744 825746 825776 826399 826511 826514 826609 826617 826657 826989 828010 828205 828212 828217 828350 828357 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tiktok порно"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тикток социальн сет порн"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.93%) |
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.