Query Metrics
7
Database Queries
7
Different statements
179.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.17 ms (86.55%) |
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 396601 410873 417304 449166 485611 489233 495531 495585 507434 511865 520207 521258 551665 556652 556685 570147 570156 571702 572219 587799 590612 592708 604585 605573 606022 608170 610610 613998 620673 622758 623909 624996 626083 628187 628588 642562 644102 646012 657735 659334 661920 663562 663932 667490 668753 671492 672774 677918 684693 691616 692280 693188 695080 702056 703284 703843 710091 710488 712089 713031 716082 718699 719827 720168 721946 721978 725048 725094 725096 725097 728980 734388 736120 736863 740160 740966 744892 748545 749756 757866 759474 759575 759978 761504 762766 766462 769248 770065 774597 780236 780283 782503 784917 785679 788541 788866 788892 789217 791498 792658 793718 793869 795843 796255 796464 796512 799874 799886 801373 802658 810319 814115 817887 818422 819952 820164 821809 824568 827850 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (7.94%) |
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 757837 759474 762766 748545 716082 721946 784917 788892 791498 511865 693188 719827 592708 620673 796255 725096 410873 818422 827850 495531 718699 610610 785679 796464 802658 801373 780283 396601 817887 821809 814115 819952 572219 556652 570147 659334 663562 710488 702056 703284 671492 691616 551665 556685 587799 606022 622758 626083 628187 624996 590612 628588 774597 788541 780236 799886 725048 761504 770065 792658 796512 766462 769248 749756 728980 736120 744892 613998 799874 449166 417304 507434 489233 824568 820164 485611 495585 520207 521258 570156 646012 661920 663932 667490 684693 710091 721978 668753 672774 677918 692280 703843 720168 657735 695080 712089 713031 571702 642562 605573 608170 623909 604585 644102 782503 789217 788866 793718 793869 725094 734388 740160 740966 759575 759978 795843 810319 725097 736863 757866 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.65%) |
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 396601 410873 417304 449166 485611 489233 495531 495585 507434 511865 520207 521258 551665 556652 556685 570147 570156 571702 572219 587799 590612 592708 604585 605573 606022 608170 610610 613998 620673 622758 623909 624996 626083 628187 628588 642562 644102 646012 657735 659334 661920 663562 663932 667490 668753 671492 672774 677918 684693 691616 692280 693188 695080 702056 703284 703843 710091 710488 712089 713031 716082 718699 719827 720168 721946 721978 725048 725094 725096 725097 728980 734388 736120 736863 740160 740966 744892 748545 749756 757866 759474 759575 759978 761504 762766 766462 769248 770065 774597 780236 780283 782503 784917 785679 788541 788866 788892 789217 791498 792658 793718 793869 795843 796255 796464 796512 799874 799886 801373 802658 810319 814115 817887 818422 819952 820164 821809 824568 827850 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck husband"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс husband"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс husband"
]
|
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.