Query Metrics
7
Database Queries
7
Different statements
176.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.80 ms (85.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 14599 382769 383103 384223 384327 385357 390214 391246 392032 395742 398604 406022 406125 406488 420426 421598 422231 427425 431228 434573 456188 459371 459823 460936 470334 476582 476956 478765 487019 491595 496510 512004 515862 523044 524206 549508 553239 564650 573795 579342 586452 586784 593116 595540 600058 605380 605850 608426 618919 620737 631109 635144 646244 649226 650098 650118 650230 651126 653270 657066 657758 663332 673125 673860 675396 682388 683797 683877 685823 694468 703560 703656 709837 712421 715228 715920 716804 724556 725110 730672 731893 733911 739411 741193 742833 743079 746519 746802 746958 753525 758528 758557 763748 765130 767177 772759 773580 779894 782057 783630 788590 789924 791091 791413 799095 799862 799980 802752 802765 809125 810247 812145 812436 815131 816503 819372 825465 826309 827299 ] |
||||||||||||||||||||||||||||||
|
15.23 ms (8.64%) |
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 384327 434573 712421 703656 810247 765130 392032 456188 586784 816503 631109 459371 385357 819372 815131 650118 683877 779894 783630 709837 791091 812436 382769 651126 646244 725110 384223 573795 791413 390214 427425 746519 600058 741193 586452 825465 663332 782057 758557 406488 673125 675396 683797 595540 785992 739411 802752 753525 763748 657066 799980 579342 470334 733911 653270 742833 746802 487019 703560 772759 635144 731893 398604 421598 420426 827299 496510 553239 476956 14599 406022 657758 694468 620737 431228 383103 459823 491595 673860 391246 406125 476582 799095 478765 802765 395742 523044 809125 799862 422231 512004 650230 715228 682388 758528 743079 715920 460936 767177 605850 716804 826309 788590 789924 618919 812145 730672 773580 724556 650098 593116 605380 524206 564650 649226 515862 608426 746958 549508 685823 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.74 ms (1.55%) |
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 14599 382769 383103 384223 384327 385357 390214 391246 392032 395742 398604 406022 406125 406488 420426 421598 422231 427425 431228 434573 456188 459371 459823 460936 470334 476582 476956 478765 487019 491595 496510 512004 515862 523044 524206 549508 553239 564650 573795 579342 586452 586784 593116 595540 600058 605380 605850 608426 618919 620737 631109 635144 646244 649226 650098 650118 650230 651126 653270 657066 657758 663332 673125 673860 675396 682388 683797 683877 685823 694468 703560 703656 709837 712421 715228 715920 716804 724556 725110 730672 731893 733911 739411 741193 742833 743079 746519 746802 746958 753525 758528 758557 763748 765130 767177 772759 773580 779894 782057 783630 788590 789924 791091 791413 799095 799862 799980 802752 802765 809125 810247 812145 812436 815131 816503 819372 825465 826309 827299 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute girl blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.84%) |
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.