Query Metrics
7
Database Queries
7
Different statements
157.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.02 ms (85.64%) |
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 81585 381979 401641 403823 535871 536132 537666 544034 553679 563384 595107 604900 610484 620552 626325 655602 660772 671472 696332 701192 701451 703986 714168 717149 723998 725445 727298 727562 728857 729069 729431 730078 731054 731834 734411 735391 736088 738358 738441 739989 742719 746187 746447 746580 746784 747532 747739 748000 748010 749171 752382 753172 753368 755364 755549 756271 756673 757602 758142 759040 760273 761207 761438 761447 761663 764367 764585 764691 765591 765596 766105 766483 767335 767518 767546 767684 767713 767766 768356 768370 768400 769179 769182 769334 769715 771282 771863 771943 772863 777026 777521 779698 781297 781317 793357 793564 794268 794587 795673 796024 796064 797134 797286 797899 802179 802265 802307 802560 802942 803419 803448 803862 803943 808258 808448 810001 810560 810993 813479 ] |
||||||||||||||||||||||||||||||
|
11.22 ms (7.12%) |
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 796064 797134 797899 802179 802265 802307 802560 810560 723998 725445 729431 734411 739989 753172 761663 767546 771282 771943 772863 781297 781317 793357 793564 794587 803862 803943 808448 813479 731054 731834 735391 746187 747739 748000 748010 753368 756271 757602 759040 760273 766483 767713 767766 768400 769182 769334 769902 727562 736088 746580 756673 758142 764367 764585 765591 765596 766105 767684 769715 729069 738441 749171 752382 755364 755549 761207 768356 768370 769179 771863 727298 728857 738358 742719 746784 747532 761438 761447 764691 767335 767518 701192 701451 703986 714168 717149 777026 777521 779698 794268 797286 802942 803419 803448 808258 810001 810993 403823 544034 746447 563384 381979 81585 401641 535871 536132 537666 553679 696332 671472 655602 660772 595107 604900 610484 620552 626325 795673 796024 730078 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (2.29%) |
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 81585 381979 401641 403823 535871 536132 537666 544034 553679 563384 595107 604900 610484 620552 626325 655602 660772 671472 696332 701192 701451 703986 714168 717149 723998 725445 727298 727562 728857 729069 729431 730078 731054 731834 734411 735391 736088 738358 738441 739989 742719 746187 746447 746580 746784 747532 747739 748000 748010 749171 752382 753172 753368 755364 755549 756271 756673 757602 758142 759040 760273 761207 761438 761447 761663 764367 764585 764691 765591 765596 766105 766483 767335 767518 767546 767684 767713 767766 768356 768370 768400 769179 769182 769334 769715 771282 771863 771943 772863 777026 777521 779698 781297 781317 793357 793564 794268 794587 795673 796024 796064 797134 797286 797899 802179 802265 802307 802560 802942 803419 803448 803862 803943 808258 808448 810001 810560 810993 813479 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot сперм"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot sperm"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot сперм"
]
|
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.