Query Metrics
7
Database Queries
7
Different statements
177.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.79 ms (86.71%) |
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 398500 413404 439417 458034 475415 475417 478523 478611 479838 483522 485283 486243 491126 494302 499885 499922 526902 541858 542163 544799 549538 549654 553130 566777 567057 585783 588169 603391 606493 631301 631325 631331 634109 651632 651863 660578 662856 663158 681804 692688 697834 697839 700682 700693 728268 738460 738475 738476 738481 738490 738515 739139 740929 742421 744227 745111 750623 752603 752711 758320 760471 762561 766294 766939 770258 773308 774842 774874 776994 777005 777921 779718 779749 779784 780019 780025 780038 780039 782417 782419 782487 782852 782855 782894 783020 783212 783214 783319 783733 785267 786023 787095 789803 790506 793962 796648 796678 796687 796993 800508 800532 800543 800792 803751 804939 805643 806466 806687 806861 807000 807142 807581 807584 807604 807660 808994 811705 812765 813219 819361 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (7.82%) |
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 804939 770258 738475 773308 738515 744227 776994 807581 813219 566777 588169 782487 782852 783020 779784 807584 789803 796687 800532 806687 807604 808994 758320 779749 780025 782417 783733 796648 796993 803751 478611 631331 413404 486243 542163 651863 553130 603391 774842 779718 787095 780019 780038 785267 800508 807000 752603 782419 782894 783319 766939 738476 738481 738490 760471 740929 742421 750623 631301 805643 439417 819361 485283 662856 697834 585783 782855 806466 811705 783214 762561 783212 790506 800543 807660 766294 800792 806861 475417 478523 681804 700682 634109 491126 651632 541858 692688 458034 499922 526902 549654 549538 663158 660578 700693 606493 780039 807142 738460 786023 793962 745111 752711 739139 728268 631325 774874 777005 777921 796678 812765 494302 398500 479838 483522 499885 475415 544799 697839 567057 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.39%) |
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 398500 413404 439417 458034 475415 475417 478523 478611 479838 483522 485283 486243 491126 494302 499885 499922 526902 541858 542163 544799 549538 549654 553130 566777 567057 585783 588169 603391 606493 631301 631325 631331 634109 651632 651863 660578 662856 663158 681804 692688 697834 697839 700682 700693 728268 738460 738475 738476 738481 738490 738515 739139 740929 742421 744227 745111 750623 752603 752711 758320 760471 762561 766294 766939 770258 773308 774842 774874 776994 777005 777921 779718 779749 779784 780019 780025 780038 780039 782417 782419 782487 782852 782855 782894 783020 783212 783214 783319 783733 785267 786023 787095 789803 790506 793962 796648 796678 796687 796993 800508 800532 800543 800792 803751 804939 805643 806466 806687 806861 807000 807142 807581 807584 807604 807660 808994 811705 812765 813219 819361 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск сексмашин"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade sexmachine"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск сексмашин"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
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.