Query Metrics
7
Database Queries
7
Different statements
182.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.20 ms (88.46%) |
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 6999 23687 24087 24855 97747 97851 384547 386645 389693 395439 396378 396418 396447 400595 402341 420440 424048 426781 428850 436977 446215 475347 488242 505455 514282 530296 535300 540707 541359 552741 553155 553593 553697 554844 562659 570870 584864 592118 592287 593983 599242 601725 609761 611496 613317 614477 614536 614657 615611 616964 624907 629462 632471 635647 638738 638871 643159 649440 650221 654090 660787 663284 667246 672844 675415 680778 684449 685450 688173 692704 696123 697202 699196 700818 701901 701909 702034 702551 706810 710037 713104 713423 718306 719895 722368 726219 732685 732755 732789 741824 748519 750988 753432 753619 754859 754894 759019 759039 762854 764717 766301 778183 779483 780543 782881 782918 785167 787862 790712 791879 793580 794986 795108 795109 798409 801049 809809 810160 811162 812276 ] |
||||||||||||||||||||||||||||||
|
11.65 ms (6.39%) |
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 812276 386645 785167 649440 601725 402341 718306 635647 384547 791879 593983 584864 754859 632471 710037 732789 732755 389693 24855 540707 553155 713423 592118 643159 794986 759019 428850 505455 395439 811162 793580 426781 6999 530296 553697 552741 719895 675415 699196 713104 616964 615611 638738 790712 732685 753619 750988 722368 680778 696123 592287 702034 554844 782918 475347 741824 420440 753432 780543 795108 801049 795109 809809 748519 798409 24087 697202 701901 701909 663284 684449 685450 692704 700818 706810 660787 672844 688173 702551 599242 611496 613317 614477 614536 638871 609761 614657 650221 667246 553593 778183 754894 782881 787862 726219 762854 766301 759039 764717 779483 810160 97747 396418 400595 446215 488242 562659 629462 424048 23687 396447 436977 535300 654090 396378 541359 570870 624907 97851 514282 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.23%) |
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 6999 23687 24087 24855 97747 97851 384547 386645 389693 395439 396378 396418 396447 400595 402341 420440 424048 426781 428850 436977 446215 475347 488242 505455 514282 530296 535300 540707 541359 552741 553155 553593 553697 554844 562659 570870 584864 592118 592287 593983 599242 601725 609761 611496 613317 614477 614536 614657 615611 616964 624907 629462 632471 635647 638738 638871 643159 649440 650221 654090 660787 663284 667246 672844 675415 680778 684449 685450 688173 692704 696123 697202 699196 700818 701901 701909 702034 702551 706810 710037 713104 713423 718306 719895 722368 726219 732685 732755 732789 741824 748519 750988 753432 753619 754859 754894 759019 759039 762854 764717 766301 778183 779483 780543 782881 782918 785167 787862 790712 791879 793580 794986 795108 795109 798409 801049 809809 810160 811162 812276 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск ван"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.