Query Metrics
7
Database Queries
7
Different statements
192.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.62 ms (87.57%) |
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 63344 86309 131602 154310 154692 230762 369221 382121 382158 382361 385884 387337 387760 391081 397869 397882 398097 460203 465629 474163 486778 515060 530438 536524 555004 560910 561479 562536 569749 586100 587541 591156 595213 601026 601095 607683 613559 620734 621229 625778 626889 630054 638693 640306 644870 648649 648696 650408 651132 653028 666682 681388 686183 687313 697876 698385 701303 710853 711624 713088 718987 733406 734265 735535 738475 744180 751453 752275 752668 753120 758336 759198 760417 761449 762130 762975 776158 780663 781255 781298 781844 784672 790009 791511 793017 793709 797875 798457 799279 800723 803490 803771 804666 805291 806694 807211 808524 811112 812382 813817 814363 815420 815787 817012 817082 817113 817993 819251 822060 823789 823996 824733 825329 825768 825858 826610 826618 826829 827009 827722 ] |
||||||||||||||||||||||||||||||
|
13.05 ms (6.78%) |
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 648696 697876 651132 613559 595213 781298 803771 806694 752668 762975 793017 751453 625778 369221 131602 382361 230762 63344 154310 530438 536524 644870 799279 744180 812382 387760 813817 640306 638693 397869 698385 382121 398097 759198 474163 601026 648649 382158 387337 397882 391081 738475 630054 805291 465629 515060 798457 825329 824733 687313 815420 620734 569749 823996 827009 781844 562536 815787 650408 793709 591156 154692 686183 825768 808524 734265 804666 718987 601095 753120 681388 586100 621229 735535 86309 780663 385884 817993 826610 826618 817082 825858 817012 823789 817113 819251 822060 486778 460203 561479 701303 713088 587541 626889 790009 776158 803490 733406 758336 760417 784672 791511 797875 800723 811112 762130 752275 761449 781255 807211 826829 827722 560910 814363 653028 710853 711624 666682 555004 607683 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.74%) |
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 63344 86309 131602 154310 154692 230762 369221 382121 382158 382361 385884 387337 387760 391081 397869 397882 398097 460203 465629 474163 486778 515060 530438 536524 555004 560910 561479 562536 569749 586100 587541 591156 595213 601026 601095 607683 613559 620734 621229 625778 626889 630054 638693 640306 644870 648649 648696 650408 651132 653028 666682 681388 686183 687313 697876 698385 701303 710853 711624 713088 718987 733406 734265 735535 738475 744180 751453 752275 752668 753120 758336 759198 760417 761449 762130 762975 776158 780663 781255 781298 781844 784672 790009 791511 793017 793709 797875 798457 799279 800723 803490 803771 804666 805291 806694 807211 808524 811112 812382 813817 814363 815420 815787 817012 817082 817113 817993 819251 822060 823789 823996 824733 825329 825768 825858 826610 826618 826829 827009 827722 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð▒ð¥ð╗ÐîÐêð©ðÁ Ðüð©ÐüÐîð║ð© Ðü ð┤ð©ð╗ð┤ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ дилд"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ дилд"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
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.