Query Metrics
7
Database Queries
7
Different statements
187.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.84 ms (85.19%) |
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 65811 109233 264846 280512 385783 409984 414340 419850 428383 428469 438029 440274 440747 454504 458962 461244 465435 466551 469153 479724 480515 482207 488984 494279 495499 496115 513136 513202 517486 519600 521447 523972 530403 533055 533179 533617 533635 533675 533778 534691 535410 537722 537759 540113 541173 541906 542623 543589 543752 543955 545152 546307 550039 555388 558971 565826 566798 573916 574630 575004 575029 575278 579003 584980 594872 622472 622681 628656 637765 641444 648659 649119 655548 667230 669196 670839 672417 685527 695671 698784 698994 701204 703498 704351 707281 709552 710405 736489 736531 744551 754212 760863 765534 768017 774050 789078 795913 798169 804323 812285 814277 814540 816987 817375 817424 817776 818646 819027 819066 819081 819804 819904 823592 827860 828070 828215 828219 828257 828326 828332 ] |
||||||||||||||||||||||||||||||
|
15.12 ms (8.06%) |
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 707281 594872 641444 798169 789078 736531 760863 765534 768017 804323 465435 409984 414340 428383 533179 565826 701204 667230 685527 695671 575278 795913 736489 774050 622472 519600 670839 440274 461244 488984 428469 812285 744551 703498 698784 545152 480515 495499 698994 438029 109233 458962 523972 466551 535410 385783 469153 542623 704351 814277 814540 543589 709552 669196 754212 419850 672417 622681 710405 494279 513202 555388 280512 440747 584980 521447 574630 628656 637765 454504 482207 513136 496115 264846 65811 817375 819904 816987 817776 819027 819804 823592 818646 819066 819081 817424 828219 827860 828257 828326 828332 828215 828070 479724 530403 533617 533635 533778 534691 533055 533675 537722 537759 517486 540113 558971 573916 575029 541173 543752 546307 550039 541906 543955 566798 575004 579003 648659 649119 655548 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.21%) |
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 65811 109233 264846 280512 385783 409984 414340 419850 428383 428469 438029 440274 440747 454504 458962 461244 465435 466551 469153 479724 480515 482207 488984 494279 495499 496115 513136 513202 517486 519600 521447 523972 530403 533055 533179 533617 533635 533675 533778 534691 535410 537722 537759 540113 541173 541906 542623 543589 543752 543955 545152 546307 550039 555388 558971 565826 566798 573916 574630 575004 575029 575278 579003 584980 594872 622472 622681 628656 637765 641444 648659 649119 655548 667230 669196 670839 672417 685527 695671 698784 698994 701204 703498 704351 707281 709552 710405 736489 736531 744551 754212 760863 765534 768017 774050 789078 795913 798169 804323 812285 814277 814540 816987 817375 817424 817776 818646 819027 819066 819081 819804 819904 823592 827860 828070 828215 828219 828257 828326 828332 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass public"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.