Query Metrics
7
Database Queries
7
Different statements
384.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
357.63 ms (93.11%) |
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 7172 381876 418883 425502 433572 433829 437450 439590 441806 452116 460237 461355 463936 465431 465933 466560 469023 469569 472533 472833 478090 478210 488197 491913 500015 505684 509620 510518 510853 513096 514047 516972 517048 518881 523131 524371 524608 525254 525826 525839 526041 526772 527716 528001 528196 528931 529555 531089 534329 535013 535021 540410 540803 542369 549562 550624 551997 554543 556854 559551 559757 560802 562058 562176 564814 566781 566993 567338 569132 569269 571378 571954 578180 582189 584445 584510 584690 585455 593441 596075 596966 598845 605906 606993 607146 607227 608279 613167 618622 619154 619747 620330 623229 624111 624762 624986 625590 626572 627693 633085 634765 638115 641949 678099 681052 691221 744355 761543 784481 784487 785558 789525 790856 791738 799421 810698 811998 815648 818156 827998 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (4.29%) |
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 633085 811998 789525 784481 784487 790856 799421 810698 761543 744355 785558 433572 433829 478210 418883 469569 513096 518881 469023 550624 571954 525254 582189 638115 624762 463936 526772 437450 619154 549562 681052 526041 452116 439590 510518 531089 569132 562176 566781 606993 618622 593441 505684 425502 605906 567338 624111 528931 815648 818156 514047 569269 584690 678099 556854 560802 607146 619747 598845 613167 596075 623229 465933 472533 525826 527716 528001 535013 7172 584510 528196 534329 542369 585455 540410 566993 608279 525839 491913 554543 571378 827998 460237 596966 624986 472833 523131 535021 516972 562058 559551 607227 634765 791738 641949 524371 524608 529555 540803 510853 626572 381876 584445 466560 627693 578180 625590 509620 441806 461355 478090 551997 564814 620330 488197 465431 691221 559757 500015 517048 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (0.95%) |
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 7172 381876 418883 425502 433572 433829 437450 439590 441806 452116 460237 461355 463936 465431 465933 466560 469023 469569 472533 472833 478090 478210 488197 491913 500015 505684 509620 510518 510853 513096 514047 516972 517048 518881 523131 524371 524608 525254 525826 525839 526041 526772 527716 528001 528196 528931 529555 531089 534329 535013 535021 540410 540803 542369 549562 550624 551997 554543 556854 559551 559757 560802 562058 562176 564814 566781 566993 567338 569132 569269 571378 571954 578180 582189 584445 584510 584690 585455 593441 596075 596966 598845 605906 606993 607146 607227 608279 613167 618622 619154 619747 620330 623229 624111 624762 624986 625590 626572 627693 633085 634765 638115 641949 678099 681052 691221 744355 761543 784481 784487 785558 789525 790856 791738 799421 810698 811998 815648 818156 827998 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties fetish"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел фетиш"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.36%) |
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.