Query Metrics
7
Database Queries
7
Different statements
142.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.70 ms (84.12%) |
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 43748 154451 298529 396556 398787 407045 427149 427634 429553 429855 432374 435592 435890 437381 439318 444281 452703 453406 453976 463597 466759 467016 467667 468968 473424 484972 486617 493217 495096 496142 499549 502935 515023 517441 517720 519230 528203 529898 532539 534520 534524 548149 550431 554410 563062 565013 567720 574363 574969 578693 580425 583328 588345 590057 593100 595433 599738 602470 604011 606060 610483 626128 629422 629795 639628 643317 655496 660406 667464 691626 695359 710289 723925 727005 728388 730046 735889 738088 743731 745252 746723 749026 759882 759895 760761 761039 765781 770073 770715 780315 782366 788768 791914 792136 792319 794345 794854 795658 795855 795913 797020 800849 801125 806166 806966 809080 813950 817315 817856 819173 823702 824017 824288 824903 825529 826087 826206 828430 828768 828786 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (9.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 792319 407045 435890 439318 43748 444281 563062 823702 824017 578693 606060 453406 743731 738088 468968 534524 655496 580425 593100 467016 801125 780315 643317 435592 528203 466759 604011 453976 429855 495096 602470 452703 499549 567720 437381 515023 667464 691626 463597 565013 792136 548149 595433 493217 588345 583328 532539 660406 809080 723925 746723 745252 797020 819173 825529 828768 828786 828430 806966 788768 574363 574969 710289 629795 610483 795855 806166 727005 749026 770073 765781 800849 728388 529898 639628 791914 502935 298529 817856 824903 813950 824288 817315 695359 794854 760761 782366 794345 590057 517441 626128 759895 759882 730046 795658 427634 826206 826087 735889 629422 496142 427149 486617 484972 534520 473424 550431 554410 467667 396556 398787 795913 517720 429553 519230 761039 599738 154451 432374 770715 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.58%) |
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 43748 154451 298529 396556 398787 407045 427149 427634 429553 429855 432374 435592 435890 437381 439318 444281 452703 453406 453976 463597 466759 467016 467667 468968 473424 484972 486617 493217 495096 496142 499549 502935 515023 517441 517720 519230 528203 529898 532539 534520 534524 548149 550431 554410 563062 565013 567720 574363 574969 578693 580425 583328 588345 590057 593100 595433 599738 602470 604011 606060 610483 626128 629422 629795 639628 643317 655496 660406 667464 691626 695359 710289 723925 727005 728388 730046 735889 738088 743731 745252 746723 749026 759882 759895 760761 761039 765781 770073 770715 780315 782366 788768 791914 792136 792319 794345 794854 795658 795855 795913 797020 800849 801125 806166 806966 809080 813950 817315 817856 819173 823702 824017 824288 824903 825529 826087 826206 828430 828768 828786 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties big ass"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.15%) |
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.