Query Metrics
7
Database Queries
7
Different statements
144.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.11 ms (82.59%) |
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 315815 395574 399426 400341 401267 409421 410406 414082 418389 424917 425079 425472 432563 432715 433594 433639 433808 437330 437996 447574 448578 450271 459225 462481 462994 463623 476861 484300 487495 487768 497117 503075 507890 509967 510895 516444 518527 523476 527066 527687 529134 533469 552865 554253 555971 559207 561948 566005 568098 573391 581191 581715 590076 590095 591442 607311 609432 621356 621721 625088 632418 636118 636977 640844 644049 646482 650565 656830 660131 697853 702288 710858 724820 735361 736918 737300 749636 751269 758741 760436 762067 762174 764889 765219 768244 769272 769479 770590 771071 771168 773356 773552 775454 778008 778074 779255 785036 785918 787057 787825 788340 790216 791593 793775 794864 795212 795241 796426 804506 806217 810559 814499 818126 820181 823632 827271 827881 827910 828653 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (10.02%) |
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 607311 785918 791593 751269 769272 795241 762067 735361 621128 785036 787057 787825 804506 806217 796426 769479 433808 447574 448578 552865 609432 432563 527687 523476 818126 581715 827271 702288 793775 401267 462481 529134 573391 773552 433594 437996 395574 814499 827910 828653 450271 487495 510895 559207 581191 656830 650565 646482 660131 710858 636118 644049 632418 640844 778008 779255 790216 810559 760436 770590 764889 737300 758741 765219 771071 724820 762174 768244 773356 621721 778074 788340 410406 418389 487768 697853 590095 749636 775454 409421 795212 568098 591442 459225 400341 566005 636977 433639 590076 425472 432715 476861 462994 516444 497117 507890 555971 561948 621356 625088 424917 425079 463623 484300 503075 771168 554253 527066 518527 794864 736918 315815 399426 414082 437330 823632 820181 827881 533469 509967 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.30%) |
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 315815 395574 399426 400341 401267 409421 410406 414082 418389 424917 425079 425472 432563 432715 433594 433639 433808 437330 437996 447574 448578 450271 459225 462481 462994 463623 476861 484300 487495 487768 497117 503075 507890 509967 510895 516444 518527 523476 527066 527687 529134 533469 552865 554253 555971 559207 561948 566005 568098 573391 581191 581715 590076 590095 591442 607311 609432 621356 621721 625088 632418 636118 636977 640844 644049 646482 650565 656830 660131 697853 702288 710858 724820 735361 736918 737300 749636 751269 758741 760436 762067 762174 764889 765219 768244 769272 769479 770590 771071 771168 773356 773552 775454 778008 778074 779255 785036 785918 787057 787825 788340 790216 791593 793775 794864 795212 795241 796426 804506 806217 810559 814499 818126 820181 823632 827271 827881 827910 828653 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister ass"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister жоп"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister жоп"
]
|
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.