Query Metrics
7
Database Queries
7
Different statements
156.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.62 ms (85.52%) |
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 12880 13035 13373 14105 163310 176148 292790 327134 345303 351291 387374 397971 409597 419221 444446 456235 465687 469495 475728 475731 484236 488640 500500 509678 509874 517018 519069 522109 525433 529317 529491 531561 531867 532718 534007 535247 536376 538756 546392 550180 555149 556767 565760 568838 577935 578505 580472 583398 584985 586164 588404 588741 589392 589996 590041 590063 590807 591700 592665 595355 596041 600838 601198 605510 605692 606818 608121 621344 622730 624189 624204 629422 658787 660849 682942 686101 701610 714011 727458 728277 731226 732208 733219 733249 750154 752405 755579 755583 759914 760238 761030 761451 765273 766821 767209 767268 769524 776466 786205 789408 790861 795010 795052 795977 796861 797472 798207 798271 799708 800579 800595 800855 801146 801576 803346 806100 808053 808061 811045 811557 ] |
||||||||||||||||||||||||||||||
|
13.05 ms (8.35%) |
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 714011 586164 601198 608121 624189 595355 606818 621344 629422 590063 591700 588741 605510 798207 800579 750154 759914 795977 801576 766821 752405 760238 761030 767268 469495 465687 475731 801146 806100 525433 509678 580472 555149 624204 731226 292790 12880 13373 13035 532718 529317 517018 701610 596041 786205 799708 800595 803346 789408 800855 808053 765273 795052 797472 798271 808061 811045 732208 755579 767209 727458 728277 755583 733219 733249 790861 796861 811557 351291 345303 387374 397971 14105 444446 456235 163310 176148 327134 534007 577935 682942 776466 761451 769524 795010 419221 409597 584985 509874 522109 529491 531867 536376 538756 500500 519069 531561 535247 475728 484236 488640 550180 578505 583398 556767 565760 660849 686101 658787 546392 568838 588404 590041 590807 592665 605692 589392 589996 600838 622730 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.65%) |
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 12880 13035 13373 14105 163310 176148 292790 327134 345303 351291 387374 397971 409597 419221 444446 456235 465687 469495 475728 475731 484236 488640 500500 509678 509874 517018 519069 522109 525433 529317 529491 531561 531867 532718 534007 535247 536376 538756 546392 550180 555149 556767 565760 568838 577935 578505 580472 583398 584985 586164 588404 588741 589392 589996 590041 590063 590807 591700 592665 595355 596041 600838 601198 605510 605692 606818 608121 621344 622730 624189 624204 629422 658787 660849 682942 686101 701610 714011 727458 728277 731226 732208 733219 733249 750154 752405 755579 755583 759914 760238 761030 761451 765273 766821 767209 767268 769524 776466 786205 789408 790861 795010 795052 795977 796861 797472 798207 798271 799708 800579 800595 800855 801146 801576 803346 806100 808053 808061 811045 811557 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"but ass"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.