Query Metrics
7
Database Queries
7
Different statements
157.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.64 ms (83.79%) |
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 423964 426739 432422 432534 436207 438987 455558 460787 468963 477399 477860 479242 480043 481201 483638 485647 494014 508590 511402 511605 516899 524363 526123 528387 528633 536024 543611 543641 545681 551447 552356 552449 552609 552853 553968 556518 557030 557405 557442 558484 560259 562743 567672 567688 567881 571413 571502 572884 573313 576751 577413 578555 579830 586741 598757 600235 609422 612942 614755 615607 619932 620396 620664 623232 624426 628455 636127 639223 639643 642084 659444 665978 667774 669515 674184 677146 680786 684637 695690 699941 701205 713038 731376 731396 732130 736442 738313 763733 764772 766120 766126 766183 766424 766447 769072 771397 772927 777639 777799 778267 778646 779303 780057 780273 780277 781633 782357 783468 786073 786732 789171 790602 790930 792326 794060 796582 804566 812566 816182 822652 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (9.03%) |
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 485647 511402 508590 556518 571413 573313 579830 567881 571502 477399 479242 432422 423964 468963 511605 494014 552609 528387 620396 426739 789171 816182 480043 576751 567672 578555 552853 558484 659444 674184 680786 695690 665978 669515 667774 677146 699941 713038 557030 560259 562743 567688 636127 615607 619932 623232 639223 639643 609422 612942 614755 620664 642084 777639 778646 792326 804566 777799 780057 783468 786073 790602 731376 763733 766120 766126 769072 771397 764772 766447 766183 766424 736442 738313 701205 778267 779303 780273 782357 786732 796582 432534 436207 455558 438987 483638 516899 822652 790930 526123 481201 524363 536024 543641 598757 628455 812566 780277 731396 732130 772927 781633 794060 600235 460787 477860 528633 543611 551447 552449 572884 545681 557442 684637 552356 553968 557405 577413 586741 624426 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.53%) |
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 423964 426739 432422 432534 436207 438987 455558 460787 468963 477399 477860 479242 480043 481201 483638 485647 494014 508590 511402 511605 516899 524363 526123 528387 528633 536024 543611 543641 545681 551447 552356 552449 552609 552853 553968 556518 557030 557405 557442 558484 560259 562743 567672 567688 567881 571413 571502 572884 573313 576751 577413 578555 579830 586741 598757 600235 609422 612942 614755 615607 619932 620396 620664 623232 624426 628455 636127 639223 639643 642084 659444 665978 667774 669515 674184 677146 680786 684637 695690 699941 701205 713038 731376 731396 732130 736442 738313 763733 764772 766120 766126 766183 766424 766447 769072 771397 772927 777639 777799 778267 778646 779303 780057 780273 780277 781633 782357 783468 786073 786732 789171 790602 790930 792326 794060 796582 804566 812566 816182 822652 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск дрочк член пов"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian handjob pov"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск дрочк член пов"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.08%) |
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.