Query Metrics
7
Database Queries
7
Different statements
166.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.39 ms (85.31%) |
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 421614 422662 429601 435403 435567 438490 438957 439387 440637 442704 444086 444540 444914 448328 449916 450277 454386 454767 455133 457967 458756 460384 463420 463978 464690 466457 467110 468236 471646 477760 478523 478988 485219 505800 509776 510920 517514 518225 529422 530127 535352 537044 575941 577340 583287 589229 598318 600027 601163 602109 603391 603471 604967 605597 613646 614504 614577 620260 631331 636672 644441 697628 733549 736796 739156 739368 740514 740929 741157 741526 742351 742421 747328 750623 751710 752950 756776 759490 760471 760538 761621 765183 765564 765849 770237 770262 770849 772250 774701 774703 775582 776041 779720 780019 780038 780268 783008 783212 783235 783319 784792 787095 789832 794041 800543 800792 802071 803509 803605 805643 806822 807010 807112 808979 809005 809050 809057 809707 811234 812552 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (8.79%) |
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 575941 613646 636672 603471 604967 620260 598318 601163 614504 614577 589229 603391 631331 784792 787095 809005 809050 809057 809707 812552 774703 775582 776041 780019 780038 803509 803605 808979 751710 752950 759490 772250 783212 783319 789832 794041 800543 760538 761621 765849 770262 770849 739156 740514 756776 733549 760471 765564 736796 740929 741157 741526 742421 750623 602109 644441 697628 774701 779720 780268 783008 800792 802071 805643 806822 807010 807112 811234 421614 454386 435567 439387 444086 444914 448328 478523 442704 510920 529422 505800 440637 466457 485219 537044 509776 583287 605597 783235 742351 765183 770237 460384 471646 435403 422662 517514 600027 739368 438957 747328 438490 444540 429601 454767 463978 477760 449916 455133 457967 458756 467110 450277 464690 468236 478988 518225 530127 535352 463420 577340 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.83%) |
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 421614 422662 429601 435403 435567 438490 438957 439387 440637 442704 444086 444540 444914 448328 449916 450277 454386 454767 455133 457967 458756 460384 463420 463978 464690 466457 467110 468236 471646 477760 478523 478988 485219 505800 509776 510920 517514 518225 529422 530127 535352 537044 575941 577340 583287 589229 598318 600027 601163 602109 603391 603471 604967 605597 613646 614504 614577 620260 631331 636672 644441 697628 733549 736796 739156 739368 740514 740929 741157 741526 742351 742421 747328 750623 751710 752950 756776 759490 760471 760538 761621 765183 765564 765849 770237 770262 770849 772250 774701 774703 775582 776041 779720 780019 780038 780268 783008 783212 783235 783319 784792 787095 789832 794041 800543 800792 802071 803509 803605 805643 806822 807010 807112 808979 809005 809050 809057 809707 811234 812552 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo oil"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло масл"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло масл"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.93%) |
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.