Query Metrics
7
Database Queries
7
Different statements
151.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.56 ms (83.63%) |
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 55266 383700 383912 384581 395556 396954 396956 397894 400888 407187 407684 413128 414022 417662 422484 424276 428454 428463 428539 428807 428822 429584 429824 433681 435931 437322 437352 437361 439569 439727 440645 443166 445709 446276 446299 448166 448707 448958 450995 451165 454040 454048 457191 457200 457298 460154 460195 460679 464389 464805 465545 466709 476337 477110 492304 493168 495394 506136 513143 513728 518938 519929 521473 523031 523779 524260 525149 525469 525551 526449 526728 530409 531995 532060 532127 550642 550643 550644 551035 563454 568367 582197 593598 602707 606619 608415 640941 659197 671862 684308 688083 695087 701247 702312 704174 709503 716324 717797 719443 720602 724502 726588 726831 728291 736393 743479 748892 749773 756863 758443 781824 782503 786216 793930 797632 813752 813918 813920 823803 826592 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (10.25%) |
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 525469 813920 451165 550642 396954 414022 407187 813752 454040 513143 524260 530409 525149 525551 551035 563454 702312 593598 786216 724502 726588 748892 756863 758443 793930 428454 384581 429584 422484 493168 526449 568367 728291 440645 523779 519929 513728 439727 782503 445709 448958 464805 608415 640941 797632 448707 526728 383700 383912 55266 396956 417662 428807 407684 429824 813918 823803 446276 454048 448166 492304 495394 531995 532060 550644 582197 659197 671862 695087 719443 701247 704174 717797 606619 602707 781824 726831 743479 736393 749773 709503 716324 720602 428822 437322 413128 395556 400888 428539 439569 433681 435931 437361 437352 826592 446299 457200 460679 457298 450995 460154 466709 476337 532127 506136 460195 464389 550643 684308 688083 428463 443166 465545 397894 457191 424276 477110 521473 518938 523031 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.93%) |
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 55266 383700 383912 384581 395556 396954 396956 397894 400888 407187 407684 413128 414022 417662 422484 424276 428454 428463 428539 428807 428822 429584 429824 433681 435931 437322 437352 437361 439569 439727 440645 443166 445709 446276 446299 448166 448707 448958 450995 451165 454040 454048 457191 457200 457298 460154 460195 460679 464389 464805 465545 466709 476337 477110 492304 493168 495394 506136 513143 513728 518938 519929 521473 523031 523779 524260 525149 525469 525551 526449 526728 530409 531995 532060 532127 550642 550643 550644 551035 563454 568367 582197 593598 602707 606619 608415 640941 659197 671862 684308 688083 695087 701247 702312 704174 709503 716324 717797 719443 720602 724502 726588 726831 728291 736393 743479 748892 749773 756863 758443 781824 782503 786216 793930 797632 813752 813918 813920 823803 826592 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom ass son"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom жоп son"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom жоп son"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.86%) |
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.