Query Metrics
7
Database Queries
7
Different statements
170.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.86 ms (86.30%) |
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 214238 225633 389782 395803 401844 402138 407538 415928 418707 469715 472329 480826 498880 500114 516468 518309 524618 537306 539086 540782 541517 543452 546829 549439 551197 552379 552711 555967 557606 570764 572075 576326 580903 583277 588811 589717 592966 595964 598191 599406 623656 624480 631762 634279 637608 639632 644101 646270 665128 665271 665287 681187 682515 682763 688146 692744 698246 706550 707981 710536 712829 714007 718741 726582 726860 727633 732901 734349 738010 740798 741225 741437 743027 743188 745146 746038 752918 752919 753621 753702 756895 758268 759590 765942 766766 768286 770146 770754 776503 781017 785221 785924 786811 788480 789304 791804 792768 795956 798981 800480 800661 802255 802641 804296 806958 812236 813598 815660 815726 816844 816855 817853 817872 819096 819117 820364 820534 820982 821531 828398 ] |
||||||||||||||||||||||||||||||
|
13.26 ms (7.79%) |
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 753621 746038 634279 812236 472329 469715 516468 572075 552379 557606 623656 785924 518309 225633 815660 816844 816855 817853 817872 540782 819096 819117 820534 820982 815726 820364 821531 828398 480826 583277 543452 580903 698246 718741 549439 592966 644101 639632 589717 595964 781017 788480 789304 798981 785221 800480 734349 741225 768286 743188 753702 732901 743027 752919 756895 766766 637608 786811 791804 795956 214238 402138 389782 401844 598191 551197 692744 712829 706550 804296 740798 765942 726860 745146 792768 537306 500114 555967 541517 395803 624480 646270 682515 665128 665271 776503 800661 741437 770754 726582 759590 727633 552711 599406 570764 813598 539086 546829 665287 682763 710536 681187 688146 714007 707981 588811 631762 802255 770146 806958 752918 738010 802641 576326 407538 418707 524618 758268 415928 498880 ] |
||||||||||||||||||||||||||||||
|
2.80 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 214238 225633 389782 395803 401844 402138 407538 415928 418707 469715 472329 480826 498880 500114 516468 518309 524618 537306 539086 540782 541517 543452 546829 549439 551197 552379 552711 555967 557606 570764 572075 576326 580903 583277 588811 589717 592966 595964 598191 599406 623656 624480 631762 634279 637608 639632 644101 646270 665128 665271 665287 681187 682515 682763 688146 692744 698246 706550 707981 710536 712829 714007 718741 726582 726860 727633 732901 734349 738010 740798 741225 741437 743027 743188 745146 746038 752918 752919 753621 753702 756895 758268 759590 765942 766766 768286 770146 770754 776503 781017 785221 785924 786811 788480 789304 791804 792768 795956 798981 800480 800661 802255 802641 804296 806958 812236 813598 815660 815726 816844 816855 817853 817872 819096 819117 820364 820534 820982 821531 828398 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy in public"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy на улиц"
]
|
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.