Query Metrics
7
Database Queries
7
Different statements
368.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.27 ms (56.86%) |
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 383201 390157 398038 412330 412525 418458 423950 426696 426796 427656 434076 434133 435324 441041 444187 447138 450077 451863 456312 459472 459474 459485 460335 461787 465579 466909 467650 469096 472181 473129 475209 480788 482641 495172 496713 499302 504553 511053 512997 514250 514859 515665 522231 523590 528223 529866 531873 533572 535003 540075 540127 547962 553753 554110 554698 554708 554711 554735 556596 558683 558910 559970 561954 563977 566902 568107 574077 579487 580136 581428 583084 584037 584315 585220 592604 594820 597545 598000 598136 600668 601185 604634 613358 614578 615329 622592 626037 636172 641298 649447 651008 652986 653691 657791 661028 666914 670939 673935 678966 680815 687778 697878 708320 715621 740326 744231 756752 759123 769434 777668 784001 808591 812374 816837 817871 819811 820847 824479 825824 826321 ] |
||||||||||||||||||||||||||||||
|
138.49 ms (37.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 383201 390157 398038 412330 412525 418458 423950 426696 426796 427656 434076 434133 435324 441041 444187 447138 450077 451863 456312 459472 459474 459485 460335 461787 465579 466909 467650 469096 472181 473129 475209 480788 482641 495172 496713 499302 504553 511053 512997 514250 514859 515665 522231 523590 528223 529866 531873 533572 535003 540075 540127 547962 553753 554110 554698 554708 554711 554735 556596 558683 558910 559970 561954 563977 566902 568107 574077 579487 580136 581428 583084 584037 584315 585220 592604 594820 597545 598000 598136 600668 601185 604634 613358 614578 615329 622592 626037 636172 641298 649447 651008 652986 653691 657791 661028 666914 670939 673935 678966 680815 687778 697878 708320 715621 740326 744231 756752 759123 769434 777668 784001 808591 812374 816837 817871 819811 820847 824479 825824 826321 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (3.52%) |
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 777668 784001 808591 812374 423950 465579 467650 451863 511053 398038 412330 427656 441041 434076 482641 466909 522231 512997 514250 528223 531873 515665 469096 568107 547962 554110 579487 583084 584037 584315 678966 680815 657791 554711 556596 558683 580136 581428 597545 613358 604634 626037 585220 592604 594820 598000 622592 598136 601185 756752 426696 426796 390157 435324 447138 459472 459474 460335 480788 434133 450077 461787 412525 418458 444187 456312 473129 475209 459485 514859 499302 504553 495172 472181 523590 561954 383201 817871 820847 816837 819811 824479 825824 826321 496713 529866 540127 533572 540075 535003 554698 554735 566902 553753 574077 554708 558910 563977 651008 652986 653691 666914 697878 661028 670939 687778 649447 673935 708320 715621 559970 600668 641298 636172 614578 615329 740326 744231 759123 769434 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло ван"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo in bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.44%) |
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.