Query Metrics
7
Database Queries
7
Different statements
690.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
270.27 ms (39.16%) |
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 551995 537671 575140 548666 550763 720480 498212 517012 701498 722821 647964 544676 604508 593850 628364 410930 96048 403162 405054 416820 445679 447247 478779 487742 451963 468046 516319 533011 475848 551936 582012 561815 566383 600256 601559 609682 793376 423267 436040 479523 417897 470791 491911 538190 451263 435624 445728 531239 540408 537196 527900 536787 540053 512215 536292 543609 569687 575455 542591 551184 556421 565390 545719 570073 646920 650333 720237 679821 687262 569672 598699 621650 624223 637047 593359 628114 636274 640773 589345 619410 636273 640806 742143 700294 714500 775819 373852 396358 464703 475911 475975 405093 409995 444720 454736 478781 484716 491915 511744 512261 512265 495612 500764 491369 421327 425489 427467 435664 445626 467583 467561 478457 448097 474766 550613 560616 562037 576416 581738 550432 ] |
||||||||||||||||||||||||||||||
|
207.81 ms (30.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny mmf"
]
|
||||||||||||||||||||||||||||||
|
203.60 ms (29.50%) |
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 96048 373852 396358 403162 405054 405093 409995 410930 416820 417897 421327 423267 425489 427467 435624 435664 436040 444720 445626 445679 445728 447247 448097 451263 451963 454736 464703 467561 467583 468046 470791 474766 475848 475911 475975 478457 478779 478781 479523 484716 487742 491369 491911 491915 495612 498212 500764 511744 512215 512261 512265 516319 517012 527900 531239 533011 536292 536787 537196 537671 538190 540053 540408 542591 543609 544676 545719 548666 550432 550613 550763 551184 551936 551995 556421 560616 561815 562037 565390 566383 569672 569687 570073 575140 575455 576416 581738 582012 589345 593359 593850 598699 600256 601559 604508 609682 619410 621650 624223 628114 628364 636273 636274 637047 640773 640806 646920 647964 650333 679821 687262 700294 701498 714500 720237 720480 722821 742143 775819 793376 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (0.53%) |
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 96048 373852 396358 403162 405054 405093 409995 410930 416820 417897 421327 423267 425489 427467 435624 435664 436040 444720 445626 445679 445728 447247 448097 451263 451963 454736 464703 467561 467583 468046 470791 474766 475848 475911 475975 478457 478779 478781 479523 484716 487742 491369 491911 491915 495612 498212 500764 511744 512215 512261 512265 516319 517012 527900 531239 533011 536292 536787 537196 537671 538190 540053 540408 542591 543609 544676 545719 548666 550432 550613 550763 551184 551936 551995 556421 560616 561815 562037 565390 566383 569672 569687 570073 575140 575455 576416 581738 582012 589345 593359 593850 598699 600256 601559 604508 609682 619410 621650 624223 628114 628364 636273 636274 637047 640773 640806 646920 647964 650333 679821 687262 700294 701498 714500 720237 720480 722821 742143 775819 793376 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.21%) |
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.