Query Metrics
7
Database Queries
7
Different statements
185.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.51 ms (87.74%) |
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 197 15317 76150 91473 185428 338807 384297 391880 393350 395185 396356 398239 401537 401540 403086 423436 459735 518182 522636 533335 533363 545136 546415 575341 579464 595022 603262 612146 621280 624650 635521 635742 644338 647817 648538 649580 653530 654455 663315 675607 683970 695123 722159 722219 730183 730634 733473 734869 736165 740598 740784 746303 755407 758121 762522 764622 766221 766863 767290 767834 768263 769194 775147 775474 776046 776230 777034 778174 778764 779195 779819 781086 781160 783089 783372 785782 786680 789581 791239 791831 792433 794896 795463 795860 796344 796909 797024 797159 797564 799517 800452 801622 802584 803439 803914 807720 810318 810334 810371 813611 814558 817007 817301 817441 818233 818766 819024 819264 819403 819404 820192 823167 823842 824069 824943 825472 826265 826572 826888 827383 ] |
||||||||||||||||||||||||||||||
|
13.19 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 766221 612146 775474 778174 781086 785782 786680 802584 91473 384297 824943 823167 733473 197 401540 823842 824069 533335 575341 647817 644338 621280 781160 797564 769194 796909 797024 797159 810371 695123 817441 813611 817301 827383 579464 653530 683970 663315 775147 778764 791831 803439 736165 767834 762522 767290 779819 799517 810334 533363 401537 403086 817007 819404 820192 826888 825472 819264 654455 722159 649580 624650 740598 740784 768263 783372 755407 758121 766863 730634 764622 779195 789581 794896 801622 423436 76150 185428 393350 395185 391880 338807 15317 396356 398239 818766 819403 826572 826265 814558 819024 818233 459735 518182 522636 546415 545136 675607 722219 648538 635521 595022 603262 635742 776230 783089 795463 796344 810318 776046 777034 791239 795860 800452 734869 746303 792433 803914 807720 730183 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.61%) |
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 197 15317 76150 91473 185428 338807 384297 391880 393350 395185 396356 398239 401537 401540 403086 423436 459735 518182 522636 533335 533363 545136 546415 575341 579464 595022 603262 612146 621280 624650 635521 635742 644338 647817 648538 649580 653530 654455 663315 675607 683970 695123 722159 722219 730183 730634 733473 734869 736165 740598 740784 746303 755407 758121 762522 764622 766221 766863 767290 767834 768263 769194 775147 775474 776046 776230 777034 778174 778764 779195 779819 781086 781160 783089 783372 785782 786680 789581 791239 791831 792433 794896 795463 795860 796344 796909 797024 797159 797564 799517 800452 801622 802584 803439 803914 807720 810318 810334 810371 813611 814558 817007 817301 817441 818233 818766 819024 819264 819403 819404 820192 823167 823842 824069 824943 825472 826265 826572 826888 827383 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie fuck"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie секс"
]
|
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.