Query Metrics
7
Database Queries
7
Different statements
200.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.38 ms (88.48%) |
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 28386 75811 92006 96581 142832 391762 397122 447131 456166 462647 498587 525078 538536 548202 557959 558590 566062 577059 580844 588275 589894 590042 590071 590074 590117 592867 598270 598384 600233 604415 605402 615197 616233 616517 616705 626116 628829 629169 634249 635527 637389 641153 643220 646016 652247 655908 660321 661607 662509 673125 673818 684393 686203 693627 697325 699905 705141 705784 706521 711855 712536 712846 714175 715457 719162 720242 723012 723043 726931 727008 728722 732872 736535 736642 736954 737643 738960 739989 744551 748918 753651 753929 756513 757283 758331 760491 768164 771554 775590 778352 781218 783078 786477 789580 789750 789967 790806 792210 792457 792556 794502 800063 801245 801937 802831 803178 804228 805277 806287 811542 813098 814008 815779 816252 817104 817844 818346 827837 827881 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (6.59%) |
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 817104 817844 548202 580844 711855 684393 712536 604415 588275 589894 598270 804228 811542 726931 739989 753929 783078 805277 727008 757283 96581 525078 538536 705784 720242 660321 662509 673818 723012 577059 592867 626116 616233 635527 616517 616705 628829 590074 789580 792210 737643 756513 736642 629169 775590 801937 75811 827881 818346 827837 462647 558590 557959 673125 712846 715457 693627 699905 598384 637389 590071 590117 605402 778352 789967 790806 781218 794502 813098 792457 792556 738960 768164 736954 744551 760491 771554 723043 786477 800063 806287 142832 748918 92006 590042 28386 814008 816252 634249 732872 736535 758331 456166 447131 697325 705141 686203 646016 643220 600233 801245 789750 802831 753651 728722 714175 783559 803178 391762 397122 815779 498587 566062 652247 661607 719162 655908 706521 615197 641153 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.44%) |
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 28386 75811 92006 96581 142832 391762 397122 447131 456166 462647 498587 525078 538536 548202 557959 558590 566062 577059 580844 588275 589894 590042 590071 590074 590117 592867 598270 598384 600233 604415 605402 615197 616233 616517 616705 626116 628829 629169 634249 635527 637389 641153 643220 646016 652247 655908 660321 661607 662509 673125 673818 684393 686203 693627 697325 699905 705141 705784 706521 711855 712536 712846 714175 715457 719162 720242 723012 723043 726931 727008 728722 732872 736535 736642 736954 737643 738960 739989 744551 748918 753651 753929 756513 757283 758331 760491 768164 771554 775590 778352 781218 783078 786477 789580 789750 789967 790806 792210 792457 792556 794502 800063 801245 801937 802831 803178 804228 805277 806287 811542 813098 814008 815779 816252 817104 817844 818346 827837 827881 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"perfect sex"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"perfect секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"perfect секс"
]
|
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.