Query Metrics
7
Database Queries
7
Different statements
375.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
347.35 ms (92.43%) |
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 88942 182110 182895 209216 384463 386077 386707 401806 402634 402648 403215 413098 414675 416007 417030 418135 421518 429602 430350 432335 432963 434104 434306 434314 434327 434339 439102 439125 440639 440641 441042 443224 443250 444540 446225 448898 449022 449173 450262 452576 452876 454688 455914 457814 458527 458676 460382 466360 467877 468151 468163 468244 468665 469046 469086 469139 469162 469734 473873 475319 476051 476052 476198 476672 476674 476699 476704 476847 481871 483658 498200 499924 502765 502770 509996 510001 518892 521559 529795 535367 545677 555236 555771 559749 564040 569728 570115 571039 571386 593053 596402 596478 602320 609027 630470 638829 651700 656803 660580 701303 728039 731779 731785 736872 738486 750084 755942 756138 756752 779747 782462 782938 790463 790500 791928 800540 806991 826829 826832 827633 ] |
||||||||||||||||||||||||||||||
|
17.44 ms (4.64%) |
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 476704 701303 791928 800540 755942 756138 782462 728039 736872 738486 209216 402648 444540 450262 509996 440641 476051 473873 475319 434327 518892 443250 455914 476847 452876 609027 467877 441042 421518 416007 502765 555236 555771 656803 413098 448898 458527 483658 402634 429602 434339 434314 449022 439125 386707 826829 826832 468151 571386 559749 660580 602320 790463 806991 731779 731785 782938 790500 401806 481871 432335 443224 446225 476672 476699 469162 460382 476198 469086 545677 651700 569728 593053 630470 596402 468163 457814 432963 469139 458676 468244 469734 498200 510001 430350 414675 468665 449173 476674 440639 454688 529795 521559 571039 596478 756752 403215 417030 434306 439102 384463 88942 182110 827633 535367 638829 750084 779747 386077 476052 499924 182895 418135 434104 466360 452576 502770 469046 564040 570115 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.81%) |
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 88942 182110 182895 209216 384463 386077 386707 401806 402634 402648 403215 413098 414675 416007 417030 418135 421518 429602 430350 432335 432963 434104 434306 434314 434327 434339 439102 439125 440639 440641 441042 443224 443250 444540 446225 448898 449022 449173 450262 452576 452876 454688 455914 457814 458527 458676 460382 466360 467877 468151 468163 468244 468665 469046 469086 469139 469162 469734 473873 475319 476051 476052 476198 476672 476674 476699 476704 476847 481871 483658 498200 499924 502765 502770 509996 510001 518892 521559 529795 535367 545677 555236 555771 559749 564040 569728 570115 571039 571386 593053 596402 596478 602320 609027 630470 638829 651700 656803 660580 701303 728039 731779 731785 736872 738486 750084 755942 756138 756752 779747 782462 782938 790463 790500 791928 800540 806991 826829 826832 827633 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexmachine dildo"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сексмашин дилд"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.42%) |
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.