Query Metrics
7
Database Queries
7
Different statements
201.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.82 ms (88.07%) |
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 383448 399077 407141 422089 425641 425916 427281 427307 432641 432710 433067 433867 433925 434422 434750 435785 436948 441850 452450 456493 462180 462868 467022 474442 478330 478406 483969 485818 498340 503408 509189 515240 524988 527321 528569 529136 532985 539213 546578 555253 560275 560288 564999 568654 577250 583456 588018 591086 593557 595071 606511 606641 608037 612932 615014 616888 619650 629665 632405 633483 646270 651344 653047 663754 678992 702010 711672 713038 713580 717089 721854 724518 724734 725301 726960 727239 729337 731211 734324 738358 739912 739963 746143 752857 753729 756349 756842 760679 760863 765755 770749 770810 771332 777026 779628 781065 781283 784338 784461 785169 786414 787221 787312 789936 793613 793741 793835 795062 795136 796020 796154 796158 798507 799886 800344 803599 810147 810787 811390 813310 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (7.37%) |
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 711672 713038 591086 606511 616888 612932 779628 784338 793741 796154 796158 798507 781065 786414 793613 799886 810147 813310 725301 739912 746143 756842 770810 787221 787312 795062 811390 752857 756349 760863 724518 739963 753729 765755 727239 731211 760679 770749 632405 789936 407141 717089 702010 606641 784461 796020 785169 738358 777026 503408 568654 577250 546578 588018 793835 724734 734324 478330 524988 483969 509189 399077 434422 456493 528569 515240 595071 633483 615014 800344 781283 803599 795136 427281 433867 441850 383448 435785 434750 427307 432710 433067 498340 560288 583456 564999 646270 651344 678992 593557 619650 629665 810787 729337 771332 726960 608037 721854 422089 433925 478406 462868 436948 462180 425641 425916 432641 452450 474442 485818 539213 527321 529136 532985 467022 560275 555253 653047 663754 713580 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.43%) |
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 383448 399077 407141 422089 425641 425916 427281 427307 432641 432710 433067 433867 433925 434422 434750 435785 436948 441850 452450 456493 462180 462868 467022 474442 478330 478406 483969 485818 498340 503408 509189 515240 524988 527321 528569 529136 532985 539213 546578 555253 560275 560288 564999 568654 577250 583456 588018 591086 593557 595071 606511 606641 608037 612932 615014 616888 619650 629665 632405 633483 646270 651344 653047 663754 678992 702010 711672 713038 713580 717089 721854 724518 724734 725301 726960 727239 729337 731211 734324 738358 739912 739963 746143 752857 753729 756349 756842 760679 760863 765755 770749 770810 771332 777026 779628 781065 781283 784338 784461 785169 786414 787221 787312 789936 793613 793741 793835 795062 795136 796020 796154 796158 798507 799886 800344 803599 810147 810787 811390 813310 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.66%) |
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.