Query Metrics
7
Database Queries
7
Different statements
389.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
362.57 ms (93.10%) |
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 117687 118086 346126 346173 383742 410664 419557 432274 435539 439023 439138 440068 441106 441107 441233 441834 441952 446781 450484 451775 456229 456239 457698 459204 467196 475226 478904 481169 483704 487275 487422 488752 492181 497480 498697 502212 502457 507314 508909 511343 515435 521814 527911 530942 531789 534576 534585 536128 538925 541325 547483 549081 554257 554851 554858 561040 562164 566822 571846 573198 573206 575369 576545 576916 584048 584367 586914 590729 597163 600087 600348 605725 615693 628094 629934 633887 634071 639381 639736 639804 641997 642035 643187 656895 660373 660411 661036 661915 664226 666016 671018 671045 672950 680423 686106 702157 705466 706038 708069 709559 709693 712268 713142 713460 715790 717535 723930 735124 745806 747073 750641 752631 752667 762294 782842 786911 788788 790136 791370 796837 ] |
||||||||||||||||||||||||||||||
|
16.64 ms (4.27%) |
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 702157 713142 660373 666016 671018 671045 672950 686106 576545 586914 642035 597163 639804 590729 633887 762294 723930 752667 715790 439023 483704 511343 502457 346126 566822 661036 709559 639381 643187 796837 735124 708069 562164 488752 441106 440068 457698 459204 534576 534585 538925 487275 575369 656895 664226 705466 790136 747073 639736 441233 481169 515435 521814 605725 487422 527911 584367 713460 750641 752631 712268 117687 554858 450484 451775 536128 507314 508909 573206 576916 554257 584048 706038 346173 410664 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 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (0.73%) |
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 117687 118086 346126 346173 383742 410664 419557 432274 435539 439023 439138 440068 441106 441107 441233 441834 441952 446781 450484 451775 456229 456239 457698 459204 467196 475226 478904 481169 483704 487275 487422 488752 492181 497480 498697 502212 502457 507314 508909 511343 515435 521814 527911 530942 531789 534576 534585 536128 538925 541325 547483 549081 554257 554851 554858 561040 562164 566822 571846 573198 573206 575369 576545 576916 584048 584367 586914 590729 597163 600087 600348 605725 615693 628094 629934 633887 634071 639381 639736 639804 641997 642035 643187 656895 660373 660411 661036 661915 664226 666016 671018 671045 672950 680423 686106 702157 705466 706038 708069 709559 709693 712268 713142 713460 715790 717535 723930 735124 745806 747073 750641 752631 752667 762294 782842 786911 788788 790136 791370 796837 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг девушк"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting girl"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.40%) |
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.