Query Metrics
7
Database Queries
7
Different statements
146.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.00 ms (82.86%) |
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 383833 441845 443264 467659 501118 515326 528494 528513 529683 530621 536132 547225 553636 553679 567617 573986 584346 585047 595107 603326 604001 604900 610484 612488 613942 615146 616243 619117 619620 619700 620552 621109 621728 626325 627182 629573 629957 630666 636261 636482 636508 638373 642115 642536 643220 651323 651441 653290 655241 655602 657860 660692 660772 661334 661637 662089 662512 663182 664487 664517 664621 668982 670214 671472 676660 677913 678593 684502 688190 688969 689028 689085 689488 689492 695051 696332 697247 701939 702960 703252 703279 705052 706432 707538 708688 709364 709700 709859 712426 717149 717155 721811 722182 723965 724102 739963 742719 757120 759913 761447 763223 764139 764157 764691 767335 768657 779482 779831 781145 791157 792788 793752 794268 797286 798619 801459 803732 804926 808258 823704 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (9.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 763223 742719 761447 764157 764691 767335 717149 779482 779831 781145 792788 794268 797286 803732 808258 604001 529683 515326 528494 528513 501118 530621 536132 553636 584346 662089 664487 677913 684502 689028 689488 689492 695051 696332 697247 702960 707538 712426 651323 651441 657860 661637 664517 664621 668982 671472 676660 688969 689085 705052 706432 708688 721811 653290 655241 655602 660772 661334 662512 663182 678593 688190 709700 547225 567617 595107 603326 604900 610484 616243 636261 638373 613942 619620 621109 621728 627182 629573 636482 642536 643220 612488 619700 636508 619117 626325 629957 791157 793752 804926 764139 615146 630666 642115 701939 703252 703279 709364 709859 798619 739963 383833 585047 823704 553679 573986 717155 660692 670214 722182 620552 801459 768657 723965 757120 759913 441845 467659 443264 724102 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (2.58%) |
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 383833 441845 443264 467659 501118 515326 528494 528513 529683 530621 536132 547225 553636 553679 567617 573986 584346 585047 595107 603326 604001 604900 610484 612488 613942 615146 616243 619117 619620 619700 620552 621109 621728 626325 627182 629573 629957 630666 636261 636482 636508 638373 642115 642536 643220 651323 651441 653290 655241 655602 657860 660692 660772 661334 661637 662089 662512 663182 664487 664517 664621 668982 670214 671472 676660 677913 678593 684502 688190 688969 689028 689085 689488 689492 695051 696332 697247 701939 702960 703252 703279 705052 706432 707538 708688 709364 709700 709859 712426 717149 717155 721811 722182 723965 724102 739963 742719 757120 759913 761447 763223 764139 764157 764691 767335 768657 779482 779831 781145 791157 792788 793752 794268 797286 798619 801459 803732 804926 808258 823704 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск cumshot"
]
|
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.