Query Metrics
7
Database Queries
7
Different statements
150.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.53 ms (82.78%) |
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 413898 417888 420220 420685 425020 429232 429791 430320 430428 438715 441258 445699 446460 448095 449000 450652 452527 453606 455527 455653 459459 461772 470729 472451 489616 490018 492103 492583 495987 496971 497567 499233 499362 499502 501829 502082 516915 518321 520009 522008 522817 523264 526123 526158 528389 529471 534707 538405 542105 542567 542994 546627 547877 548668 549401 549802 551273 552471 557170 558606 559219 560434 561056 562716 564067 568892 570084 570266 570311 571254 578939 581692 586482 596267 596996 599929 622613 654473 654771 655624 657370 659280 660910 665404 667138 668849 670414 680112 702601 717904 722181 724593 725380 729867 730582 744564 773090 779623 781219 783191 783734 785444 787409 791032 792694 807101 809231 814139 817616 819174 819531 819951 824051 825246 825307 828152 828854 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (10.55%) |
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 596996 449000 825307 783734 561056 526123 470729 828854 828152 654771 430428 413898 570084 425020 420685 438715 546627 489616 548668 558606 586482 453606 446460 523264 448095 445699 559219 717904 599929 785444 495987 502082 542105 516915 496971 538405 452527 660910 655624 722181 557170 670414 668849 667138 549401 578939 783191 744564 729867 773090 725380 779623 809231 501829 497567 441258 472451 552471 562716 518321 522817 492103 499233 499362 571254 564067 596267 455527 430320 499502 526158 522008 560434 417888 680112 490018 429791 455653 542994 702601 781219 819174 826039 779967 819531 825246 807101 787409 542567 657370 549802 461772 814139 568892 570311 547877 528389 534707 551273 659280 581692 570266 492583 529471 450652 622613 824051 654473 459459 520009 665404 420220 429232 819951 817616 822676 791032 730582 724593 792694 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.86%) |
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 413898 417888 420220 420685 425020 429232 429791 430320 430428 438715 441258 445699 446460 448095 449000 450652 452527 453606 455527 455653 459459 461772 470729 472451 489616 490018 492103 492583 495987 496971 497567 499233 499362 499502 501829 502082 516915 518321 520009 522008 522817 523264 526123 526158 528389 529471 534707 538405 542105 542567 542994 546627 547877 548668 549401 549802 551273 552471 557170 558606 559219 560434 561056 562716 564067 568892 570084 570266 570311 571254 578939 581692 586482 596267 596996 599929 622613 654473 654771 655624 657370 659280 660910 665404 667138 668849 670414 680112 702601 717904 722181 724593 725380 729867 730582 744564 773090 779623 781219 783191 783734 785444 787409 791032 792694 807101 809231 814139 817616 819174 819531 819951 824051 825246 825307 828152 828854 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худая дрочит минет"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая дрочк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.04%) |
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.