Query Metrics
7
Database Queries
7
Different statements
359.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.47 ms (59.15%) |
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 426769 541494 547992 557224 560863 564391 590840 599032 608806 612494 630230 644855 678249 678651 682179 684367 685411 687850 690652 690728 696904 701963 706174 707076 707596 707684 707882 709365 710123 712640 713830 714914 716240 716561 719452 720269 724300 724837 727695 728935 731245 734536 736502 736642 739437 739607 740298 741200 744073 745241 746304 746882 748328 749107 750519 754268 756316 757666 757744 758066 758506 760197 761765 761799 764193 764240 764383 767680 770343 770714 771079 773661 775550 777294 778417 778452 779111 779925 781412 781588 782117 783084 784166 785815 786205 787904 787988 788666 789140 789149 789411 790942 791047 791843 793396 794448 795791 796894 797064 797820 798869 799863 800642 800943 802515 802856 804547 806240 809969 811117 811479 812470 812881 813495 813703 817020 817343 819378 819868 827589 ] |
||||||||||||||||||||||||||||||
|
125.97 ms (35.07%) |
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 426769 541494 547992 557224 560863 564391 590840 599032 608806 612494 630230 644855 678249 678651 682179 684367 685411 687850 690652 690728 696904 701963 706174 707076 707596 707684 707882 709365 710123 712640 713830 714914 716240 716561 719452 720269 724300 724837 727695 728935 731245 734536 736502 736642 739437 739607 740298 741200 744073 745241 746304 746882 748328 749107 750519 754268 756316 757666 757744 758066 758506 760197 761765 761799 764193 764240 764383 767680 770343 770714 771079 773661 775550 777294 778417 778452 779111 779925 781412 781588 782117 783084 784166 785815 786205 787904 787988 788666 789140 789149 789411 790942 791047 791843 793396 794448 795791 796894 797064 797820 798869 799863 800642 800943 802515 802856 804547 806240 809969 811117 811479 812470 812881 813495 813703 817020 817343 819378 819868 827589 ] |
||||||||||||||||||||||||||||||
|
14.13 ms (3.93%) |
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 770343 817343 547992 564391 690652 678651 684367 612494 630230 779111 788666 779925 791047 795791 802856 782117 787988 797820 812470 728935 724300 727695 739437 740298 749107 758066 707684 716561 778452 785815 809969 817020 819378 819868 682179 719452 690728 720269 557224 590840 777294 781588 787904 790942 802515 811479 789140 789149 796894 811117 734536 739607 746304 760197 761799 783084 784166 799863 804547 813495 748328 757744 731245 741200 761765 707882 709365 775550 791843 800943 812881 426769 644855 827589 813703 560863 541494 706174 713830 716240 678249 696904 707596 714914 685411 687850 701963 707076 710123 712640 608806 599032 778417 786205 794448 797064 800642 806240 744073 745241 754268 770714 781412 789411 793396 798869 724837 757666 773661 736502 758506 764240 764383 767680 771079 736642 746882 764193 750519 756316 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepsister sex"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepsister секс"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepsister секс"
]
|
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.