Query Metrics
7
Database Queries
7
Different statements
239.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.74 ms (89.91%) |
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 438503 454163 461163 490463 501104 514227 517400 528515 532219 534887 544397 552137 553319 555276 556078 584788 587574 588506 592180 595530 599535 600399 602334 606272 606527 608779 614835 615390 616136 618479 625369 631056 634973 635391 636210 638751 639181 644075 659065 659195 659933 660984 661455 680432 680820 689572 691688 693898 697589 697657 699602 701601 705729 707766 712346 715573 718822 719927 720996 728258 730843 734175 735594 736982 740863 741365 746605 746799 749391 751430 752293 757434 758757 758942 760407 761755 764339 768965 769952 772247 772739 773354 774684 776972 781063 782441 783449 783490 784846 785225 785233 786820 787521 787574 790449 790605 791117 791129 791964 793005 793095 794168 794433 794532 794754 794799 794966 795848 796584 798313 801802 802954 804930 805530 806284 806291 807197 809202 811233 ] |
||||||||||||||||||||||||||||||
|
13.81 ms (5.76%) |
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 793005 796584 728258 746605 772247 772739 790605 794168 794433 794532 794754 798313 804930 807197 809202 811233 769952 773354 735594 749391 758942 761755 602334 606527 631056 707766 461163 438503 532219 501104 514227 517400 534887 584788 659065 659933 661455 689572 697657 715573 691688 719927 720996 592180 608779 616136 636210 634973 600399 606272 638751 639181 774684 783449 783490 784846 785225 790449 791964 801802 794799 734175 751430 752293 758757 760407 741365 746799 764339 768965 635391 699602 776972 781063 786820 787521 787574 802954 490463 454163 528515 544397 552137 555276 556078 553319 718822 660984 680820 693898 701601 705729 659195 680432 697589 712346 618479 587574 588506 614835 615390 644075 625369 595530 599535 627449 791129 794966 782441 785233 793095 795848 806284 740863 757434 791117 805530 806291 730843 736982 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.13%) |
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 438503 454163 461163 490463 501104 514227 517400 528515 532219 534887 544397 552137 553319 555276 556078 584788 587574 588506 592180 595530 599535 600399 602334 606272 606527 608779 614835 615390 616136 618479 625369 631056 634973 635391 636210 638751 639181 644075 659065 659195 659933 660984 661455 680432 680820 689572 691688 693898 697589 697657 699602 701601 705729 707766 712346 715573 718822 719927 720996 728258 730843 734175 735594 736982 740863 741365 746605 746799 749391 751430 752293 757434 758757 758942 760407 761755 764339 768965 769952 772247 772739 773354 774684 776972 781063 782441 783449 783490 784846 785225 785233 786820 787521 787574 790449 790605 791117 791129 791964 793005 793095 794168 794433 794532 794754 794799 794966 795848 796584 798313 801802 802954 804930 805530 806284 806291 807197 809202 811233 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хочу хочу"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хоч хоч"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.77%) |
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.