Query Metrics
7
Database Queries
7
Different statements
152.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.87 ms (84.26%) |
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 191715 382278 383539 414329 418772 425474 427470 433995 444631 446508 448177 449735 451551 454292 456196 464581 464611 465991 466452 467096 467174 483350 486939 488706 490815 494665 516866 519115 521917 523136 523653 523939 540796 541162 545051 549933 551185 551210 551565 554199 555773 558943 559090 564320 565402 565429 568307 569519 571129 572448 572521 572587 572650 572727 573386 575392 576662 577118 577142 577968 578217 580649 581053 581760 587163 587573 589365 589783 598248 599500 609759 613161 614725 631214 635456 635480 637591 643706 644213 644888 649470 649915 650919 681712 681714 689804 691026 691980 693026 697284 719327 726214 726434 728102 732084 734146 743165 743446 744280 747941 752500 757207 759992 760227 764046 767329 769901 780370 789109 790549 794019 797595 800122 801364 806684 807301 810347 811053 811992 813043 ] |
||||||||||||||||||||||||||||||
|
13.82 ms (9.04%) |
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 691026 693026 697284 719327 551210 554199 577118 581760 589365 587163 637591 780370 794019 801364 789109 743165 759992 760227 726214 728102 764046 732084 743446 767329 490815 467096 572587 451551 418772 425474 446508 551565 565429 609759 614725 807301 456196 464581 448177 465991 521917 523939 382278 540796 466452 580649 577968 681712 649470 573386 797595 449735 589783 464611 613161 433995 427470 644888 486939 541162 581053 575392 635480 757207 414329 488706 568307 483350 444631 519115 523653 516866 467174 572727 577142 691980 650919 649915 631214 644213 587573 598248 599500 635456 790549 800122 734146 810347 811992 744280 752500 769901 726434 747941 806684 811053 813043 523136 494665 643706 565402 383539 191715 454292 564320 572521 545051 572448 576662 551185 555773 558943 569519 572650 681714 689804 549933 559090 571129 578217 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.78%) |
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 191715 382278 383539 414329 418772 425474 427470 433995 444631 446508 448177 449735 451551 454292 456196 464581 464611 465991 466452 467096 467174 483350 486939 488706 490815 494665 516866 519115 521917 523136 523653 523939 540796 541162 545051 549933 551185 551210 551565 554199 555773 558943 559090 564320 565402 565429 568307 569519 571129 572448 572521 572587 572650 572727 573386 575392 576662 577118 577142 577968 578217 580649 581053 581760 587163 587573 589365 589783 598248 599500 609759 613161 614725 631214 635456 635480 637591 643706 644213 644888 649470 649915 650919 681712 681714 689804 691026 691980 693026 697284 719327 726214 726434 728102 732084 734146 743165 743446 744280 747941 752500 757207 759992 760227 764046 767329 769901 780370 789109 790549 794019 797595 800122 801364 806684 807301 810347 811053 811992 813043 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower на woman улиц"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower public woman"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower на woman улиц"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.