Query Metrics
7
Database Queries
7
Different statements
182.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.01 ms (87.26%) |
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 33715 323581 389838 398759 402084 482606 487587 511593 514348 514875 529679 534873 545973 549292 552331 559920 562276 563628 573312 577281 580044 585192 591794 591914 592976 594268 594419 594537 619134 621296 624939 626116 626969 627054 627482 628744 631784 635002 635604 642666 648487 650588 653084 671901 680534 680654 690711 690721 695367 695413 695415 698733 707439 710255 713734 714931 720089 726749 727762 734408 738851 740064 740713 740757 740911 742626 743783 745467 746385 747480 754300 754607 754845 755287 760592 760776 761253 761366 772037 778697 780977 782809 784135 784214 784543 785730 786905 787535 789144 789162 790179 794111 797045 800063 801110 801460 803185 804911 806098 806524 808250 809607 810796 814098 814920 815726 818096 819274 819696 820501 821266 821359 821964 823930 824252 824409 825957 828470 828690 828730 ] |
||||||||||||||||||||||||||||||
|
12.88 ms (7.07%) |
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 552331 653084 785730 585192 398759 591794 828690 828730 828470 642666 823930 619134 819274 738851 707439 671901 627482 754845 743783 824252 545973 778697 789162 789144 740064 761253 754300 760592 824409 690721 323581 514348 626116 591914 809607 742626 746385 814098 815726 573312 695367 628744 626969 635002 786905 787535 790179 772037 794111 804911 808250 726749 727762 825957 529679 690711 631784 803185 806098 549292 734408 487587 695413 740713 745467 797045 33715 402084 821964 818096 821266 559920 648487 680534 580044 592976 635604 627054 780977 806524 740911 754607 784135 760776 621296 784214 784543 801110 761366 800063 624939 810796 482606 680654 698733 714931 801460 747480 740757 562276 755287 577281 389838 819696 814920 820501 821359 511593 534873 514875 563628 650588 713734 695415 710255 720089 594419 594537 594268 782809 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.90%) |
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 33715 323581 389838 398759 402084 482606 487587 511593 514348 514875 529679 534873 545973 549292 552331 559920 562276 563628 573312 577281 580044 585192 591794 591914 592976 594268 594419 594537 619134 621296 624939 626116 626969 627054 627482 628744 631784 635002 635604 642666 648487 650588 653084 671901 680534 680654 690711 690721 695367 695413 695415 698733 707439 710255 713734 714931 720089 726749 727762 734408 738851 740064 740713 740757 740911 742626 743783 745467 746385 747480 754300 754607 754845 755287 760592 760776 761253 761366 772037 778697 780977 782809 784135 784214 784543 785730 786905 787535 789144 789162 790179 794111 797045 800063 801110 801460 803185 804911 806098 806524 808250 809607 810796 814098 814920 815726 818096 819274 819696 820501 821266 821359 821964 823930 824252 824409 825957 828470 828690 828730 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"juicy ass"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"juicy жоп"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"juicy жоп"
]
|
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.