Query Metrics
7
Database Queries
7
Different statements
141.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.47 ms (84.49%) |
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 107362 335993 354333 382828 384201 384945 385977 387078 392981 395677 397365 412409 412539 413209 424000 424528 432374 434871 441331 449312 450046 450067 450698 452692 458642 462703 465285 472372 472983 473897 482494 488023 497629 497719 505603 507490 514985 516623 524602 529340 530952 531381 546737 556320 564917 570170 573187 574768 603359 608231 631830 639982 666431 689356 708841 722237 724441 724725 728388 734859 741160 743492 744162 747488 747799 751190 755933 756640 757525 758327 760632 760635 768226 771426 771875 772440 774266 774759 776094 778285 780328 782772 784575 786882 787690 792245 793197 793839 794000 794525 794848 795851 796931 800044 803015 805460 810096 810991 811473 812093 814478 816168 818455 819304 820011 820041 820145 820852 822010 823750 823777 823825 824145 825807 826507 827528 828596 828676 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (8.87%) |
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 524602 382828 354333 820011 824145 820041 497629 507490 570170 722237 774759 796931 800044 775594 776094 782772 784575 793197 724725 744162 747488 755933 772440 792245 811473 724441 743492 768226 774266 734859 747799 757525 771426 741160 751190 771875 794000 778285 780328 786882 793839 760635 497719 574768 432374 818455 689356 608231 639982 805460 756640 810991 472372 384201 384945 819304 823777 825807 564917 795851 450046 529340 631830 413209 335993 810096 397365 760632 441331 452692 424000 603359 482494 462703 546737 666431 472983 412409 814478 820145 823750 820852 822010 823825 505603 573187 812093 787690 794525 803015 758327 794848 708841 827528 826507 825489 828596 828676 728388 816168 514985 434871 556320 424528 516623 392981 107362 488023 385977 395677 387078 412539 450067 458642 449312 450698 465285 530952 531381 473897 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (2.08%) |
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 107362 335993 354333 382828 384201 384945 385977 387078 392981 395677 397365 412409 412539 413209 424000 424528 432374 434871 441331 449312 450046 450067 450698 452692 458642 462703 465285 472372 472983 473897 482494 488023 497629 497719 505603 507490 514985 516623 524602 529340 530952 531381 546737 556320 564917 570170 573187 574768 603359 608231 631830 639982 666431 689356 708841 722237 724441 724725 728388 734859 741160 743492 744162 747488 747799 751190 755933 756640 757525 758327 760632 760635 768226 771426 771875 772440 774266 774759 776094 778285 780328 782772 784575 786882 787690 792245 793197 793839 794000 794525 794848 795851 796931 800044 803015 805460 810096 810991 811473 812093 814478 816168 818455 819304 820011 820041 820145 820852 822010 823750 823777 823825 824145 825807 826507 827528 828596 828676 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties pussy"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел pussy"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел pussy"
]
|
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.