Query Metrics
7
Database Queries
7
Different statements
147.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.63 ms (82.42%) |
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 520976 540075 540113 540121 540140 540143 540148 540174 540675 541184 541741 541803 542083 542180 542443 542450 542460 542728 545940 547406 553663 554709 554733 554734 555275 555301 555410 555436 555745 556246 558910 558948 558956 561044 563977 568612 574369 575868 577010 578718 584987 590350 591680 602215 605080 605248 606230 607714 610012 612056 619204 630519 632282 632635 632638 634375 634381 635519 637442 640739 640749 640861 643656 646760 647844 649107 649707 650742 658865 661591 661974 665975 666087 666096 666453 666914 669538 671864 677783 678131 678502 679863 680120 680121 680188 680192 690200 690215 692042 709855 709874 709884 714594 716870 728465 729186 734126 740238 743996 744011 749025 752667 754477 758235 758797 780884 788887 790112 795006 804418 804424 810526 812230 812245 814165 814224 819807 824918 827191 828593 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (9.62%) |
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 754477 734126 819807 540140 540148 690215 666087 605080 630519 605248 790112 812245 758235 632282 678131 637442 640739 632635 540121 540174 542460 555275 555745 646760 558948 635519 640861 804424 795006 584987 542728 553663 555410 541741 541803 542083 545940 577010 661591 671864 680192 647844 680120 692042 680121 574369 640749 607714 610012 619204 643656 810526 758797 728465 752667 612056 788887 824918 814165 827191 814224 828593 540075 540113 540675 542443 555436 575868 541184 556246 561044 568612 542180 542450 554734 558910 563977 666096 666453 666914 649107 649707 669538 690200 709884 714594 547406 554709 555301 590350 606230 634375 634381 804418 812230 744011 729186 740238 743996 749025 709855 780884 677783 591680 602215 520976 540143 554733 558956 578718 650742 658865 661974 709874 716870 665975 678502 679863 680188 632638 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.34%) |
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 520976 540075 540113 540121 540140 540143 540148 540174 540675 541184 541741 541803 542083 542180 542443 542450 542460 542728 545940 547406 553663 554709 554733 554734 555275 555301 555410 555436 555745 556246 558910 558948 558956 561044 563977 568612 574369 575868 577010 578718 584987 590350 591680 602215 605080 605248 606230 607714 610012 612056 619204 630519 632282 632635 632638 634375 634381 635519 637442 640739 640749 640861 643656 646760 647844 649107 649707 650742 658865 661591 661974 665975 666087 666096 666453 666914 669538 671864 677783 678131 678502 679863 680120 680121 680188 680192 690200 690215 692042 709855 709874 709884 714594 716870 728465 729186 734126 740238 743996 744011 749025 752667 754477 758235 758797 780884 788887 790112 795006 804418 804424 810526 812230 812245 814165 814224 819807 824918 827191 828593 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"моч"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.