Query Metrics
7
Database Queries
7
Different statements
186.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.24 ms (85.69%) |
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 182185 383952 386156 389479 391915 391994 397685 398097 408885 410962 414137 416683 416722 416731 417601 419619 420774 423763 429859 438207 445216 450077 450518 450969 458359 462848 463435 467097 468949 469221 473213 485472 487281 489331 495481 502789 510729 511240 511857 511869 519722 520491 520495 521238 521831 523406 527677 528775 535295 535963 536641 542422 547801 550952 556445 561909 561952 562222 567063 567245 568075 577520 579649 582582 585229 592621 592662 600031 601862 602846 607560 613515 614968 614979 617473 620323 625633 627446 631728 636732 638671 638885 640312 640353 642165 647383 656801 659219 669583 680816 681242 709838 714294 739810 741186 744028 751285 758318 760319 767731 777752 780195 780266 784681 786017 790629 791026 792148 796673 796996 803632 803931 806495 806826 806904 807170 812493 825864 828725 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (8.63%) |
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 585229 592621 602846 614968 520491 528775 419619 613515 744028 523406 458359 182185 567245 659219 647383 656801 631728 640312 617473 642165 669583 751285 520495 601862 638885 408885 450969 468949 536641 485472 567063 577520 620323 760319 627446 467097 416683 416722 521238 489331 782835 389479 511240 469221 410962 414137 511857 681242 386156 429859 582582 825864 391915 398097 714294 600031 640353 790629 792148 777752 780266 796673 796996 807170 741186 786017 812493 767731 758318 709838 780195 791026 803632 803931 806495 806826 806904 445216 397685 562222 680816 638671 592662 739810 561952 420774 450518 542422 547801 561909 568075 556445 636732 784681 607560 450077 438207 495481 416731 487281 462848 473213 502789 511869 519722 550952 579649 614979 625633 391994 423763 463435 510729 828725 383952 521831 417601 535295 527677 535963 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.84%) |
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 182185 383952 386156 389479 391915 391994 397685 398097 408885 410962 414137 416683 416722 416731 417601 419619 420774 423763 429859 438207 445216 450077 450518 450969 458359 462848 463435 467097 468949 469221 473213 485472 487281 489331 495481 502789 510729 511240 511857 511869 519722 520491 520495 521238 521831 523406 527677 528775 535295 535963 536641 542422 547801 550952 556445 561909 561952 562222 567063 567245 568075 577520 579649 582582 585229 592621 592662 600031 601862 602846 607560 613515 614968 614979 617473 620323 625633 627446 631728 636732 638671 638885 640312 640353 642165 647383 656801 659219 669583 680816 681242 709838 714294 739810 741186 744028 751285 758318 760319 767731 777752 780195 780266 784681 786017 790629 791026 792148 796673 796996 803632 803931 806495 806826 806904 807170 812493 825864 828725 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo public amateur"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд на улиц любительск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
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.