Query Metrics
7
Database Queries
7
Different statements
287.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
255.52 ms (88.91%) |
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 70659 95748 95991 96272 96944 163133 316575 341802 358539 373798 381775 383828 384143 385830 385950 390980 391508 395433 395839 395937 397111 397503 398689 401655 404968 405000 405176 406091 410936 414172 414673 417066 417486 419378 420252 424360 426693 428414 433100 435664 438761 447885 451893 453356 464366 468622 471601 476255 490304 503507 518547 522556 531249 535466 539126 540656 543677 548796 561816 576412 584721 591744 600330 603240 614739 621029 628424 629273 640523 640708 640806 640939 642691 644636 649266 652897 670719 675809 686615 687249 692324 692438 694071 695278 695280 695556 697374 699164 700670 704268 705829 705832 708826 715191 717805 719983 720381 720885 733891 738812 739012 741538 742886 744744 745378 748530 758201 759639 766274 766847 767283 773123 777064 784569 793472 795525 802175 807557 809476 825644 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (6.13%) |
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 358539 420252 395433 397503 825644 584721 715191 802175 742886 705829 95991 373798 419378 404968 453356 705832 417066 692324 695280 675809 686615 697374 699164 694071 695278 745378 744744 739012 640523 704268 717805 468622 600330 784569 640806 733891 748530 766274 405000 414673 447885 773123 640708 603240 640939 384143 531249 435664 759639 397111 644636 700670 518547 543677 670719 692438 649266 591744 621029 767283 738812 652897 614739 720885 490304 464366 395839 628424 426693 522556 401655 476255 417486 793472 795525 406091 414172 70659 385950 96272 433100 535466 719983 720381 741538 451893 395937 96944 687249 708826 758201 398689 163133 405176 95748 642691 410936 561816 383828 548796 629273 807557 766847 809476 390980 428414 424360 391508 438761 777064 471601 381775 539126 385830 316575 341802 540656 695556 503507 576412 ] |
||||||||||||||||||||||||||||||
|
5.89 ms (2.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen секс втро анал"
]
|
||||||||||||||||||||||||||||||
|
3.35 ms (1.16%) |
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 70659 95748 95991 96272 96944 163133 316575 341802 358539 373798 381775 383828 384143 385830 385950 390980 391508 395433 395839 395937 397111 397503 398689 401655 404968 405000 405176 406091 410936 414172 414673 417066 417486 419378 420252 424360 426693 428414 433100 435664 438761 447885 451893 453356 464366 468622 471601 476255 490304 503507 518547 522556 531249 535466 539126 540656 543677 548796 561816 576412 584721 591744 600330 603240 614739 621029 628424 629273 640523 640708 640806 640939 642691 644636 649266 652897 670719 675809 686615 687249 692324 692438 694071 695278 695280 695556 697374 699164 700670 704268 705829 705832 708826 715191 717805 719983 720381 720885 733891 738812 739012 741538 742886 744744 745378 748530 758201 759639 766274 766847 767283 773123 777064 784569 793472 795525 802175 807557 809476 825644 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen threesome anal"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.