Query Metrics
7
Database Queries
7
Different statements
184.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.92 ms (86.85%) |
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 25650 45799 61313 102334 111260 116623 153249 187418 191117 213598 269287 352187 382321 382671 383109 385855 388284 388726 391956 396043 396349 397633 428064 446900 455530 466902 483642 487753 493195 496324 506274 511083 519344 522503 530122 531801 531858 533317 534624 535744 539660 543135 543152 543282 544239 554848 556757 561511 564298 577266 584177 590544 599809 602050 616675 625887 631865 635615 642276 695367 695393 703942 712690 712691 713432 714539 715444 715605 721890 725196 725201 725481 729000 729294 729297 731095 731800 733526 738396 738420 739484 740230 740239 740878 742780 745865 748495 749592 753029 757176 765877 766608 774076 780672 794842 794854 795046 803875 806309 818761 823446 823739 824088 824259 824350 824415 824707 824743 824763 825070 825071 825164 825166 825268 826217 826691 826712 826891 827408 828799 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (8.20%) |
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 511083 45799 388726 396349 446900 487753 635615 455530 483642 506274 519344 493195 116623 213598 391956 352187 25650 61313 396043 397633 428064 823739 824088 826217 826691 818761 824707 824743 825268 826891 827408 823446 824763 825071 825164 825166 824259 824350 824415 825070 826712 828799 466902 530122 531801 496324 539660 522503 531858 533317 534624 535744 544239 561511 584177 543135 543282 543152 556757 564298 577266 695393 712691 695367 713432 712690 715444 715605 721890 554848 599809 631865 642276 590544 616675 625887 794854 795046 806309 725201 749592 774076 794842 803875 725196 725481 729294 731095 731800 740230 745865 748495 765877 729297 733526 738420 740239 738396 739484 740878 742780 729000 753029 757176 766608 602050 703942 714539 780672 382321 382671 269287 388284 385855 383109 153249 187418 191117 102334 111260 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.44%) |
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 25650 45799 61313 102334 111260 116623 153249 187418 191117 213598 269287 352187 382321 382671 383109 385855 388284 388726 391956 396043 396349 397633 428064 446900 455530 466902 483642 487753 493195 496324 506274 511083 519344 522503 530122 531801 531858 533317 534624 535744 539660 543135 543152 543282 544239 554848 556757 561511 564298 577266 584177 590544 599809 602050 616675 625887 631865 635615 642276 695367 695393 703942 712690 712691 713432 714539 715444 715605 721890 725196 725201 725481 729000 729294 729297 731095 731800 733526 738396 738420 739484 740230 740239 740878 742780 745865 748495 749592 753029 757176 765877 766608 774076 780672 794842 794854 795046 803875 806309 818761 823446 823739 824088 824259 824350 824415 824707 824743 824763 825070 825071 825164 825166 825268 826217 826691 826712 826891 827408 828799 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy chubby"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак chubby"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак chubby"
]
|
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.