Query Metrics
7
Database Queries
7
Different statements
148.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.08 ms (82.65%) |
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 291314 394590 438181 444064 454104 455616 469668 522248 533091 533229 539797 540808 546158 549065 553422 553619 557223 557585 560369 580802 583652 584849 587301 588118 596389 596884 597279 598095 600912 602831 605060 621769 631728 640302 642807 645365 658193 659219 666855 680723 681508 685125 689531 699267 703318 709490 709660 709823 712116 716180 718087 718130 718337 724063 725301 727548 730297 730750 731458 733387 735145 736678 736985 738468 739042 741186 744158 744369 745087 748653 753105 755843 756846 757181 757274 760598 761335 761757 762317 762659 765560 770681 775218 776606 777767 777838 780359 781181 785506 785745 786017 786636 786679 787483 789524 790605 792419 792618 793780 793914 794439 794869 795247 795721 796326 798457 800181 800908 801513 803654 804000 804146 806762 807432 809010 813206 824838 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (9.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 777767 787483 793914 795721 803654 809010 454104 533091 680723 681508 709823 712116 553422 642807 602831 605060 596884 469668 560369 598095 621769 792419 540808 775218 824838 455616 522248 539797 716180 583652 587301 600912 781181 795247 800908 777838 780359 789524 733387 757274 785745 755843 762659 770681 727548 736678 744369 757181 765560 744158 730297 753105 761335 762017 718337 804000 807432 444064 557223 394590 291314 580802 546158 699267 718087 794869 796326 804146 786636 794439 741186 756846 762317 786017 790605 793780 800181 735145 738468 761757 703318 533229 584849 549065 645365 658193 689531 709490 596389 640302 597279 730750 785506 557585 659219 685125 631728 438181 666855 718130 553619 588118 776606 786679 806762 798457 801513 724063 725301 739042 748653 760598 772018 792618 813206 736985 745087 731458 771893 709660 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.87%) |
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 291314 394590 438181 444064 454104 455616 469668 522248 533091 533229 539797 540808 546158 549065 553422 553619 557223 557585 560369 580802 583652 584849 587301 588118 596389 596884 597279 598095 600912 602831 605060 621769 631728 640302 642807 645365 658193 659219 666855 680723 681508 685125 689531 699267 703318 709490 709660 709823 712116 716180 718087 718130 718337 724063 725301 727548 730297 730750 731458 733387 735145 736678 736985 738468 739042 741186 744158 744369 745087 748653 753105 755843 756846 757181 757274 760598 761335 761757 762317 762659 765560 770681 775218 776606 777767 777838 780359 781181 785506 785745 786017 786636 786679 787483 789524 790605 792419 792618 793780 793914 794439 794869 795247 795721 796326 798457 800181 800908 801513 803654 804000 804146 806762 807432 809010 813206 824838 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск ride"
]
|
||||||||||||||||||||||||||||||
|
2.45 ms (1.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade ride"
]
|
||||||||||||||||||||||||||||||
|
2.26 ms (1.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск ride"
]
|
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.