Query Metrics
7
Database Queries
7
Different statements
162.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.95 ms (85.32%) |
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 181315 393423 395731 398811 409374 421155 425360 460724 466710 486540 507916 532112 542344 544255 551717 565741 592490 605157 644253 644287 653722 667889 680878 684233 693210 695270 710609 715524 719876 721155 724244 727738 729884 730825 734452 734639 736487 738593 746673 751491 752809 753247 755461 757379 759471 761245 765462 770819 770949 771000 772808 775401 775640 777205 778847 781171 783242 784595 788865 789358 789725 797023 797608 799597 800557 800871 800887 802377 802384 802395 803015 803264 804287 805809 806174 806478 807394 808615 810462 811214 813672 814941 815180 815223 815309 815366 815408 815588 815750 815805 815912 815933 815965 816001 816020 816063 816394 816766 816772 816802 817255 817366 817912 817942 817945 818197 818212 818487 820005 820160 820334 820685 821520 821665 822278 822297 822988 823621 823693 823932 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (8.31%) |
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 817366 542344 565741 592490 727738 734452 797023 181315 393423 425360 815180 816766 817942 818487 820334 822278 822297 823932 814941 816063 816772 817945 823693 815223 815750 816020 818212 820005 820685 821520 822988 815933 818197 821665 460724 532112 551717 715524 721155 680878 684233 695270 710609 653722 667889 719876 644253 644287 775401 777205 789358 789725 803264 805809 811214 781171 783242 803015 729884 751491 757379 759471 784595 800871 765462 736487 746673 753247 752809 761245 724244 771000 788865 799597 802384 806478 395731 804287 486540 813672 398811 409374 815408 605157 800887 806174 807394 778847 802377 770819 816394 544255 734639 421155 507916 815805 817912 693210 816802 820160 816001 823621 815309 815588 815912 817255 815366 815965 466710 797608 802395 775640 800557 808615 755461 810462 738593 770949 730825 772808 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.91%) |
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 181315 393423 395731 398811 409374 421155 425360 460724 466710 486540 507916 532112 542344 544255 551717 565741 592490 605157 644253 644287 653722 667889 680878 684233 693210 695270 710609 715524 719876 721155 724244 727738 729884 730825 734452 734639 736487 738593 746673 751491 752809 753247 755461 757379 759471 761245 765462 770819 770949 771000 772808 775401 775640 777205 778847 781171 783242 784595 788865 789358 789725 797023 797608 799597 800557 800871 800887 802377 802384 802395 803015 803264 804287 805809 806174 806478 807394 808615 810462 811214 813672 814941 815180 815223 815309 815366 815408 815588 815750 815805 815912 815933 815965 816001 816020 816063 816394 816766 816772 816802 817255 817366 817912 817942 817945 818197 818212 818487 820005 820160 820334 820685 821520 821665 822278 822297 822988 823621 823693 823932 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom fuck ass"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom секс жоп"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom секс жоп"
]
|
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.