Query Metrics
7
Database Queries
7
Different statements
233.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.89 ms (89.30%) |
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 118298 154844 390587 391746 396119 410227 419557 422324 429961 432939 434527 435585 440068 440739 441057 441068 441073 441106 441107 441233 441834 441952 443084 443152 455021 457698 459201 459204 460070 471671 477061 481169 481903 481905 487275 487278 487429 493744 495733 496166 497830 497864 508929 510805 512078 513978 513982 514234 514261 515965 518561 524804 527921 529897 531877 532749 532803 534552 534576 534578 534585 536224 536226 536375 536463 537861 538925 539185 540531 540679 543722 559368 559787 563993 575369 576554 576916 578750 586996 590289 595483 602283 604080 605033 627472 633455 637446 639736 648618 651959 651963 656895 660365 664226 666988 668677 671002 705466 719651 725618 727325 729800 738821 740692 747073 750067 752594 757400 786878 790136 790163 790381 792736 800309 800930 801625 801628 802925 805642 824773 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (6.09%) |
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 559787 576916 590289 604080 595483 441068 441106 440068 477061 457698 459204 481903 534576 539185 510805 534585 538925 524804 508929 515965 481905 487275 575369 563993 648618 666988 671002 651963 656895 664226 668677 719651 660365 705466 602283 633455 637446 627472 790381 729800 786878 790136 792736 800930 801628 747073 725618 727325 740692 757400 738821 752594 605033 639736 801625 802925 805642 435585 440739 441233 481169 518561 512078 496166 410227 824773 495733 540679 576554 543722 651959 578750 586996 800309 790163 750067 118298 154844 391746 390587 396119 441107 441834 441952 422324 434527 441073 419557 429961 441057 443084 443152 432939 559368 487429 460070 471671 487278 455021 459201 493744 497830 532803 536226 513982 514261 531877 532749 536375 536463 537861 497864 529897 534552 534578 536224 540531 513978 514234 527921 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.42%) |
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 118298 154844 390587 391746 396119 410227 419557 422324 429961 432939 434527 435585 440068 440739 441057 441068 441073 441106 441107 441233 441834 441952 443084 443152 455021 457698 459201 459204 460070 471671 477061 481169 481903 481905 487275 487278 487429 493744 495733 496166 497830 497864 508929 510805 512078 513978 513982 514234 514261 515965 518561 524804 527921 529897 531877 532749 532803 534552 534576 534578 534585 536224 536226 536375 536463 537861 538925 539185 540531 540679 543722 559368 559787 563993 575369 576554 576916 578750 586996 590289 595483 602283 604080 605033 627472 633455 637446 639736 648618 651959 651963 656895 660365 664226 666988 668677 671002 705466 719651 725618 727325 729800 738821 740692 747073 750067 752594 757400 786878 790136 790163 790381 792736 800309 800930 801625 801628 802925 805642 824773 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"его фистят"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.