Query Metrics
7
Database Queries
7
Different statements
200.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.18 ms (85.59%) |
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 390096 411811 421918 426549 427186 429809 433341 434181 439648 441336 442991 448955 453135 457439 457443 457463 459595 464919 467121 473785 474463 476691 478385 486834 488102 490235 507041 510333 513701 529597 529857 538010 543532 549731 552294 555074 555109 560968 564391 582404 585532 585975 592161 604313 604318 618052 620258 639385 646946 652681 660081 661593 663162 663738 665790 680237 680346 690394 718996 722029 723591 723667 737562 742631 749891 761713 765327 765686 766591 766635 766653 767138 767273 768759 768760 769838 770301 775640 776393 783369 784488 790185 790298 790845 790941 791412 791518 794533 794863 796534 798730 798773 800333 800364 800380 800520 800608 801483 805777 808228 810332 812829 813181 815062 815078 815095 815108 816629 816684 817246 817884 819128 819425 820171 821726 822206 822278 827325 827589 828788 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (9.59%) |
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 441336 529597 663738 800380 768760 620258 552294 560968 439648 448955 421918 457439 490235 538010 429809 817246 819425 822278 723591 827325 827589 820171 822206 828788 798730 800333 812829 767273 766635 737562 765686 769838 783369 798773 816629 819128 555109 808228 800608 821726 564391 646946 690394 660081 680237 585532 585975 604318 776393 790298 810332 791518 794533 767138 790845 742631 765327 766591 761713 766653 770301 790941 791412 794863 796534 661593 723667 816684 543532 639385 800364 768759 790185 390096 442991 433341 457463 488102 464919 467121 507041 549731 582404 618052 718996 434181 474463 459595 457443 529857 652681 592161 775640 800520 427186 815078 815108 815062 663162 665790 722029 604313 805777 801483 473785 784488 478385 817884 411811 513701 749891 680346 813181 815095 426549 453135 486834 476691 510333 555074 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.43%) |
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 390096 411811 421918 426549 427186 429809 433341 434181 439648 441336 442991 448955 453135 457439 457443 457463 459595 464919 467121 473785 474463 476691 478385 486834 488102 490235 507041 510333 513701 529597 529857 538010 543532 549731 552294 555074 555109 560968 564391 582404 585532 585975 592161 604313 604318 618052 620258 639385 646946 652681 660081 661593 663162 663738 665790 680237 680346 690394 718996 722029 723591 723667 737562 742631 749891 761713 765327 765686 766591 766635 766653 767138 767273 768759 768760 769838 770301 775640 776393 783369 784488 790185 790298 790845 790941 791412 791518 794533 794863 796534 798730 798773 800333 800364 800380 800520 800608 801483 805777 808228 810332 812829 813181 815062 815078 815095 815108 816629 816684 817246 817884 819128 819425 820171 821726 822206 822278 827325 827589 828788 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал пов"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal pov"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал пов"
]
|
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.