Query Metrics
7
Database Queries
7
Different statements
219.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.14 ms (88.01%) |
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 992 7665 28591 75664 114631 192943 221923 269876 282481 383202 389376 393384 399585 400143 400169 401180 402717 402977 404042 404831 413199 419176 429814 435645 443680 445575 447928 453852 458600 470548 490068 494339 497568 506786 510427 511011 514942 515881 520619 522532 522568 523305 530540 538858 538997 541082 549416 549757 557945 562255 566451 571609 575515 579077 583688 584087 586635 593358 600001 603240 618882 622121 622343 623512 624850 630380 630497 640939 641852 643998 644237 649146 652172 652897 653527 654471 654491 656638 657293 661099 666769 670689 680871 694143 703391 706602 717313 719142 720481 720834 721443 721842 722262 722860 722871 723608 724528 740797 743380 747259 748741 756088 757350 770799 770891 771282 775137 775998 797799 798083 798693 810685 816272 817434 817692 818351 819212 820340 820523 820690 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (7.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 719142 389376 652897 400143 400169 435645 511011 652172 586635 797799 383202 603240 640939 722871 522568 538858 549757 654471 661099 643998 623512 453852 429814 269876 654491 657293 706602 520619 514942 541082 445575 703391 618882 584087 820523 817692 649146 694143 720834 770891 771282 770799 798083 7665 28591 557945 510427 515881 583688 680871 656638 549416 775998 740797 221923 419176 530540 717313 622121 798693 506786 593358 747259 819212 743380 756088 443680 75664 402717 523305 522532 470548 644237 490068 562255 992 413199 721443 641852 600001 494339 404042 630497 757350 666769 399585 816272 817434 566451 575515 571609 670689 720481 721842 624850 722860 775137 401180 393384 810685 724528 447928 114631 538997 723608 820690 820340 622343 402977 192943 404831 722262 282481 497568 630380 818351 579077 653527 458600 748741 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.57%) |
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 992 7665 28591 75664 114631 192943 221923 269876 282481 383202 389376 393384 399585 400143 400169 401180 402717 402977 404042 404831 413199 419176 429814 435645 443680 445575 447928 453852 458600 470548 490068 494339 497568 506786 510427 511011 514942 515881 520619 522532 522568 523305 530540 538858 538997 541082 549416 549757 557945 562255 566451 571609 575515 579077 583688 584087 586635 593358 600001 603240 618882 622121 622343 623512 624850 630380 630497 640939 641852 643998 644237 649146 652172 652897 653527 654471 654491 656638 657293 661099 666769 670689 680871 694143 703391 706602 717313 719142 720481 720834 721443 721842 722262 722860 722871 723608 724528 740797 743380 747259 748741 756088 757350 770799 770891 771282 775137 775998 797799 798083 798693 810685 816272 817434 817692 818351 819212 820340 820523 820690 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome fuck girls"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро секс девушк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.76%) |
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.