Query Metrics
7
Database Queries
7
Different statements
149.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.91 ms (83.34%) |
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 3561 145280 387667 391371 391915 397997 398965 401790 415762 416038 427112 429879 445787 446772 446776 465595 465672 465990 466863 469770 471015 474847 475639 478027 484277 488989 493734 510948 515472 522702 525355 527122 527258 528560 532885 542707 542982 547520 550451 552036 553876 554712 555175 557720 558174 558314 558315 570938 571050 575008 578169 578196 584072 586950 587567 590720 591013 592690 592945 592975 592985 595975 596792 601071 602347 611210 614797 614865 623276 628751 629815 630453 632949 637245 641337 660397 664498 664504 667463 668628 674279 674493 700947 705452 715965 719504 722294 728047 736041 736339 736410 740368 742324 743212 743241 744183 744215 751030 752495 752584 752914 753772 754647 758583 781792 783350 785042 785817 786723 795933 803490 804391 804456 812548 817964 818561 819244 821964 824868 827100 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (9.83%) |
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 740368 743241 751030 736041 804391 145280 664504 550451 558314 3561 387667 397997 824868 475639 446772 446776 465595 664498 398965 786723 465672 752584 752495 728047 674279 601071 578196 522702 465990 474847 510948 528560 532885 488989 558174 558315 552036 668628 591013 592975 586950 592690 614865 587567 592945 596792 781792 614797 525355 527258 557720 592985 637245 629815 416038 391915 401790 471015 571050 445787 527122 466863 578169 391371 429879 427112 484277 493734 542707 478027 590720 415762 818561 611210 817964 821964 827100 819244 515472 469770 575008 542982 547520 553876 570938 660397 667463 674493 700947 715965 719504 705452 722294 554712 555175 584072 628751 632949 623276 630453 641337 595975 785817 795933 803490 736410 744183 744215 752914 758583 783350 785042 804456 812548 742324 753772 736339 743212 754647 602347 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.95%) |
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 3561 145280 387667 391371 391915 397997 398965 401790 415762 416038 427112 429879 445787 446772 446776 465595 465672 465990 466863 469770 471015 474847 475639 478027 484277 488989 493734 510948 515472 522702 525355 527122 527258 528560 532885 542707 542982 547520 550451 552036 553876 554712 555175 557720 558174 558314 558315 570938 571050 575008 578169 578196 584072 586950 587567 590720 591013 592690 592945 592975 592985 595975 596792 601071 602347 611210 614797 614865 623276 628751 629815 630453 632949 637245 641337 660397 664498 664504 667463 668628 674279 674493 700947 705452 715965 719504 722294 728047 736041 736339 736410 740368 742324 743212 743241 744183 744215 751030 752495 752584 752914 753772 754647 758583 781792 783350 785042 785817 786723 795933 803490 804391 804456 812548 817964 818561 819244 821964 824868 827100 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy ass solo"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая жоп соло"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.