Query Metrics
7
Database Queries
7
Different statements
176.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.88 ms (86.43%) |
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 65760 89199 154240 154535 155198 346141 382960 382993 383869 383920 387394 392839 395252 398073 398095 398113 401178 403288 408885 408911 415859 416173 416527 416531 416537 416575 416690 419834 423927 428366 432933 435593 442337 444531 445968 449921 469087 476710 477759 480502 482293 499930 499931 506119 508939 514215 514257 514879 515441 526902 529128 529713 529714 531583 533717 534529 534535 535651 538253 538510 540945 541128 541421 544143 545422 545453 547464 547476 547890 550708 550884 580193 622720 642013 736337 738822 739154 739805 740926 742303 743947 744021 744795 745083 745086 745128 746177 748287 748491 749067 749084 749221 749700 752617 752627 752637 752652 752675 752686 752710 752712 752713 752784 761621 766943 769148 770254 770262 771887 784985 785073 788521 794213 801629 801643 804417 806928 810635 811765 814151 ] |
||||||||||||||||||||||||||||||
|
13.61 ms (7.69%) |
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 806928 811765 739154 749067 749221 749700 752652 752675 752710 752712 752713 761621 766943 770262 738822 742303 745086 746177 749084 752686 752784 769148 771887 743947 744021 744795 745083 745128 748491 770254 736337 740926 748287 752617 752627 752637 622720 642013 785073 788521 794213 801629 801643 804417 810635 403288 392839 435593 398073 65760 154535 395252 538510 401178 415859 408885 444531 477759 499931 547890 550884 482293 432933 506119 784985 739805 383920 382960 382993 383869 154240 155198 346141 89199 387394 398113 398095 416173 423927 416527 416531 416575 408911 416537 416690 419834 428366 442337 814151 445968 480502 449921 476710 499930 508939 514215 515441 531583 514257 529128 529713 534529 514879 538253 526902 529714 533717 534535 535651 469087 545453 547464 547476 550708 541128 541421 580193 540945 544143 545422 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.64%) |
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 65760 89199 154240 154535 155198 346141 382960 382993 383869 383920 387394 392839 395252 398073 398095 398113 401178 403288 408885 408911 415859 416173 416527 416531 416537 416575 416690 419834 423927 428366 432933 435593 442337 444531 445968 449921 469087 476710 477759 480502 482293 499930 499931 506119 508939 514215 514257 514879 515441 526902 529128 529713 529714 531583 533717 534529 534535 535651 538253 538510 540945 541128 541421 544143 545422 545453 547464 547476 547890 550708 550884 580193 622720 642013 736337 738822 739154 739805 740926 742303 743947 744021 744795 745083 745086 745128 746177 748287 748491 749067 749084 749221 749700 752617 752627 752637 752652 752675 752686 752710 752712 752713 752784 761621 766943 769148 770254 770262 771887 784985 785073 788521 794213 801629 801643 804417 806928 810635 811765 814151 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор соло"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme solo"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор соло"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
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.