Query Metrics
7
Database Queries
7
Different statements
368.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
341.16 ms (92.55%) |
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 68560 393127 398010 399142 399223 400019 400114 400815 407157 409613 410590 416155 417949 418658 426990 432049 441854 444370 460488 461103 469857 474884 474963 475734 482873 483951 485211 485862 488239 491625 496066 506010 509329 511213 515899 523490 524164 525762 528120 531075 541245 542972 548262 548295 550284 550342 550555 553082 555944 557422 560360 560411 570711 571283 578451 585758 591819 593095 596629 597567 599339 629104 634717 637690 643573 653265 654443 661298 665622 676328 682877 684201 690154 695123 704241 706785 707881 718089 720701 721368 722638 725144 735420 738912 739155 746539 754253 756347 756766 759417 760137 761320 768947 771571 773319 777870 779573 784545 784585 785004 785103 788827 788856 791186 791250 791279 791584 791688 792767 794398 798823 802783 805189 806176 808988 811668 813482 819390 821829 825570 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (4.70%) |
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 794398 759417 735420 754253 756766 756347 785103 806176 400815 426990 444370 511213 515899 483951 661298 676328 721368 555944 597567 637690 791250 788827 725144 798823 739155 416155 475734 524164 791584 599339 491625 496066 542972 578451 821829 560360 557422 553082 707881 629104 808988 720701 400114 407157 399142 393127 488239 695123 399223 418658 460488 485211 550342 550555 570711 560411 690154 550284 585758 596629 591819 593095 738912 792767 410590 474963 68560 400019 441854 474884 509329 528120 525762 541245 825570 819390 461103 523490 548262 571283 653265 722638 654443 704241 706785 634717 777870 802783 784545 788856 811668 813482 760137 761320 768947 398010 432049 409613 417949 469857 531075 506010 482873 485862 548295 682877 665622 684201 718089 643573 791186 791688 805189 779573 785004 791279 773319 784585 746539 771571 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (0.80%) |
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 68560 393127 398010 399142 399223 400019 400114 400815 407157 409613 410590 416155 417949 418658 426990 432049 441854 444370 460488 461103 469857 474884 474963 475734 482873 483951 485211 485862 488239 491625 496066 506010 509329 511213 515899 523490 524164 525762 528120 531075 541245 542972 548262 548295 550284 550342 550555 553082 555944 557422 560360 560411 570711 571283 578451 585758 591819 593095 596629 597567 599339 629104 634717 637690 643573 653265 654443 661298 665622 676328 682877 684201 690154 695123 704241 706785 707881 718089 720701 721368 722638 725144 735420 738912 739155 746539 754253 756347 756766 759417 760137 761320 768947 771571 773319 777870 779573 784545 784585 785004 785103 788827 788856 791186 791250 791279 791584 791688 792767 794398 798823 802783 805189 806176 808988 811668 813482 819390 821829 825570 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie girl beauty"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie девушк beauty"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie девушк beauty"
]
|
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.