Query Metrics
7
Database Queries
7
Different statements
170.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.07 ms (86.20%) |
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 96800 130089 291689 308783 320078 403966 408711 419140 453084 453092 495278 530450 542579 542829 551037 552049 554745 559902 560437 562249 567824 569192 570395 571136 583948 583967 584018 588262 593873 595765 595819 598433 598775 603213 603406 606511 606515 613859 617650 621442 623517 626063 630668 630861 635486 643074 643948 645853 646228 648554 659690 661882 668479 673363 679447 680493 691996 694524 694894 697971 698140 708825 710509 712712 713133 714193 715518 718961 720642 720939 724137 725407 728191 728444 743771 747090 748249 750867 770097 775140 775787 775830 775880 775919 775920 775952 775984 776008 776009 786235 786255 788174 789998 794230 794824 794923 796509 801934 810757 810771 811270 814565 815181 815331 815479 815498 816041 816938 817898 817929 818517 818519 818537 818539 818541 818543 820348 822011 823944 827201 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (8.01%) |
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 724137 606515 643948 708825 776009 823944 559902 698140 659690 680493 694524 718961 571136 583967 584018 621442 598433 786235 617650 408711 815498 827201 815479 818519 822011 530450 646228 679447 648554 714193 588262 595765 635486 789998 810757 775140 801934 725407 748249 794824 728191 728444 747090 743771 770097 715518 776008 794230 495278 613859 308783 96800 419140 815331 818543 453084 453092 542829 570395 542579 712712 720642 691996 694894 626063 593873 595819 775787 786255 788174 811270 796509 750867 710509 775984 130089 560437 320078 817898 818517 815181 816041 818541 583948 554745 562249 551037 673363 713133 598775 775830 775920 794923 810771 603406 623517 775919 775952 403966 291689 816938 820348 818537 814565 817929 818539 552049 567824 661882 668479 697971 645853 720939 569192 630668 606511 603213 630861 643074 775880 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.82%) |
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 96800 130089 291689 308783 320078 403966 408711 419140 453084 453092 495278 530450 542579 542829 551037 552049 554745 559902 560437 562249 567824 569192 570395 571136 583948 583967 584018 588262 593873 595765 595819 598433 598775 603213 603406 606511 606515 613859 617650 621442 623517 626063 630668 630861 635486 643074 643948 645853 646228 648554 659690 661882 668479 673363 679447 680493 691996 694524 694894 697971 698140 708825 710509 712712 713133 714193 715518 718961 720642 720939 724137 725407 728191 728444 743771 747090 748249 750867 770097 775140 775787 775830 775880 775919 775920 775952 775984 776008 776009 786235 786255 788174 789998 794230 794824 794923 796509 801934 810757 810771 811270 814565 815181 815331 815479 815498 816041 816938 817898 817929 818517 818519 818537 818539 818541 818543 820348 822011 823944 827201 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ gangbang"
]
|
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.