Query Metrics
7
Database Queries
7
Different statements
289.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
268.74 ms (92.92%) |
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 374819 398387 410062 413356 413404 418693 419029 421154 428610 432716 434883 437668 440715 441159 441453 441480 444574 446645 447109 449502 449517 449854 454090 455928 457328 458013 468020 475054 490536 493035 509605 510303 512547 514957 526265 541062 541692 542376 556670 560982 562492 572960 581255 583510 591744 593594 593634 594272 594412 595283 595378 597911 604229 606357 608121 608818 624194 625299 626403 630451 635250 640411 643573 650765 654922 655151 656483 656621 660346 666434 677624 680301 683124 687137 691166 693281 693490 693509 693680 695014 695319 700506 710736 712366 712374 715830 720192 721882 723167 741785 747912 748064 748362 750331 762986 764220 764274 765433 767571 769070 774693 778989 783376 789824 789871 790502 790516 792706 793313 794560 800400 801688 806574 810860 813285 813467 816607 817708 824200 ] |
||||||||||||||||||||||||||||||
|
11.84 ms (4.09%) |
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 712374 594412 475054 695014 428610 446645 447109 454090 604229 444574 693509 608121 593594 594272 556670 817708 413356 441453 421154 816607 457328 512547 560982 581255 720192 640411 801688 813285 774693 790502 793313 800400 810860 750331 764220 747912 765433 764274 767571 715830 721882 789824 789871 790516 791816 792706 806574 374819 418693 441159 572960 583510 541692 562492 541062 655151 693490 683124 687137 693281 656483 660346 680301 693680 695319 593634 625299 630451 643573 595378 626403 595283 597911 741785 608818 710736 493035 458013 606357 419029 437668 509605 398387 449517 490536 449854 526265 510303 542376 650765 712366 624194 591744 794560 813467 762986 783376 441480 455928 410062 440715 691166 434883 432716 413404 824200 449502 468020 514957 654922 677624 700506 656621 666434 723167 635250 778989 748064 748362 769070 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.93%) |
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 374819 398387 410062 413356 413404 418693 419029 421154 428610 432716 434883 437668 440715 441159 441453 441480 444574 446645 447109 449502 449517 449854 454090 455928 457328 458013 468020 475054 490536 493035 509605 510303 512547 514957 526265 541062 541692 542376 556670 560982 562492 572960 581255 583510 591744 593594 593634 594272 594412 595283 595378 597911 604229 606357 608121 608818 624194 625299 626403 630451 635250 640411 643573 650765 654922 655151 656483 656621 660346 666434 677624 680301 683124 687137 691166 693281 693490 693509 693680 695014 695319 700506 710736 712366 712374 715830 720192 721882 723167 741785 747912 748064 748362 750331 762986 764220 764274 765433 767571 769070 774693 778989 783376 789824 789871 790502 790516 792706 793313 794560 800400 801688 806574 810860 813285 813467 816607 817708 824200 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie teen любительск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie teen amateur"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie teen любительск"
]
|
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.