Query Metrics
7
Database Queries
7
Different statements
162.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.14 ms (83.29%) |
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 150124 392214 425268 448663 451608 453846 454325 455596 461330 472225 490237 497971 500720 504786 507158 513451 520879 521172 533636 537634 543803 551104 553560 554794 555150 555644 558996 559852 562168 563512 566488 567126 570871 584042 603288 611391 616913 621353 621356 631294 637450 644640 647185 648246 655490 660262 667246 671693 673175 673531 679708 684230 684248 689296 689740 691969 699038 700800 706995 712705 713251 718908 723941 726394 726899 727580 728669 730825 732988 734471 738121 738376 740102 740633 740981 743911 746057 746170 746351 750092 750275 758334 759445 759861 760882 762882 766459 767127 769388 779265 783037 788514 789470 789890 792759 792834 794735 795241 795375 796178 796350 796608 797297 800188 801149 804037 804535 805313 805317 811554 812121 814611 814613 817466 817735 818727 820378 821052 822339 826815 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (9.28%) |
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 750275 451608 453846 543803 679708 655490 647185 667246 689740 555150 783037 789470 811554 743911 769388 732988 740102 734471 746057 792834 794735 805317 817466 689296 637450 738121 767127 490237 805313 800188 562168 621356 455596 448663 521172 425268 826815 821052 504786 497971 537634 553560 584042 554794 563512 673175 706995 712705 660262 691969 700800 699038 555644 631294 796350 804535 723941 766459 795241 796608 738376 750092 726899 746170 746351 760882 762882 759861 603288 779265 797297 804037 513451 500720 566488 648246 812121 567126 814613 472225 551104 684230 558996 611391 740633 454325 820378 817735 616913 788514 740981 727580 730825 796178 461330 570871 621353 533636 814611 520879 559852 684248 673531 671693 644640 728669 758334 801149 726394 818727 507158 392214 822339 713251 718908 789890 759445 792759 795375 150124 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.15%) |
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 150124 392214 425268 448663 451608 453846 454325 455596 461330 472225 490237 497971 500720 504786 507158 513451 520879 521172 533636 537634 543803 551104 553560 554794 555150 555644 558996 559852 562168 563512 566488 567126 570871 584042 603288 611391 616913 621353 621356 631294 637450 644640 647185 648246 655490 660262 667246 671693 673175 673531 679708 684230 684248 689296 689740 691969 699038 700800 706995 712705 713251 718908 723941 726394 726899 727580 728669 730825 732988 734471 738121 738376 740102 740633 740981 743911 746057 746170 746351 750092 750275 758334 759445 759861 760882 762882 766459 767127 769388 779265 783037 788514 789470 789890 792759 792834 794735 795241 795375 796178 796350 796608 797297 800188 801149 804037 804535 805313 805317 811554 812121 814611 814613 817466 817735 818727 820378 821052 822339 826815 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden ass fuck"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт жоп секс"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.