Query Metrics
7
Database Queries
7
Different statements
150.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.31 ms (78.15%) |
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 419758 441517 454802 456804 496802 517928 525050 527956 530020 530028 530487 530630 530784 530941 531088 531089 531097 531419 532738 532762 532772 532966 532995 533372 533373 533726 533773 533944 534028 535054 535584 536638 537114 539203 540398 540405 540559 544825 545430 582323 599847 600019 600171 600185 600204 600249 600268 600289 600312 600415 601535 601613 601861 603391 603785 608394 619974 622167 630522 632283 632618 632659 632671 633775 634482 634504 635224 639258 639748 639783 640793 642002 642025 642063 642359 642658 642751 645720 646786 647340 648220 648841 649596 651631 654256 656625 683261 683264 698785 705302 707673 716071 716887 716900 720187 723219 724105 724129 724978 726082 727785 741785 742480 757538 761594 762041 763032 765756 775219 777851 777861 779002 783271 791233 792175 796126 797210 810214 813181 813742 ] |
||||||||||||||||||||||||||||||
|
23.42 ms (15.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 535054 517928 530630 530941 531089 531419 532772 534028 496802 530028 530487 535584 540405 582323 648220 648841 683261 646786 647340 545430 600185 630522 642002 642658 600312 600268 601861 632618 642751 639748 601535 632659 716887 716900 419758 698785 654256 656625 608394 791233 775219 797210 813181 724129 762041 724105 726082 727785 765756 723219 777851 777861 779002 539203 540559 639258 642359 527956 645720 707673 716071 603785 603391 783271 792175 724978 761594 763032 757538 741785 742480 720187 796126 441517 454802 532995 533944 536638 540398 530020 531088 532738 532966 533372 533373 533726 530784 531097 532762 533773 537114 544825 649596 651631 683264 705302 600171 634482 642025 642063 600415 632671 635224 639783 640793 599847 600249 600289 600019 601613 632283 633775 525050 813742 456804 619974 622167 600204 634504 810214 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.65%) |
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 419758 441517 454802 456804 496802 517928 525050 527956 530020 530028 530487 530630 530784 530941 531088 531089 531097 531419 532738 532762 532772 532966 532995 533372 533373 533726 533773 533944 534028 535054 535584 536638 537114 539203 540398 540405 540559 544825 545430 582323 599847 600019 600171 600185 600204 600249 600268 600289 600312 600415 601535 601613 601861 603391 603785 608394 619974 622167 630522 632283 632618 632659 632671 633775 634482 634504 635224 639258 639748 639783 640793 642002 642025 642063 642359 642658 642751 645720 646786 647340 648220 648841 649596 651631 654256 656625 683261 683264 698785 705302 707673 716071 716887 716900 720187 723219 724105 724129 724978 726082 727785 741785 742480 757538 761594 762041 763032 765756 775219 777851 777861 779002 783271 791233 792175 796126 797210 810214 813181 813742 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep хардкор"
]
|
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.