Query Metrics
7
Database Queries
7
Different statements
161.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.54 ms (85.54%) |
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 6919 34697 44998 78994 95640 95788 96819 96952 167756 177159 382697 386194 387601 388821 391897 393673 396261 396709 410128 414690 417486 418265 431744 453855 470533 476838 489616 491367 504170 523044 533689 534078 535726 535789 538564 538814 540089 543654 545585 559212 562588 563387 575695 589808 593890 604760 606535 608427 622116 640909 643927 644303 644894 646240 649837 649947 650642 650815 650852 651003 653603 653628 653634 656677 657571 663977 666841 692463 697494 699441 699531 699779 702058 703070 705663 710212 712887 713635 716829 720467 720950 721405 723582 724111 726799 733179 749269 749639 758298 758599 759910 761506 766568 770823 770840 773947 775899 775904 776528 784331 787575 789708 789892 789961 793441 793472 807512 807617 809941 810668 811931 814946 815723 816015 817341 818932 819311 820953 824342 825122 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (8.30%) |
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 644303 810668 431744 504170 491367 177159 391897 824342 644894 535789 540089 523044 535726 563387 575695 657571 699441 649837 650642 692463 697494 640909 589808 784331 758599 773947 643927 809941 382697 386194 78994 410128 417486 538564 534078 470533 543654 720467 721405 604760 593890 789892 793472 807617 770823 720950 793441 6919 387601 453855 95640 723582 825122 545585 702058 651003 807512 726799 724111 705663 811931 489616 44998 608427 414690 713635 393673 95788 396709 817341 819311 814946 818932 533689 538814 559212 562588 646240 649947 650815 653634 650852 653628 663977 699531 699779 653603 656677 666841 710212 712887 716829 606535 622116 775904 789708 775899 749639 758298 759910 766568 787575 749269 733179 761506 770840 703070 776528 789961 96819 476838 388821 96952 167756 34697 396261 418265 815723 820953 816015 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (2.29%) |
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 6919 34697 44998 78994 95640 95788 96819 96952 167756 177159 382697 386194 387601 388821 391897 393673 396261 396709 410128 414690 417486 418265 431744 453855 470533 476838 489616 491367 504170 523044 533689 534078 535726 535789 538564 538814 540089 543654 545585 559212 562588 563387 575695 589808 593890 604760 606535 608427 622116 640909 643927 644303 644894 646240 649837 649947 650642 650815 650852 651003 653603 653628 653634 656677 657571 663977 666841 692463 697494 699441 699531 699779 702058 703070 705663 710212 712887 713635 716829 720467 720950 721405 723582 724111 726799 733179 749269 749639 758298 758599 759910 761506 766568 770823 770840 773947 775899 775904 776528 784331 787575 789708 789892 789961 793441 793472 807512 807617 809941 810668 811931 814946 815723 816015 817341 818932 819311 820953 824342 825122 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mmf blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.83%) |
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.