Query Metrics
7
Database Queries
7
Different statements
154.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.83 ms (86.13%) |
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 377993 378272 397738 417553 419628 427263 427267 427981 448089 454319 466553 474748 494575 495559 527218 537151 538016 552459 555963 558127 560889 578166 584779 592400 597910 603612 612162 615382 617136 624204 624207 637080 637901 675461 678017 683094 700915 724748 727459 727475 728924 729013 729262 730803 733217 733259 733271 733293 734283 734342 734360 740070 741577 746376 747431 747474 750729 751178 772355 772360 777113 777204 778285 781962 785607 786880 790817 792348 793830 793837 793839 793841 795236 796307 796466 796480 801164 801922 802716 803599 804949 807458 808021 808290 812116 814727 814903 816397 819338 819439 819823 820022 820141 820154 820687 823175 823539 823598 823689 823754 823860 824077 824085 824497 824509 824598 824645 825126 825260 826383 826409 826410 826620 826642 826651 826739 827377 827403 ] |
||||||||||||||||||||||||||||||
|
11.86 ms (7.69%) |
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 495559 427981 814903 584779 552459 637080 527218 474748 615382 419628 427263 617136 558127 826383 790817 819419 823754 824645 819338 824077 796307 730803 826651 823860 734342 772360 728924 824598 801164 727459 427267 417553 827377 792348 734360 733271 494575 747431 786880 808021 624207 823689 823598 803599 823175 824085 816397 751178 826739 700915 793837 741577 747474 827403 820687 624204 820022 560889 795236 734283 802716 750729 733217 448089 466553 828594 740070 793841 808290 820154 824509 825260 675461 796480 801922 781962 804949 733259 733293 807458 820141 826620 537151 578166 678017 597910 377993 826410 825126 603612 826642 814727 778285 793830 793839 555963 785607 454319 378272 823539 819823 683094 612162 592400 777113 796466 812116 729013 729262 727475 637901 777204 397738 824497 826409 819439 538016 772355 724748 746376 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.81%) |
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 377993 378272 397738 417553 419628 427263 427267 427981 448089 454319 466553 474748 494575 495559 527218 537151 538016 552459 555963 558127 560889 578166 584779 592400 597910 603612 612162 615382 617136 624204 624207 637080 637901 675461 678017 683094 700915 724748 727459 727475 728924 729013 729262 730803 733217 733259 733271 733293 734283 734342 734360 740070 741577 746376 747431 747474 750729 751178 772355 772360 777113 777204 778285 781962 785607 786880 790817 792348 793830 793837 793839 793841 795236 796307 796466 796480 801164 801922 802716 803599 804949 807458 808021 808290 812116 814727 814903 816397 819338 819439 819823 820022 820141 820154 820687 823175 823539 823598 823689 823754 823860 824077 824085 824497 824509 824598 824645 825126 825260 826383 826409 826410 826620 826642 826651 826739 827377 827403 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass to pussy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп pussy"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп pussy"
]
|
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.