Query Metrics
7
Database Queries
7
Different statements
156.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.39 ms (86.12%) |
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 118109 151014 187516 188282 311235 382421 383241 389611 389639 390918 391968 391989 392673 392679 394433 395914 396956 397871 398514 398570 408207 409390 411390 411408 411773 411929 411960 452856 460015 468167 482182 506142 515732 526254 556451 560397 565730 599773 620256 620708 624466 647856 664809 665516 710531 714152 714153 718496 718839 722127 724302 724702 725372 725576 726786 726955 728240 728348 728891 730076 731686 732236 733223 733293 733380 734371 735987 737169 740185 741653 741904 742722 746890 759761 761326 766574 766597 770192 773543 779197 780706 781019 781648 781780 781929 785848 789528 789539 789556 797281 801398 803918 804211 804221 807380 807600 808040 808500 808506 815299 816769 817208 817211 817795 817799 817960 818660 818814 818949 818991 819018 819117 824604 824906 825158 825260 826057 826316 826739 826988 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (8.63%) |
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 781929 391968 382421 506142 188282 824604 817208 722127 714152 664809 560397 785848 789539 726786 740185 725576 737169 392673 825158 733223 728891 815299 647856 718839 718496 556451 565730 781780 732236 770192 409390 515732 394433 389611 817795 817960 826316 819018 819117 826057 826988 817799 665516 599773 620708 801398 804221 807380 725372 733380 766574 797281 804211 398570 826739 734371 408207 818660 818814 620256 779197 807600 746890 728240 731686 741904 726955 741653 759761 714153 808500 808506 311235 397871 389639 468167 411408 526254 118109 151014 391989 390918 396956 411773 411960 789528 724702 728348 724302 730076 766597 742722 761326 773543 710531 780706 781019 781648 808040 383241 392679 395914 411390 187516 452856 411929 460015 824906 825260 482182 624466 733293 735987 789556 803918 398514 818949 818991 816769 817211 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.45%) |
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 118109 151014 187516 188282 311235 382421 383241 389611 389639 390918 391968 391989 392673 392679 394433 395914 396956 397871 398514 398570 408207 409390 411390 411408 411773 411929 411960 452856 460015 468167 482182 506142 515732 526254 556451 560397 565730 599773 620256 620708 624466 647856 664809 665516 710531 714152 714153 718496 718839 722127 724302 724702 725372 725576 726786 726955 728240 728348 728891 730076 731686 732236 733223 733293 733380 734371 735987 737169 740185 741653 741904 742722 746890 759761 761326 766574 766597 770192 773543 779197 780706 781019 781648 781780 781929 785848 789528 789539 789556 797281 801398 803918 804211 804221 807380 807600 808040 808500 808506 815299 816769 817208 817211 817795 817799 817960 818660 818814 818949 818991 819018 819117 824604 824906 825158 825260 826057 826316 826739 826988 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature pussy"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature pussy"
]
|
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.