Query Metrics
7
Database Queries
7
Different statements
176.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.08 ms (85.07%) |
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 280631 382180 390150 391527 397869 397986 406935 407423 412330 416000 419619 421257 421827 425508 427364 430397 442132 443257 454384 455460 455979 458768 464031 475296 475422 479148 482309 487008 491107 509436 512079 514356 522159 523884 525315 526499 526584 533190 541836 541850 545989 549654 552473 554407 556952 563777 565644 567062 569309 574685 577122 578323 581203 582440 583540 602846 605096 610031 610643 613780 617524 618507 632230 635201 644870 649242 653068 666160 671876 697457 714354 715419 724470 728466 728469 728536 728616 729802 734265 735906 741504 741687 741699 741733 741764 744180 744416 749234 749248 750568 753060 758793 758803 760169 770120 772725 781832 781859 781861 794190 800723 800745 802914 804241 807882 808143 808155 812382 813791 825267 825858 826127 826829 826832 827295 827296 827392 827397 827498 827722 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (8.89%) |
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 724470 741733 758793 741699 728469 735906 749248 455460 479148 454384 421257 509436 812382 770120 382180 407423 583540 390150 397986 794190 397869 827392 827498 772725 728466 728616 617524 632230 715419 749234 802914 464031 458768 574685 578323 602846 416000 455979 613780 427364 644870 825858 744180 800723 430397 541836 581203 549654 545989 808155 741504 750568 605096 280631 425508 475422 522159 482309 552473 582440 577122 781861 391527 442132 826829 827722 649242 443257 526584 512079 554407 666160 671876 618507 781859 808143 491107 475296 526499 514356 487008 541850 567062 697457 758803 760169 741687 741764 525315 825267 826832 827295 827296 827397 813791 826127 533190 565644 556952 653068 714354 563777 610643 781832 800745 807882 753060 734265 412330 419619 523884 406935 421827 610031 635201 729802 804241 744416 728536 569309 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.82%) |
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 280631 382180 390150 391527 397869 397986 406935 407423 412330 416000 419619 421257 421827 425508 427364 430397 442132 443257 454384 455460 455979 458768 464031 475296 475422 479148 482309 487008 491107 509436 512079 514356 522159 523884 525315 526499 526584 533190 541836 541850 545989 549654 552473 554407 556952 563777 565644 567062 569309 574685 577122 578323 581203 582440 583540 602846 605096 610031 610643 613780 617524 618507 632230 635201 644870 649242 653068 666160 671876 697457 714354 715419 724470 728466 728469 728536 728616 729802 734265 735906 741504 741687 741699 741733 741764 744180 744416 749234 749248 750568 753060 758793 758803 760169 770120 772725 781832 781859 781861 794190 800723 800745 802914 804241 807882 808143 808155 812382 813791 825267 825858 826127 826829 826832 827295 827296 827392 827397 827498 827722 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby big dildo"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby большие дилд"
]
|
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.