Query Metrics
7
Database Queries
7
Different statements
212.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.53 ms (88.99%) |
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 383016 395803 396869 398436 406340 408532 410328 412776 414635 427540 458396 460782 477247 484245 492164 498922 504259 524648 540708 541102 541986 541996 542721 542972 543710 545078 545869 551175 554560 554734 555661 556093 557349 562054 566729 567130 567133 567891 570087 579127 580721 580984 581038 590606 609496 614849 617242 618005 618302 623236 627655 632065 637988 639525 648485 649866 661329 661353 665067 668403 673996 685525 691125 691846 692436 693174 695660 695962 696051 696432 696688 697934 705104 713145 717600 721810 721899 721956 731641 734542 734650 744011 744568 745628 745986 748126 749054 749860 755183 768770 773275 774495 778597 779820 780734 780797 782119 782133 784050 785533 789632 795732 798200 798706 798964 805228 811886 812225 812230 812238 813324 814166 820655 825558 826148 828068 828127 828133 828174 828358 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (6.00%) |
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 648485 705104 721956 668403 696051 545078 639525 782119 789632 744011 721899 813324 637988 609496 412776 498922 398436 410328 541986 541996 692436 784050 773275 396869 562054 492164 618005 542721 782133 551175 580721 570087 414635 477247 504259 785533 780797 427540 566729 826148 828174 691125 734650 542972 524648 460782 731641 778597 567133 567130 541102 632065 798200 734542 828068 811886 749054 745628 721810 695660 695962 554734 820655 828358 543710 755183 745986 825558 828127 828133 484245 545869 665067 691846 567891 661353 673996 590606 623236 780734 805228 749860 617242 779820 383016 661329 795732 406340 814166 812230 812238 744568 627655 812225 557349 540708 556093 768770 618302 580984 581038 395803 693174 649866 798706 748126 696432 696688 717600 408532 774495 554560 579127 555661 614849 458396 685525 713145 697934 798964 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (1.74%) |
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 383016 395803 396869 398436 406340 408532 410328 412776 414635 427540 458396 460782 477247 484245 492164 498922 504259 524648 540708 541102 541986 541996 542721 542972 543710 545078 545869 551175 554560 554734 555661 556093 557349 562054 566729 567130 567133 567891 570087 579127 580721 580984 581038 590606 609496 614849 617242 618005 618302 623236 627655 632065 637988 639525 648485 649866 661329 661353 665067 668403 673996 685525 691125 691846 692436 693174 695660 695962 696051 696432 696688 697934 705104 713145 717600 721810 721899 721956 731641 734542 734650 744011 744568 745628 745986 748126 749054 749860 755183 768770 773275 774495 778597 779820 780734 780797 782119 782133 784050 785533 789632 795732 798200 798706 798964 805228 811886 812225 812230 812238 813324 814166 820655 825558 826148 828068 828127 828133 828174 828358 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк на улиц вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl public car"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк на улиц вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.74%) |
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.