Query Metrics
7
Database Queries
7
Different statements
132.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.39 ms (86.29%) |
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 4123 6763 12387 15364 49365 60843 143396 183239 213017 341079 357750 382072 382270 388850 393428 422157 423088 442545 450300 471700 509189 509238 528392 529241 533618 533630 535433 535854 537502 540470 542481 543966 545281 549894 550116 566379 566428 569762 592110 597460 601420 616059 617898 618747 626376 636888 645464 645576 658759 674333 675544 685103 691157 695382 708504 717659 726156 734324 741133 744354 744373 759856 760489 768577 769970 770995 795586 795763 798697 801010 803055 811114 815376 817170 818142 818298 818300 818302 818507 818535 819830 820857 821707 822580 823708 823755 824030 824266 824286 824324 824965 825049 825067 825901 825920 825955 826099 826175 826190 826210 826380 826397 826444 826567 826985 828067 828199 828295 828409 828470 828478 828502 828525 828631 828643 ] |
||||||||||||||||||||||||||||||
|
9.44 ms (7.12%) |
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 691157 801010 817170 823708 826175 825955 826210 828067 828525 566379 645576 717659 726156 382270 533618 528392 143396 393428 357750 382072 341079 49365 60843 818507 824286 824965 825901 826190 815376 818302 822580 824030 824266 826397 826567 826985 818142 818298 818300 821707 824380 826099 826444 820857 823755 825920 828199 828409 828295 828470 828643 828502 828631 509238 533630 537502 540470 529241 535854 542481 549894 550116 566428 543966 685103 695382 645464 675544 658759 674333 708504 601420 592110 617898 618747 798697 769970 803055 811114 744354 759856 741133 760489 770995 795763 213017 825049 818535 826340 825067 828478 636888 616059 4123 15364 183239 12387 768577 423088 734324 450300 509189 442545 422157 535433 569762 471700 545281 597460 795586 763882 744373 766674 766118 626376 6763 388850 819830 826380 824324 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (2.00%) |
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 4123 6763 12387 15364 49365 60843 143396 183239 213017 341079 357750 382072 382270 388850 393428 422157 423088 442545 450300 471700 509189 509238 528392 529241 533618 533630 535433 535854 537502 540470 542481 543966 545281 549894 550116 566379 566428 569762 592110 597460 601420 616059 617898 618747 626376 636888 645464 645576 658759 674333 675544 685103 691157 695382 708504 717659 726156 734324 741133 744354 744373 759856 760489 768577 769970 770995 795586 795763 798697 801010 803055 811114 815376 817170 818142 818298 818300 818302 818507 818535 819830 820857 821707 822580 823708 823755 824030 824266 824286 824324 824965 825049 825067 825901 825920 825955 826099 826175 826190 826210 826380 826397 826444 826567 826985 828067 828199 828295 828409 828470 828478 828502 828525 828631 828643 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass big ass"
]
|
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.