Query Metrics
7
Database Queries
7
Different statements
260.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
232.66 ms (89.24%) |
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 31503 117596 214602 335993 382770 383296 386965 388796 389517 389911 393267 393462 393550 396371 397791 401520 402625 403754 412237 430290 476073 479277 481903 498449 515364 517658 523381 524799 524802 529922 531742 536111 536131 540593 541043 541064 546160 546283 548153 548448 550800 556881 556888 556909 556917 557635 562575 573187 575378 575636 576439 577059 580109 586375 587851 592576 592655 599559 615357 618228 618238 627472 629725 636628 639371 642134 643191 648696 654188 664671 672913 672937 680593 689359 689524 704990 709397 712097 712801 713885 722394 723998 725602 734839 735160 735743 739101 740624 740699 744412 744980 746191 748648 756505 766398 766591 768219 778220 785075 786876 788185 789883 792341 792710 792724 795052 796339 796837 796857 796878 800293 800749 801621 811914 825376 827878 827944 827947 827963 827981 ] |
||||||||||||||||||||||||||||||
|
18.27 ms (7.01%) |
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 117596 393267 386965 825376 536111 517658 529922 580109 548448 562575 573187 704990 722394 577059 629725 796837 800749 740699 785075 795052 796857 801621 739101 744980 746191 735160 389517 393462 393550 430290 479277 515364 556888 556881 556909 587851 599559 401520 680593 689524 723998 792341 402625 523381 548153 557635 713885 800293 786876 382770 383296 214602 388796 476073 481903 524802 556917 592576 627472 796339 403754 396371 335993 31503 389911 397791 412237 827947 827878 827981 827944 827963 531742 536131 540593 524799 498449 546283 575636 576439 575378 541043 541064 689359 712097 648696 712801 654188 664671 672913 672937 709397 546160 550800 618238 636628 642134 643191 618228 639371 586375 615357 592655 789883 778220 788185 792724 796878 811914 734839 744412 768219 792710 735743 756505 748648 766591 725602 740624 766398 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (0.94%) |
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 31503 117596 214602 335993 382770 383296 386965 388796 389517 389911 393267 393462 393550 396371 397791 401520 402625 403754 412237 430290 476073 479277 481903 498449 515364 517658 523381 524799 524802 529922 531742 536111 536131 540593 541043 541064 546160 546283 548153 548448 550800 556881 556888 556909 556917 557635 562575 573187 575378 575636 576439 577059 580109 586375 587851 592576 592655 599559 615357 618228 618238 627472 629725 636628 639371 642134 643191 648696 654188 664671 672913 672937 680593 689359 689524 704990 709397 712097 712801 713885 722394 723998 725602 734839 735160 735743 739101 740624 740699 744412 744980 746191 748648 756505 766398 766591 768219 778220 785075 786876 788185 789883 792341 792710 792724 795052 796339 796837 796857 796878 800293 800749 801621 811914 825376 827878 827944 827947 827963 827981 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy extreme"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy хардкор"
]
|
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.