Query Metrics
7
Database Queries
7
Different statements
139.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.45 ms (82.88%) |
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 91603 324241 392033 396023 418346 421848 434895 438911 443451 443699 444570 445747 452089 457274 466418 475824 475847 499729 500227 502705 507020 526144 532059 557792 560754 567698 571072 582457 582500 583985 584103 595119 595706 602722 610446 613845 613848 618017 619711 635755 638302 664201 675585 678876 679687 686854 692150 698214 700271 705956 716597 723127 723635 726431 731880 747186 760696 767555 768358 768807 769859 770393 772251 773533 774729 775661 777090 779318 779484 783217 783298 784464 788328 792344 793388 793469 793753 797507 800544 808837 809310 811190 812507 813600 813634 814205 814304 814325 815036 815145 815686 815701 815923 816550 816584 817124 817301 817723 817758 817770 817901 818416 818790 819382 819477 820691 821411 821565 821572 821830 822393 822675 822791 823229 823326 823650 824741 825023 827104 ] |
||||||||||||||||||||||||||||||
|
13.56 ms (9.74%) |
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 705956 783217 783298 788328 443451 815036 679687 769859 396023 475847 747186 800544 445747 91603 814304 716597 779484 793753 760696 812507 731880 768807 772251 773533 774729 457274 560754 324241 438911 823326 452089 502705 571072 582500 567698 595706 602722 610446 613848 595119 500227 444570 582457 686854 692150 775661 811190 784464 779318 808837 809310 584103 827104 583985 613845 443699 821572 678876 726431 466418 700271 635755 797507 767555 618017 418346 532059 475824 421848 499729 507020 526144 557792 664201 675585 723127 638302 619711 793469 792344 793388 768358 770393 698214 777090 434895 392033 814205 815686 815701 815923 816584 817723 817770 821565 822751 822791 825023 813600 813634 723635 824741 817124 817301 817901 818416 818790 820691 822393 823650 816550 817758 819382 819477 821411 821830 822675 823229 814325 815145 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (2.02%) |
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 91603 324241 392033 396023 418346 421848 434895 438911 443451 443699 444570 445747 452089 457274 466418 475824 475847 499729 500227 502705 507020 526144 532059 557792 560754 567698 571072 582457 582500 583985 584103 595119 595706 602722 610446 613845 613848 618017 619711 635755 638302 664201 675585 678876 679687 686854 692150 698214 700271 705956 716597 723127 723635 726431 731880 747186 760696 767555 768358 768807 769859 770393 772251 773533 774729 775661 777090 779318 779484 783217 783298 784464 788328 792344 793388 793469 793753 797507 800544 808837 809310 811190 812507 813600 813634 814205 814304 814325 815036 815145 815686 815701 815923 816550 816584 817124 817301 817723 817758 817770 817901 818416 818790 819382 819477 820691 821411 821565 821572 821830 822393 822675 822791 823229 823326 823650 824741 825023 827104 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"длинные минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.19%) |
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.