Query Metrics
7
Database Queries
7
Different statements
142.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.71 ms (83.37%) |
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 424193 475140 480415 516140 536923 543882 545365 545451 545790 546121 546950 547483 547801 549836 551923 555065 557546 557969 559049 559286 561803 563419 563892 566998 567110 568052 572268 573311 575302 575338 575533 576125 578400 578412 580319 580345 586372 586407 587418 590396 591643 591664 592681 595735 596084 596125 598194 598253 599906 601548 603187 603327 603586 604519 605455 606880 607185 607218 607667 613432 619091 629658 629886 632681 643043 649136 650485 666719 666869 668537 669884 671737 681257 691201 692711 699729 705663 756230 756491 759967 760667 761736 763739 770149 770663 770901 776731 777577 781792 782653 783312 785530 785877 786454 787047 787272 788119 788790 789526 789647 792550 793340 798598 799093 800307 801348 801917 801953 801957 802029 807599 807711 809415 810983 811007 812565 812824 812885 813084 814681 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (9.91%) |
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 557969 559049 559286 561803 567110 575533 543882 546121 547483 547801 551923 563419 566998 575302 578412 580319 580345 545451 545790 557546 563892 578400 649136 650485 666719 666869 671737 681257 691201 699729 668537 669884 692711 545365 546950 549836 555065 568052 572268 573311 575338 576125 595735 599906 607185 607218 619091 586372 591664 592681 596084 598194 604519 607667 591643 596125 598253 603187 603327 603586 605455 629658 629886 632681 586407 587418 590396 601548 606880 643043 777577 781792 782653 785530 800307 801348 807599 807711 813084 776731 787047 788790 793340 798598 801957 809415 812565 760667 761736 783312 785877 786454 788119 789526 792550 799093 801917 801953 810983 812885 770901 756230 756491 770149 759967 763739 770663 613432 705663 787272 789647 802029 811007 812824 424193 475140 480415 536923 516140 814681 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (2.01%) |
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 424193 475140 480415 516140 536923 543882 545365 545451 545790 546121 546950 547483 547801 549836 551923 555065 557546 557969 559049 559286 561803 563419 563892 566998 567110 568052 572268 573311 575302 575338 575533 576125 578400 578412 580319 580345 586372 586407 587418 590396 591643 591664 592681 595735 596084 596125 598194 598253 599906 601548 603187 603327 603586 604519 605455 606880 607185 607218 607667 613432 619091 629658 629886 632681 643043 649136 650485 666719 666869 668537 669884 671737 681257 691201 692711 699729 705663 756230 756491 759967 760667 761736 763739 770149 770663 770901 776731 777577 781792 782653 783312 785530 785877 786454 787047 787272 788119 788790 789526 789647 792550 793340 798598 799093 800307 801348 801917 801953 801957 802029 807599 807711 809415 810983 811007 812565 812824 812885 813084 814681 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape mom"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк mom"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк 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.