Query Metrics
7
Database Queries
7
Different statements
207.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.51 ms (88.63%) |
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 89328 407856 419222 419904 423749 423829 425028 428045 434779 434846 435433 437462 438377 442867 455227 455519 460854 464125 464888 468445 469728 470985 472145 472636 473431 491707 492517 493480 494178 499776 504326 504536 511784 518614 519325 520011 520576 525109 525632 527182 528005 528208 528261 530330 530366 542763 548087 549134 549888 554513 558177 566189 572961 582444 591073 594207 611905 615613 622638 627585 632282 660356 660905 661906 665330 668610 671078 678011 679309 682229 687225 701390 708838 712791 716660 728005 733400 734243 735971 738513 742333 745559 753821 754238 754586 754593 759093 760208 767301 772386 772500 772769 773635 777341 778951 782338 782856 785217 788738 789232 802916 803580 810631 811871 812110 817186 817408 817651 821115 824027 824984 825845 827128 827240 828113 828119 828313 ] |
||||||||||||||||||||||||||||||
|
13.88 ms (6.70%) |
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 469728 464125 716660 803580 434846 472636 472145 492517 494178 468445 566189 572961 442867 525109 828119 530366 407856 419904 428045 419222 504536 528261 491707 528005 499776 823699 530330 701390 425028 525632 549134 558177 582444 434779 437462 493480 511784 615613 591073 594207 455519 473431 423749 460854 527182 733400 622638 817408 824566 627585 785217 825845 828113 668610 687225 554513 423829 435433 520011 504326 519325 549888 660905 679309 759093 817651 665330 789232 520576 528208 518614 802916 738513 734243 470985 455227 438377 464888 812110 811871 754238 767301 821115 772386 745559 772769 773635 611905 708838 728005 817186 548087 542763 671078 782338 772500 754586 782856 810631 89328 824027 828313 827128 660356 661906 682229 712791 778951 754593 742333 753821 760208 632282 777341 678011 788738 735971 824794 827240 824984 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.47%) |
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 89328 407856 419222 419904 423749 423829 425028 428045 434779 434846 435433 437462 438377 442867 455227 455519 460854 464125 464888 468445 469728 470985 472145 472636 473431 491707 492517 493480 494178 499776 504326 504536 511784 518614 519325 520011 520576 525109 525632 527182 528005 528208 528261 530330 530366 542763 548087 549134 549888 554513 558177 566189 572961 582444 591073 594207 611905 615613 622638 627585 632282 660356 660905 661906 665330 668610 671078 678011 679309 682229 687225 701390 708838 712791 716660 728005 733400 734243 735971 738513 742333 745559 753821 754238 754586 754593 759093 760208 767301 772386 772500 772769 773635 777341 778951 782338 782856 785217 788738 789232 802916 803580 810631 811871 812110 817186 817408 817651 821115 824027 824984 825845 827128 827240 828113 828119 828313 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"очкастая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"glasses girl"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.70%) |
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.