Query Metrics
7
Database Queries
7
Different statements
202.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.38 ms (83.09%) |
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 42536 159291 352187 388341 401177 415878 416568 416682 416691 416708 418112 419613 423652 424606 432936 441074 441122 441157 441232 443317 445745 447160 450697 451022 456222 456238 457480 457483 460765 461704 465144 466474 466633 466636 467886 468946 469220 469224 470428 470479 473366 477149 478437 483738 487418 487428 488820 495737 497691 497697 498297 498319 502287 512931 513963 515546 517928 523357 525700 525731 526504 529739 532658 532847 533519 534229 539030 540531 545305 548157 574458 580773 583665 590372 592362 597160 599833 599922 599955 609639 615022 623420 636320 639027 639706 639762 639787 639802 642004 644916 647838 647885 647905 647914 656826 656932 666528 666535 666550 666875 666878 666902 675375 680801 680816 689358 689359 716086 722378 725608 725628 745114 745121 752657 766591 770860 788529 797284 805144 811013 ] |
||||||||||||||||||||||||||||||
|
24.51 ms (12.10%) |
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 443317 416691 424606 441157 415878 416682 419613 451022 470479 457483 468946 473366 478437 457480 470428 483738 498297 502287 526504 497691 497697 515546 495737 466633 466636 548157 583665 680816 675375 597160 615022 592362 416708 469220 416568 465144 477149 401177 441232 456238 450697 487428 529739 488820 388341 423652 623420 432936 517928 532847 534229 545305 647838 666535 666875 666528 666878 647905 666902 599955 418112 441122 447160 460765 523357 513963 487418 656932 689358 574458 609639 639787 811013 456222 461704 467886 441074 466474 512931 525700 498319 540531 642004 725608 525731 580773 636320 599833 599922 469224 539030 689359 716086 722378 656826 680801 590372 788529 745114 752657 766591 770860 725628 745121 352187 42536 797284 533519 532658 666550 647885 647914 639762 639802 639706 639027 805144 445745 159291 644916 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.44%) |
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 42536 159291 352187 388341 401177 415878 416568 416682 416691 416708 418112 419613 423652 424606 432936 441074 441122 441157 441232 443317 445745 447160 450697 451022 456222 456238 457480 457483 460765 461704 465144 466474 466633 466636 467886 468946 469220 469224 470428 470479 473366 477149 478437 483738 487418 487428 488820 495737 497691 497697 498297 498319 502287 512931 513963 515546 517928 523357 525700 525731 526504 529739 532658 532847 533519 534229 539030 540531 545305 548157 574458 580773 583665 590372 592362 597160 599833 599922 599955 609639 615022 623420 636320 639027 639706 639762 639787 639802 642004 644916 647838 647885 647905 647914 656826 656932 666528 666535 666550 666875 666878 666902 675375 680801 680816 689358 689359 716086 722378 725608 725628 745114 745121 752657 766591 770860 788529 797284 805144 811013 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting anal 2023"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг анал"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
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.