Query Metrics
7
Database Queries
7
Different statements
155.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.13 ms (83.88%) |
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 382326 389923 390389 391959 402649 414157 414929 418718 419246 419293 420742 428174 429608 430103 434336 434376 438543 439150 441049 441069 443845 445945 446786 448570 457992 460208 463782 464971 465468 466402 466630 467873 467893 468678 469124 469691 471007 471128 471646 473453 473723 479106 482839 484065 500288 505805 510280 510906 521800 522171 523358 531804 535277 537472 543061 546059 555306 555343 559787 561967 562532 569233 576128 578149 580103 583390 584337 585898 588236 589150 591013 591578 594975 596983 602189 618329 628698 629047 630470 632683 634080 637258 640088 643201 656893 660807 661034 661051 664376 664987 677740 680806 680809 681515 707556 714365 727283 728469 750553 750618 752667 753023 758806 768791 778863 784409 787265 794097 798762 803404 803491 807415 807432 808016 808166 808987 811597 811736 812549 816815 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (10.29%) |
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 787265 768791 727283 634080 535277 583390 630470 390389 429608 445945 473453 576128 559787 468678 460208 531804 465468 569233 578149 584337 707556 580103 628698 808166 811736 753023 752667 728469 438543 467873 521800 479106 428174 784409 664376 591578 500288 523358 382326 463782 434336 510280 389923 660807 591013 643201 446786 441069 443845 457992 505805 510906 537472 473723 561967 546059 555343 555306 664987 562532 589150 602189 391959 471646 419293 522171 482839 816815 661051 681515 656893 680806 680809 677740 585898 588236 632683 637258 618329 596983 778863 798762 807415 803404 750618 803491 808987 812549 758806 750553 640088 714365 794097 807432 808016 811597 418718 661034 543061 629047 466630 471007 466402 441049 464971 471128 484065 594975 467893 402649 448570 419246 414157 414929 434376 469691 430103 439150 420742 469124 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.56%) |
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 382326 389923 390389 391959 402649 414157 414929 418718 419246 419293 420742 428174 429608 430103 434336 434376 438543 439150 441049 441069 443845 445945 446786 448570 457992 460208 463782 464971 465468 466402 466630 467873 467893 468678 469124 469691 471007 471128 471646 473453 473723 479106 482839 484065 500288 505805 510280 510906 521800 522171 523358 531804 535277 537472 543061 546059 555306 555343 559787 561967 562532 569233 576128 578149 580103 583390 584337 585898 588236 589150 591013 591578 594975 596983 602189 618329 628698 629047 630470 632683 634080 637258 640088 643201 656893 660807 661034 661051 664376 664987 677740 680806 680809 681515 707556 714365 727283 728469 750553 750618 752667 753023 758806 768791 778863 784409 787265 794097 798762 803404 803491 807415 807432 808016 808166 808987 811597 811736 812549 816815 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo dildo hairy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло дилд волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.90%) |
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.