Query Metrics
7
Database Queries
7
Different statements
172.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.91 ms (87.16%) |
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 294 118885 147280 191406 198253 205443 367863 383225 383350 383493 386569 387631 388118 395438 397173 397176 398523 401450 420450 467847 472498 481069 495885 496324 497813 503911 506238 520148 528295 529661 530356 530398 533033 534975 535780 536756 537785 538731 538858 540081 540088 540103 540129 540158 540669 811896 813704 813819 814441 815891 815942 815993 816297 816608 816854 817107 817324 817353 817525 817804 817939 818028 818066 819031 819284 820169 820558 820982 821002 821003 821029 821061 821110 821199 821367 821547 821600 821601 821785 822313 822610 822677 823009 823036 823093 823190 823375 823437 823633 823771 823774 823823 823906 823991 823994 824112 824288 824596 825194 825246 825295 825335 825367 825658 825800 826630 826856 826892 827383 827440 827630 827730 827831 828449 828481 828587 828799 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (7.33%) |
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 811896 118885 387631 383225 198253 205443 367863 395438 401450 467847 398523 495885 503911 386569 383493 383350 147280 191406 294 388118 397176 397173 420450 817353 820169 821600 822610 823036 823774 825295 826630 825335 814441 815891 816608 817107 817804 817939 820982 821003 821029 821547 822677 823683 825194 826856 826892 827383 827440 827630 827730 816297 818028 818066 819031 821199 821367 822313 823093 823437 823492 823771 823823 823991 824112 824288 824596 825658 813704 813819 815942 815993 816854 817324 817525 819284 820558 821002 821061 821110 821601 821785 823009 823190 823375 823633 823906 823994 825195 825246 825367 825800 827831 828799 828587 828481 828449 520148 529661 530398 533033 537785 538731 540158 530356 538858 540669 496324 497813 506238 534975 536756 540081 540088 540103 540129 528295 535780 472498 481069 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.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 294 118885 147280 191406 198253 205443 367863 383225 383350 383493 386569 387631 388118 395438 397173 397176 398523 401450 420450 467847 472498 481069 495885 496324 497813 503911 506238 520148 528295 529661 530356 530398 533033 534975 535780 536756 537785 538731 538858 540081 540088 540103 540129 540158 540669 811896 813704 813819 814441 815891 815942 815993 816297 816608 816854 817107 817324 817353 817525 817804 817939 818028 818066 819031 819284 820169 820558 820982 821002 821003 821029 821061 821110 821199 821367 821547 821600 821601 821785 822313 822610 822677 823009 823036 823093 823190 823375 823437 823633 823771 823774 823823 823906 823991 823994 824112 824288 824596 825194 825246 825295 825335 825367 825658 825800 826630 826856 826892 827383 827440 827630 827730 827831 828449 828481 828587 828799 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван ван"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"душ в ванной"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.81%) |
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.