Query Metrics
7
Database Queries
7
Different statements
165.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.06 ms (85.16%) |
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 390667 402625 405054 413263 413833 414358 415303 416820 421172 424751 425503 432766 435624 441095 441985 443407 445689 446108 447454 451663 452010 452787 453346 455847 458017 458115 464594 465337 475848 475915 477593 482936 484735 486516 486746 492839 493122 494513 495812 498294 501440 502775 504174 508175 508848 509552 510270 510801 514660 515494 515897 516319 516491 517012 519316 522568 531195 531908 532263 533011 533044 533521 537186 539159 539174 540564 541781 541925 544800 544854 545505 548666 550327 556882 558418 565273 568045 576632 577357 581132 582767 590241 597236 600256 604142 605305 628649 631948 632586 633133 634774 637680 637746 641671 641956 642742 647307 647938 651038 679092 679772 689498 719104 721226 722871 728035 730461 746995 748256 756398 784907 796877 801418 801952 807914 811690 814505 819506 820762 820775 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (9.36%) |
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 637680 597236 632586 801952 756398 801418 421172 446108 515897 819506 519316 537186 539159 532263 556882 576632 577357 647938 719104 550327 590241 637746 642742 784907 748256 728035 746995 458017 447454 504174 508175 641956 402625 516491 510801 820775 533521 533044 679772 730461 631948 455847 502775 425503 441095 492839 544854 582767 501440 514660 441985 432766 452787 458115 545505 581132 628649 811690 796877 498294 415303 689498 495812 508848 464594 568045 634774 424751 493122 390667 413263 453346 451663 509552 548666 641671 722871 522568 482936 452010 477593 517012 531908 465337 558418 565273 604142 443407 413833 515494 486516 820762 544800 647307 405054 416820 475915 516319 539174 540564 531195 533011 475848 541925 541781 651038 679092 721226 600256 633133 605305 807914 484735 510270 414358 435624 814505 445689 486746 494513 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.36%) |
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 390667 402625 405054 413263 413833 414358 415303 416820 421172 424751 425503 432766 435624 441095 441985 443407 445689 446108 447454 451663 452010 452787 453346 455847 458017 458115 464594 465337 475848 475915 477593 482936 484735 486516 486746 492839 493122 494513 495812 498294 501440 502775 504174 508175 508848 509552 510270 510801 514660 515494 515897 516319 516491 517012 519316 522568 531195 531908 532263 533011 533044 533521 537186 539159 539174 540564 541781 541925 544800 544854 545505 548666 550327 556882 558418 565273 568045 576632 577357 581132 582767 590241 597236 600256 604142 605305 628649 631948 632586 633133 634774 637680 637746 641671 641956 642742 647307 647938 651038 679092 679772 689498 719104 721226 722871 728035 730461 746995 748256 756398 784907 796877 801418 801952 807914 811690 814505 819506 820762 820775 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double fuck pussy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double секс pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double секс 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.