Query Metrics
7
Database Queries
7
Different statements
170.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.34 ms (84.74%) |
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 33443 169759 256222 324484 382296 382879 386017 387738 389719 391550 397538 410655 420130 420636 423673 448890 450259 454891 471999 491238 499924 524270 528405 530565 532822 536005 536660 545628 549675 551464 554324 557520 557921 574449 579255 581672 583639 586086 588230 592441 595077 596142 601744 601776 602600 619773 623268 624393 627938 631615 636028 638278 643078 643373 650908 652052 662446 662526 664137 664221 666032 670448 672836 680925 684660 684678 689877 697879 698374 704152 707490 721204 723171 730218 733506 736978 743188 743245 743610 743658 751748 751750 753021 754335 754397 755354 756120 757832 759106 768834 769438 770815 782534 782987 785683 790881 790886 792598 792623 798753 798850 802904 803028 803134 803594 804396 804399 804766 806002 807854 807861 808951 809650 810965 811142 812423 813710 816644 826564 827011 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (8.67%) |
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 753021 782987 809650 721204 798850 803028 554324 551464 652052 631615 770815 827011 798753 755354 256222 804399 524270 549675 743610 448890 389719 624393 638278 397538 627938 813710 536005 680925 785683 751748 756120 723171 810965 812423 804766 754335 650908 643078 586086 807854 807861 33443 581672 662446 588230 636028 601776 491238 803594 536660 579255 595077 643373 803134 704152 684678 596142 602600 592441 743188 382296 806002 454891 826564 623268 754397 757832 532822 759106 545628 386017 528405 557921 420636 790886 420130 471999 804396 769438 423673 684660 601744 802904 387738 583639 743658 736978 698374 450259 662526 619773 689877 672836 697879 730218 666032 169759 808951 707490 410655 499924 574449 792598 391550 664221 790881 557520 530565 664137 792623 733506 382879 324484 816644 670448 811142 782534 768834 743245 751750 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.76%) |
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 33443 169759 256222 324484 382296 382879 386017 387738 389719 391550 397538 410655 420130 420636 423673 448890 450259 454891 471999 491238 499924 524270 528405 530565 532822 536005 536660 545628 549675 551464 554324 557520 557921 574449 579255 581672 583639 586086 588230 592441 595077 596142 601744 601776 602600 619773 623268 624393 627938 631615 636028 638278 643078 643373 650908 652052 662446 662526 664137 664221 666032 670448 672836 680925 684660 684678 689877 697879 698374 704152 707490 721204 723171 730218 733506 736978 743188 743245 743610 743658 751748 751750 753021 754335 754397 755354 756120 757832 759106 768834 769438 770815 782534 782987 785683 790881 790886 792598 792623 798753 798850 802904 803028 803134 803594 804396 804399 804766 806002 807854 807861 808951 809650 810965 811142 812423 813710 816644 826564 827011 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits solo"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ соло"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.00%) |
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.