Query Metrics
7
Database Queries
7
Different statements
187.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.81 ms (85.68%) |
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 31134 188129 188379 193761 205655 233610 331209 358481 382549 383119 386191 387198 387965 389098 391237 395596 395908 395925 397174 397811 398570 400865 401807 403317 405437 407191 407636 410182 411468 412289 419517 419518 425052 426434 439643 439745 454187 457829 457991 460175 460190 460745 460918 462204 463177 466164 466173 466244 466272 466945 467124 467248 469336 471417 474471 477415 479112 481124 482296 486542 494682 515923 522486 531523 532126 532825 533022 534336 543694 547605 551891 554848 557572 561586 563444 585158 590533 591285 598382 619116 626024 645934 663504 678491 696415 702955 703902 709183 709982 712337 712652 712674 718497 733817 740097 742892 744292 770115 770118 774763 774766 782199 782230 782265 785872 789016 789510 793529 799361 804221 806341 807380 807732 808866 815722 817308 817724 820726 823688 828597 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (8.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 426434 439643 411468 397811 815722 696415 188129 403317 454187 358481 391237 383119 709183 709982 744292 789510 205655 331209 31134 387965 387198 397174 405437 407191 410182 407636 474471 477415 532126 532825 645934 678491 712652 598382 590533 619116 799361 807732 770115 742892 740097 712337 712674 806341 233610 193761 386191 770118 457991 471417 460175 460190 481124 466164 389098 460918 466244 479112 466173 626024 412289 515923 817308 533022 774763 793529 808866 774766 395925 395908 823688 820726 543694 561586 702955 663504 551891 554848 782199 789016 804221 807380 782230 733817 398570 382549 467248 563444 400865 460745 395596 419518 419517 439745 463177 425052 466272 494682 817724 828597 718497 785872 782265 482296 462204 466945 469336 591285 188379 401807 467124 457829 486542 534336 531523 522486 547605 557572 703902 585158 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.63%) |
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 31134 188129 188379 193761 205655 233610 331209 358481 382549 383119 386191 387198 387965 389098 391237 395596 395908 395925 397174 397811 398570 400865 401807 403317 405437 407191 407636 410182 411468 412289 419517 419518 425052 426434 439643 439745 454187 457829 457991 460175 460190 460745 460918 462204 463177 466164 466173 466244 466272 466945 467124 467248 469336 471417 474471 477415 479112 481124 482296 486542 494682 515923 522486 531523 532126 532825 533022 534336 543694 547605 551891 554848 557572 561586 563444 585158 590533 591285 598382 619116 626024 645934 663504 678491 696415 702955 703902 709183 709982 712337 712652 712674 718497 733817 740097 742892 744292 770115 770118 774763 774766 782199 782230 782265 785872 789016 789510 793529 799361 804221 806341 807380 807732 808866 815722 817308 817724 820726 823688 828597 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mother"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мам женщин"
]
|
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.