Query Metrics
7
Database Queries
7
Different statements
225.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.77 ms (86.85%) |
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 389700 392607 421654 425829 433681 433721 434003 442372 442652 446299 448722 448968 449897 450654 450771 454084 457943 458907 463094 463826 464561 465608 466709 469366 469660 471699 472544 472658 475677 478828 485077 486540 489325 491525 497881 509983 510774 511422 514279 519063 519215 519937 520405 521287 521381 522851 523907 524530 525156 526096 526170 526838 527452 528088 528119 529341 529952 531510 532273 535486 535878 537307 538695 539121 539147 541158 541467 543144 549101 564562 567051 568377 569019 569041 570822 571666 577119 580300 592541 593144 593340 595323 596115 603351 604465 605581 605999 606618 618960 619495 633171 683237 694203 695613 751515 754081 757353 759840 769575 776433 776790 785184 785186 790696 791090 794612 798365 799503 799802 803017 803171 805112 815117 815269 816292 816376 817131 818208 820462 827080 ] |
||||||||||||||||||||||||||||||
|
18.50 ms (8.21%) |
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 472658 478828 449897 469660 471699 511422 526170 519063 497881 514279 522851 527452 790696 433721 817131 827080 815269 463826 450654 469366 448968 526096 538695 539121 510774 525156 532273 535878 541158 568377 569019 570822 577119 694203 695613 549101 564562 571666 606618 633171 596115 603351 605581 593144 593340 595323 618960 619495 776790 798365 799802 805112 776433 794612 799503 754081 757353 785184 785186 803017 803171 759840 769575 751515 605999 791090 392607 519937 521381 537307 524530 683237 567051 592541 389700 425829 421654 458907 509983 526838 486540 464561 580300 442652 434003 475677 535486 539147 528088 472544 491525 569041 543144 604465 454084 463094 465608 519215 523907 528119 529341 489325 521287 541467 520405 529952 531510 442372 433681 816292 815117 816376 818208 820462 446299 448722 450771 457943 485077 466709 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (1.60%) |
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 389700 392607 421654 425829 433681 433721 434003 442372 442652 446299 448722 448968 449897 450654 450771 454084 457943 458907 463094 463826 464561 465608 466709 469366 469660 471699 472544 472658 475677 478828 485077 486540 489325 491525 497881 509983 510774 511422 514279 519063 519215 519937 520405 521287 521381 522851 523907 524530 525156 526096 526170 526838 527452 528088 528119 529341 529952 531510 532273 535486 535878 537307 538695 539121 539147 541158 541467 543144 549101 564562 567051 568377 569019 569041 570822 571666 577119 580300 592541 593144 593340 595323 596115 603351 604465 605581 605999 606618 618960 619495 633171 683237 694203 695613 751515 754081 757353 759840 769575 776433 776790 785184 785186 790696 791090 794612 798365 799503 799802 803017 803171 805112 815117 815269 816292 816376 817131 818208 820462 827080 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf mom compilation"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf mom подборк"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf mom подборк"
]
|
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.