Query Metrics
7
Database Queries
7
Different statements
204.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.93 ms (88.28%) |
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 411829 414126 416772 419123 419722 421345 425706 429766 443476 452139 454102 457500 465509 471792 475911 478433 480293 486426 496032 497776 509855 510394 515329 517847 518493 522909 523418 530663 530836 531085 531115 531237 532166 532982 533364 533371 533378 535045 535358 536178 536215 536640 536681 537671 537673 542591 545117 545430 553273 564407 565251 568189 590429 596192 599844 599852 600002 600346 603436 604310 604558 616617 619410 620768 624806 626297 628365 628391 628401 628407 628415 631249 632001 632021 632277 633744 633765 633804 634158 634787 636292 637033 637047 637048 637078 637087 637147 639731 640779 640783 640800 641683 641986 644973 646004 646875 647954 648838 648870 649186 649583 650174 677974 678128 692887 705663 712964 719391 720291 721109 723580 728324 733881 741540 741542 743057 748365 750152 788566 818439 ] |
||||||||||||||||||||||||||||||
|
15.07 ms (7.35%) |
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 411829 522909 628401 531237 537673 532166 719391 604558 637033 633804 604310 637087 788566 733881 728324 603436 620768 633765 721109 634158 723580 818439 480293 536178 523418 712964 632021 637048 748365 531085 568189 545117 637147 750152 741540 720291 649583 497776 465509 536215 452139 641683 421345 536640 542591 565251 637047 619410 628407 475911 509855 705663 600002 429766 478433 590429 600346 414126 457500 677974 626297 646875 533371 641986 486426 564407 545430 678128 471792 454102 531115 596192 628365 634787 633744 640779 640783 644973 648838 616617 419123 536681 533364 535358 515329 553273 647954 646004 650174 648870 649186 692887 631249 599852 637078 640800 636292 419722 443476 496032 599844 416772 639731 510394 518493 628415 530663 532982 533378 743057 628391 632001 632277 624806 425706 517847 741542 537671 530836 535045 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.29%) |
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 411829 414126 416772 419123 419722 421345 425706 429766 443476 452139 454102 457500 465509 471792 475911 478433 480293 486426 496032 497776 509855 510394 515329 517847 518493 522909 523418 530663 530836 531085 531115 531237 532166 532982 533364 533371 533378 535045 535358 536178 536215 536640 536681 537671 537673 542591 545117 545430 553273 564407 565251 568189 590429 596192 599844 599852 600002 600346 603436 604310 604558 616617 619410 620768 624806 626297 628365 628391 628401 628407 628415 631249 632001 632021 632277 633744 633765 633804 634158 634787 636292 637033 637047 637048 637078 637087 637147 639731 640779 640783 640800 641683 641986 644973 646004 646875 647954 648838 648870 649186 649583 650174 677974 678128 692887 705663 712964 719391 720291 721109 723580 728324 733881 741540 741542 743057 748365 750152 788566 818439 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг анал секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting anal threesome"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.73%) |
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.