Query Metrics
7
Database Queries
7
Different statements
403.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.02 ms (51.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old russian"
]
|
||||||||||||||||||||||||||||||
|
173.49 ms (42.98%) |
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 66907 366010 381882 383483 385999 387422 389351 391653 392489 392601 395927 397894 397911 398933 400481 400823 400999 402547 403315 403317 404267 409346 411330 424023 424416 424423 424468 428833 438486 439334 439580 443719 443740 456365 456679 461973 462117 462706 467767 474123 476338 478016 480856 482508 484452 486896 509451 518849 542957 543825 546934 546977 549762 549766 555793 556847 558002 558049 558052 559059 560390 560394 562978 563200 563205 563209 563222 563434 563435 564139 567407 567433 569291 572766 582306 582546 588998 597561 598683 599527 611813 612512 617440 655417 658065 659693 714504 725914 728351 733254 735594 735982 736258 738310 740494 741029 744507 744508 745760 746048 746229 747476 749896 749940 753815 757982 758033 766043 769766 777186 779523 781669 782148 785490 788098 789202 789401 789829 805650 827776 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (4.02%) |
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 789202 789401 736258 738310 741029 749940 757982 725914 728351 740494 744508 745760 746229 753815 758033 769766 735594 744507 766043 733254 735982 746048 747476 749896 617440 714504 777186 779523 781669 782148 785490 788098 789829 805650 392489 387422 395927 402547 456679 385999 438486 598683 66907 400823 439580 439334 827776 482508 456365 484452 486896 467767 474123 509451 518849 543825 546934 546977 558049 560390 560394 562978 567433 582306 542957 549766 559059 563200 563205 563209 572766 582546 549762 558002 558052 564139 567407 569291 659693 658065 655417 555793 556847 563222 563434 563435 611813 612512 599527 588998 597561 381882 391653 397911 400999 403315 424023 424416 424423 424468 428833 443719 443740 461973 462117 462706 476338 478016 480856 366010 383483 389351 392601 397894 398933 400481 403317 404267 409346 411330 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.67%) |
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 66907 366010 381882 383483 385999 387422 389351 391653 392489 392601 395927 397894 397911 398933 400481 400823 400999 402547 403315 403317 404267 409346 411330 424023 424416 424423 424468 428833 438486 439334 439580 443719 443740 456365 456679 461973 462117 462706 467767 474123 476338 478016 480856 482508 484452 486896 509451 518849 542957 543825 546934 546977 549762 549766 555793 556847 558002 558049 558052 559059 560390 560394 562978 563200 563205 563209 563222 563434 563435 564139 567407 567433 569291 572766 582306 582546 588998 597561 598683 599527 611813 612512 617440 655417 658065 659693 714504 725914 728351 733254 735594 735982 736258 738310 740494 741029 744507 744508 745760 746048 746229 747476 749896 749940 753815 757982 758033 766043 769766 777186 779523 781669 782148 785490 788098 789202 789401 789829 805650 827776 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old русск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.