Query Metrics
7
Database Queries
7
Different statements
143.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.10 ms (81.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 418978 511393 519217 524987 535488 535493 538835 538891 538952 540257 541293 541337 541339 541360 541369 541586 541604 541622 541759 541773 542193 542194 544116 544267 544274 544281 544286 544295 544329 544347 546550 547265 548278 548289 549269 549298 549299 549307 549896 549964 549968 549973 550003 550149 550333 550334 551020 556786 556794 557322 559122 562829 563535 565571 566692 566760 567396 570797 570810 572603 576622 576623 576655 576669 576695 576706 577353 577368 577375 578257 579902 581316 581334 583533 583823 592446 601055 601068 606680 606781 615737 620154 620162 621307 628170 628297 628319 628325 649956 662137 668937 668943 670946 671734 677702 681118 681153 685447 702888 703109 705289 706611 708422 722714 727392 727436 730225 730524 742152 742515 744311 744591 755463 755466 755474 761321 784308 790407 793601 815531 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (10.86%) |
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 570810 579902 606781 790407 727392 730225 744591 730524 761321 755474 576622 519217 542193 541604 541773 578257 567396 544274 706611 671734 708422 549964 784308 535493 538835 541360 549299 583823 677702 670946 705289 549269 549896 628325 742152 744311 742515 702888 576695 562829 550334 557322 572603 541339 541586 549298 550333 559122 581334 544116 544286 544329 556794 576655 668937 685447 551020 570797 548278 576706 535488 581316 722714 542194 577368 541759 544281 563535 662137 576623 583533 538952 524987 668943 548289 565571 577353 541293 541622 544347 566692 577375 541337 544295 549968 576669 556786 601055 601068 606680 620162 621307 620154 628170 592446 815531 540257 538891 547265 550003 550149 541369 544267 546550 549307 649956 681118 681153 549973 628297 615737 628319 793601 727436 755463 755466 703109 418978 511393 566760 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.92%) |
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 418978 511393 519217 524987 535488 535493 538835 538891 538952 540257 541293 541337 541339 541360 541369 541586 541604 541622 541759 541773 542193 542194 544116 544267 544274 544281 544286 544295 544329 544347 546550 547265 548278 548289 549269 549298 549299 549307 549896 549964 549968 549973 550003 550149 550333 550334 551020 556786 556794 557322 559122 562829 563535 565571 566692 566760 567396 570797 570810 572603 576622 576623 576655 576669 576695 576706 577353 577368 577375 578257 579902 581316 581334 583533 583823 592446 601055 601068 606680 606781 615737 620154 620162 621307 628170 628297 628319 628325 649956 662137 668937 668943 670946 671734 677702 681118 681153 685447 702888 703109 705289 706611 708422 722714 727392 727436 730225 730524 742152 742515 744311 744591 755463 755466 755474 761321 784308 790407 793601 815531 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother film"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин фильм"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин фильм"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.17%) |
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.