Query Metrics
7
Database Queries
7
Different statements
436.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.26 ms (48.64%) |
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 233093 383358 385224 389065 398831 421021 421597 456831 470101 475868 496632 520242 521771 534658 546389 548000 548020 552850 557005 568184 573997 577417 577832 591281 594063 604603 605295 616687 616714 620828 623804 625309 636883 643327 644104 644190 649588 651128 651974 658440 659172 661701 662426 662888 666918 668982 670544 673216 678422 682908 686937 697219 697247 697635 699828 700209 701285 702382 705443 705551 706384 707484 709036 709844 710011 710342 711585 718910 724492 728460 729061 730993 731137 731189 731440 733548 734858 735667 736634 737363 741711 742585 742750 742770 743801 745343 745711 747190 749107 750778 759010 762227 763249 763311 763874 766688 778621 780675 787578 788432 791297 794489 795597 796616 800740 800745 800751 801117 802942 803427 803435 803436 803442 803698 805290 807483 810040 813472 826377 827655 ] |
||||||||||||||||||||||||||||||
|
205.67 ms (47.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
11.37 ms (2.60%) |
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 778621 780675 787578 800740 800745 803435 803442 810040 813472 731137 731440 735667 759010 766688 791297 801117 803436 803698 807483 724492 729061 730993 733548 734858 736634 743801 763311 763874 737363 742585 742770 745711 747190 728460 731189 741711 745343 750778 762227 763249 742750 749107 718910 788432 800751 803427 398831 421597 389065 826377 827655 794489 795597 805290 802942 233093 383358 421021 796616 385224 661701 678422 699828 707484 594063 475868 456831 534658 520242 521771 496632 470101 546389 552850 577417 548000 573997 548020 557005 568184 577832 651128 658440 666918 670544 697247 697635 702382 706384 709036 710342 651974 662426 668982 682908 701285 709844 711585 649588 659172 662888 673216 686937 705443 705551 620828 643327 616687 616714 636883 644190 591281 605295 625309 644104 604603 623804 697219 700209 710011 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.54%) |
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 233093 383358 385224 389065 398831 421021 421597 456831 470101 475868 496632 520242 521771 534658 546389 548000 548020 552850 557005 568184 573997 577417 577832 591281 594063 604603 605295 616687 616714 620828 623804 625309 636883 643327 644104 644190 649588 651128 651974 658440 659172 661701 662426 662888 666918 668982 670544 673216 678422 682908 686937 697219 697247 697635 699828 700209 701285 702382 705443 705551 706384 707484 709036 709844 710011 710342 711585 718910 724492 728460 729061 730993 731137 731189 731440 733548 734858 735667 736634 737363 741711 742585 742750 742770 743801 745343 745711 747190 749107 750778 759010 762227 763249 763311 763874 766688 778621 780675 787578 788432 791297 794489 795597 796616 800740 800745 800751 801117 802942 803427 803435 803436 803442 803698 805290 807483 810040 813472 826377 827655 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short hair amateur"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short hair любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short hair любительск"
]
|
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.