Query Metrics
7
Database Queries
7
Different statements
202.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.63 ms (86.34%) |
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 415109 417955 421234 426805 427435 429098 447208 456384 456524 456743 467476 467498 467507 467508 470141 470774 473923 478524 482516 483159 484331 486665 491784 491786 494081 497230 508565 509560 512176 512538 513573 516122 518430 519390 522161 523190 524717 526912 527611 529728 530269 530763 531106 531114 531583 533613 533950 534219 536676 541206 542026 547620 559142 561352 576547 587254 590241 598263 599595 600669 603493 609901 616996 620232 623265 623656 624109 624195 626928 627730 630729 651901 660249 676095 676205 680137 680172 692967 716652 716724 716736 718582 719651 719829 722677 726302 739584 749187 751702 755264 763454 764467 764562 767141 771750 783749 785723 787111 789763 793114 793383 794949 794981 794983 795005 804307 806862 806864 809811 816995 817077 817102 817145 817758 817760 819552 824921 825219 827892 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (8.71%) |
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 531106 427435 530269 542026 447208 491784 482516 467476 467498 533950 467507 456384 421234 513573 624195 497230 473923 534219 415109 470774 491786 518430 519390 559142 467508 547620 526912 627730 739584 516122 533613 512538 523190 512176 536676 530763 508565 527611 494081 486665 576547 598263 484331 624109 620232 603493 749187 600669 616996 429098 787111 794981 794983 651901 806862 755264 789763 795005 817760 764467 718582 771750 726302 630729 804307 767141 676205 716652 722677 817758 716724 609901 793383 783749 751702 483159 806864 785723 509560 531114 716736 561352 794949 764562 719651 817102 819552 680137 470141 531583 456524 825219 426805 541206 824921 660249 680172 809811 793114 529728 817145 719829 590241 623656 599595 522161 816995 573272 623265 478524 692967 456743 626928 763454 524717 817077 417955 827892 587254 676095 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.38%) |
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 415109 417955 421234 426805 427435 429098 447208 456384 456524 456743 467476 467498 467507 467508 470141 470774 473923 478524 482516 483159 484331 486665 491784 491786 494081 497230 508565 509560 512176 512538 513573 516122 518430 519390 522161 523190 524717 526912 527611 529728 530269 530763 531106 531114 531583 533613 533950 534219 536676 541206 542026 547620 559142 561352 576547 587254 590241 598263 599595 600669 603493 609901 616996 620232 623265 623656 624109 624195 626928 627730 630729 651901 660249 676095 676205 680137 680172 692967 716652 716724 716736 718582 719651 719829 722677 726302 739584 749187 751702 755264 763454 764467 764562 767141 771750 783749 785723 787111 789763 793114 793383 794949 794981 794983 795005 804307 806862 806864 809811 816995 817077 817102 817145 817758 817760 819552 824921 825219 827892 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep throat gag"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.78%) |
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.