Query Metrics
7
Database Queries
7
Different statements
206.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.45 ms (86.56%) |
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 4463 124361 187851 187956 188009 188169 188456 233340 233512 357595 358566 382431 385603 388200 388203 388204 388329 388364 388470 388716 388723 388739 388784 388968 389582 389860 390051 390580 390582 390643 390954 391077 391155 391156 391427 391652 393097 395955 396887 397866 397874 397878 398525 398557 407763 409942 411326 411347 411615 425795 439751 439784 439816 440726 444255 460760 466097 468167 470198 470214 476348 480059 480526 489958 498730 509039 511527 513195 513381 515723 518622 526693 546124 561583 604523 608353 616996 620330 635490 663461 665406 665483 667701 675498 678775 680704 712311 716254 718500 720290 720583 720693 726902 727740 728446 728451 733291 739955 740792 741896 758278 765632 766669 774187 774200 780634 781745 797278 799971 802147 802463 817308 817687 818739 820261 820384 823688 823857 826784 827054 ] |
||||||||||||||||||||||||||||||
|
17.39 ms (8.44%) |
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 439816 439784 511527 480526 470214 439751 758278 526693 480059 546124 440726 498730 608353 509039 425795 513195 466097 604523 518622 635490 620330 513381 489958 515723 616996 390643 388723 388204 388329 802463 409942 397878 728451 233512 391155 390051 774187 820261 388716 188456 124361 388739 389582 388364 827054 397874 678775 720583 393097 397866 675498 740792 739955 411347 766669 388470 388784 391077 391427 823857 780634 741896 774200 388968 358566 187956 385603 390580 818739 561583 233340 396887 665483 389860 398557 4463 391652 391156 826784 395955 357595 470198 797278 817308 802147 382431 817687 823688 667701 733291 716254 718500 187851 663461 799971 728446 712311 726902 460760 468167 411326 411615 720290 665406 398525 820384 680704 727740 765632 781745 188169 407763 720693 444255 388200 388203 390954 188009 476348 390582 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.35%) |
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 4463 124361 187851 187956 188009 188169 188456 233340 233512 357595 358566 382431 385603 388200 388203 388204 388329 388364 388470 388716 388723 388739 388784 388968 389582 389860 390051 390580 390582 390643 390954 391077 391155 391156 391427 391652 393097 395955 396887 397866 397874 397878 398525 398557 407763 409942 411326 411347 411615 425795 439751 439784 439816 440726 444255 460760 466097 468167 470198 470214 476348 480059 480526 489958 498730 509039 511527 513195 513381 515723 518622 526693 546124 561583 604523 608353 616996 620330 635490 663461 665406 665483 667701 675498 678775 680704 712311 716254 718500 720290 720583 720693 726902 727740 728446 728451 733291 739955 740792 741896 758278 765632 766669 774187 774200 780634 781745 797278 799971 802147 802463 817308 817687 818739 820261 820384 823688 823857 826784 827054 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mature"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mature"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mature"
]
|
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.