Query Metrics
7
Database Queries
7
Different statements
154.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.93 ms (84.59%) |
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 12423 17058 21488 114712 282558 358438 382818 388746 389943 393061 400556 403979 406853 411778 420510 424809 427851 433097 445539 446129 448830 473609 500331 500798 514801 515240 523535 532428 556851 559108 578527 590857 597841 600425 602859 603239 615538 654624 660863 675241 675960 676404 678313 678561 682914 695940 701463 711337 718655 720819 721569 721796 721843 722822 723481 723527 723603 725312 729328 735418 742158 746100 747017 751495 751618 758456 759548 767957 770217 770520 772970 773441 776307 788770 789872 790063 792337 792822 796555 797654 799599 803343 803677 804455 804771 805276 805537 805989 806227 806346 807376 809723 812151 812735 814936 814942 815248 815337 815345 815395 815505 815534 815591 815826 816058 816068 816562 818169 818273 818277 818282 818325 818382 818459 820047 820387 821612 822222 822986 823420 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (9.79%) |
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 792337 803677 701463 812735 17058 406853 818459 815505 695940 660863 799599 772970 759548 747017 590857 816058 815345 515240 805537 807376 806227 815395 711337 751495 722822 514801 420510 114712 12423 282558 358438 446129 427851 559108 578527 500331 556851 597841 448830 445539 500798 523535 433097 473609 600425 682914 603239 790063 803343 388746 382818 818169 815826 751618 721569 393061 814936 654624 675960 676404 403979 820047 818325 820387 816068 532428 678313 721796 723481 718655 615538 602859 792822 773441 742158 767957 725312 746100 776307 400556 424809 804771 389943 815534 818277 822222 723527 723603 815337 816562 818382 823420 678561 720819 805276 805989 788770 796555 806346 812151 758456 789872 804455 729328 735418 770217 770520 721843 797654 809723 675241 21488 411778 815248 815591 821612 814942 818282 822986 818273 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.62%) |
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 12423 17058 21488 114712 282558 358438 382818 388746 389943 393061 400556 403979 406853 411778 420510 424809 427851 433097 445539 446129 448830 473609 500331 500798 514801 515240 523535 532428 556851 559108 578527 590857 597841 600425 602859 603239 615538 654624 660863 675241 675960 676404 678313 678561 682914 695940 701463 711337 718655 720819 721569 721796 721843 722822 723481 723527 723603 725312 729328 735418 742158 746100 747017 751495 751618 758456 759548 767957 770217 770520 772970 773441 776307 788770 789872 790063 792337 792822 796555 797654 799599 803343 803677 804455 804771 805276 805537 805989 806227 806346 807376 809723 812151 812735 814936 814942 815248 815337 815345 815395 815505 815534 815591 815826 816058 816068 816562 818169 818273 818277 818282 818325 818382 818459 820047 820387 821612 822222 822986 823420 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жмж римминг анилингус"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жмж секс втро анилингус анилингус"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро анилингус анилингус"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.