Query Metrics
7
Database Queries
7
Different statements
250.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.63 ms (90.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 392611 398138 410786 423094 428105 437161 438056 455332 455840 460534 462616 463240 469682 473691 478212 478282 479894 495623 506544 516220 516929 524205 529460 542174 545233 553610 555661 556869 559616 565000 571770 573915 574300 578937 591319 593758 606090 611573 615616 617061 623352 624000 633708 643241 645446 650692 650937 661381 667146 667464 677916 696069 696432 697596 697934 701604 706067 709512 717224 719899 719907 721991 724731 725782 732584 732605 734030 735838 736460 736559 740954 742767 749575 753761 753999 755737 771512 772836 775130 776359 777630 779722 779767 779797 779820 779829 783525 783730 783781 785454 785526 785924 786588 790265 791494 791497 791519 791524 791578 791579 791581 792462 801649 803303 817403 817437 817651 819455 819793 823841 825633 827999 828006 828071 828151 828286 828351 828415 ] |
||||||||||||||||||||||||||||||
|
13.27 ms (5.30%) |
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 719907 623352 828071 473691 624000 565000 817403 771512 732584 785454 392611 667146 697934 791497 615616 650692 701604 755737 749575 633708 719899 469682 478282 495623 593758 611573 516929 479894 591319 478212 410786 574300 455332 667464 524205 437161 423094 428105 463240 516220 455840 772836 555661 650937 791519 785924 753761 645446 559616 661381 823841 828286 791524 529460 783730 817651 825633 791579 697596 740954 696069 732605 779767 742767 791581 828351 706067 735838 783525 734030 677916 779829 779797 629530 783781 398138 696432 827999 828151 462616 460534 709512 776359 753999 779722 819455 578937 643241 736559 785526 571770 819793 573915 721991 790265 717224 791494 617061 791578 438056 542174 803303 777630 724731 786588 775130 779820 556869 828415 553610 828006 606090 792462 725782 801649 506544 826151 817437 736460 545233 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.09%) |
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 392611 398138 410786 423094 428105 437161 438056 455332 455840 460534 462616 463240 469682 473691 478212 478282 479894 495623 506544 516220 516929 524205 529460 542174 545233 553610 555661 556869 559616 565000 571770 573915 574300 578937 591319 593758 606090 611573 615616 617061 623352 624000 633708 643241 645446 650692 650937 661381 667146 667464 677916 696069 696432 697596 697934 701604 706067 709512 717224 719899 719907 721991 724731 725782 732584 732605 734030 735838 736460 736559 740954 742767 749575 753761 753999 755737 771512 772836 775130 776359 777630 779722 779767 779797 779820 779829 783525 783730 783781 785454 785526 785924 786588 790265 791494 791497 791519 791524 791578 791579 791581 792462 801649 803303 817403 817437 817651 819455 819793 823841 825633 827999 828006 828071 828151 828286 828351 828415 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public panty cum"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на panty улиц cum"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на panty улиц cum"
]
|
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.