Query Metrics
7
Database Queries
7
Different statements
147.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.43 ms (85.62%) |
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 65811 154707 397685 398198 414103 419167 419435 419461 423508 436054 440659 445651 446994 448351 457650 463435 468236 477052 485471 487281 502789 507270 519379 534426 535290 537138 537766 541265 542124 544829 545550 548153 551646 554405 556183 557709 559783 560026 573293 576888 583093 585818 586100 586995 589526 594053 597663 602241 608550 618259 618799 620957 621382 622427 635129 638744 640306 641807 650150 654978 660419 666856 669046 670956 671531 680578 684487 686338 688367 689010 697108 705378 706894 707432 709674 714294 735535 739084 739804 740858 744028 744963 745066 745927 752614 756779 758318 765712 766415 769029 772272 776011 777760 777838 778779 780151 780185 780339 781373 782104 784035 784199 787815 789234 790412 791871 796332 796685 796992 796996 803367 806819 807122 807590 809686 810752 812399 824256 824573 826237 ] |
||||||||||||||||||||||||||||||
|
12.11 ms (8.20%) |
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 419435 446994 440659 65811 824256 824573 744028 398198 414103 419167 436054 445651 457650 485471 448351 537766 548153 709674 660419 641807 608550 638744 807590 766415 765712 707432 826237 535290 534426 560026 576888 650150 686338 714294 671531 680578 684487 688367 654978 706894 589526 597663 620957 621382 640306 586100 618259 777760 780339 787815 803367 807122 810752 812399 777838 780151 796332 796685 796992 796996 740858 772272 789234 809686 745066 735535 739084 739804 744963 745927 756779 758318 769029 622427 635129 697108 705378 776011 778779 780185 781373 782104 784035 784199 790412 791871 806819 397685 507270 689010 154707 419461 423508 477052 487281 468236 502789 519379 537138 542124 544829 554405 545550 556183 573293 541265 551646 559783 669046 666856 670956 557709 583093 602241 594053 585818 618799 586995 752614 463435 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.90%) |
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 65811 154707 397685 398198 414103 419167 419435 419461 423508 436054 440659 445651 446994 448351 457650 463435 468236 477052 485471 487281 502789 507270 519379 534426 535290 537138 537766 541265 542124 544829 545550 548153 551646 554405 556183 557709 559783 560026 573293 576888 583093 585818 586100 586995 589526 594053 597663 602241 608550 618259 618799 620957 621382 622427 635129 638744 640306 641807 650150 654978 660419 666856 669046 670956 671531 680578 684487 686338 688367 689010 697108 705378 706894 707432 709674 714294 735535 739084 739804 740858 744028 744963 745066 745927 752614 756779 758318 765712 766415 769029 772272 776011 777760 777838 778779 780151 780185 780339 781373 782104 784035 784199 787815 789234 790412 791871 796332 796685 796992 796996 803367 806819 807122 807590 809686 810752 812399 824256 824573 826237 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд pussy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo pussy"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд pussy"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.91%) |
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.