Query Metrics
7
Database Queries
7
Different statements
385.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.20 ms (53.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк фистинг"
]
|
||||||||||||||||||||||||||||||
|
150.33 ms (38.98%) |
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 118086 346173 383742 386707 392005 402619 410664 415029 419557 426291 432274 435539 439052 439138 441057 441107 441834 441925 441952 444079 446781 450484 451775 455021 456229 456239 462495 462986 467196 474891 475226 478904 492181 497480 498697 502212 507314 508904 508909 511923 513978 513982 527920 529797 529897 530942 531789 531869 531877 532736 534552 536128 536375 537861 541325 547466 547468 547474 547483 547488 547849 549081 554257 554851 559298 559368 561040 569053 571846 573198 573204 573206 575378 576438 576916 577005 580121 584048 596428 600087 600348 610029 615693 619108 619996 627514 628094 628485 629934 634071 641997 642058 644018 648224 660411 661915 665973 668645 669038 671044 678798 680423 684706 685061 706038 709693 717535 720007 744992 745806 760507 782842 786911 788788 789529 791370 792747 800282 820083 825791 ] |
||||||||||||||||||||||||||||||
|
18.26 ms (4.74%) |
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 527920 450484 451775 462986 536128 507314 508909 573206 576916 554257 584048 706038 346173 410664 508904 573198 782842 432274 467196 446781 475226 492181 561040 628094 788788 629934 709693 439138 456229 456239 497480 383742 435539 502212 530942 498697 531789 554851 571846 541325 547483 549081 680423 717535 660411 661915 600348 634071 600087 641997 791370 745806 615693 786911 118086 478904 441107 441834 441952 419557 441057 559368 455021 513982 531877 536375 537861 529897 534552 513978 529797 531869 532736 547849 569053 577005 576438 648224 684706 685061 720007 665973 678798 559298 610029 619996 642058 644018 628485 619108 789529 760507 415029 474891 441925 444079 511923 386707 402619 825791 575378 596428 627514 792747 744992 392005 820083 800282 426291 439052 462495 547466 547488 573204 547468 547474 580121 668645 669038 671044 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (0.68%) |
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 118086 346173 383742 386707 392005 402619 410664 415029 419557 426291 432274 435539 439052 439138 441057 441107 441834 441925 441952 444079 446781 450484 451775 455021 456229 456239 462495 462986 467196 474891 475226 478904 492181 497480 498697 502212 507314 508904 508909 511923 513978 513982 527920 529797 529897 530942 531789 531869 531877 532736 534552 536128 536375 537861 541325 547466 547468 547474 547483 547488 547849 549081 554257 554851 559298 559368 561040 569053 571846 573198 573204 573206 575378 576438 576916 577005 580121 584048 596428 600087 600348 610029 615693 619108 619996 627514 628094 628485 629934 634071 641997 642058 644018 648224 660411 661915 665973 668645 669038 671044 678798 680423 684706 685061 706038 709693 717535 720007 744992 745806 760507 782842 786911 788788 789529 791370 792747 800282 820083 825791 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls fisting"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.53%) |
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.