Query Metrics
7
Database Queries
7
Different statements
771.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
539.61 ms (69.98%) |
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 25030 32874 101841 111339 122062 128784 151163 382183 382362 382543 386366 388094 390318 390811 395504 396107 396575 397519 402674 408961 409066 417825 419413 504704 521118 530008 535816 540627 544690 545461 548552 557430 558657 565557 575014 584488 586507 595975 604493 609891 624419 624828 625180 630711 635967 636326 637092 638087 639328 642412 643920 643934 645956 648512 666850 674116 681635 681637 687192 687594 693153 705683 713105 713820 717651 718931 718957 719783 719896 725058 730769 741891 741907 742171 744344 746999 748437 753281 770126 770866 774248 778312 780682 784078 785417 785679 789187 789201 791758 792561 792591 792821 795859 796558 797410 802184 805115 805303 808214 811049 814661 817078 817786 818281 818419 818768 819800 821162 821241 821506 821689 821916 822822 822878 822888 822988 822990 823305 823332 824938 ] |
||||||||||||||||||||||||||||||
|
210.05 ms (27.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс black"
]
|
||||||||||||||||||||||||||||||
|
12.84 ms (1.66%) |
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 681635 638087 784078 565557 817078 819800 821916 645956 609891 586507 625180 778312 805303 725058 770126 713105 785417 122062 151163 395504 822988 821241 821506 674116 717651 753281 741891 741907 101841 746999 748437 382362 396107 818281 535816 705683 382183 128784 805115 770866 544690 796558 792821 802184 604493 792561 32874 388094 419413 824938 817786 823332 818768 557430 639328 635967 785679 791758 795859 548552 386366 396575 397519 402674 558657 687192 718957 642412 630711 595975 624419 811049 744344 111339 821162 814661 822878 693153 643920 624828 730769 792591 636326 797410 382543 648512 687594 789201 719896 409066 666850 25030 713820 390318 545461 584488 417825 818419 822888 822990 575014 719783 643934 780682 774248 742171 789187 808214 681637 637092 408961 390811 822822 823305 821689 540627 504704 521118 530008 718931 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (0.39%) |
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 25030 32874 101841 111339 122062 128784 151163 382183 382362 382543 386366 388094 390318 390811 395504 396107 396575 397519 402674 408961 409066 417825 419413 504704 521118 530008 535816 540627 544690 545461 548552 557430 558657 565557 575014 584488 586507 595975 604493 609891 624419 624828 625180 630711 635967 636326 637092 638087 639328 642412 643920 643934 645956 648512 666850 674116 681635 681637 687192 687594 693153 705683 713105 713820 717651 718931 718957 719783 719896 725058 730769 741891 741907 742171 744344 746999 748437 753281 770126 770866 774248 778312 780682 784078 785417 785679 789187 789201 791758 792561 792591 792821 795859 796558 797410 802184 805115 805303 808214 811049 814661 817078 817786 818281 818419 818768 819800 821162 821241 821506 821689 821916 822822 822878 822888 822988 822990 823305 823332 824938 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob black"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс black"
]
|
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.