Query Metrics
7
Database Queries
7
Different statements
260.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
236.20 ms (90.84%) |
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 30420 88505 88614 186858 225591 226412 336085 383388 416240 419616 423703 458203 465489 465579 467841 473764 489377 503745 529865 530692 531732 544147 549308 549502 549515 550625 553746 555226 559863 560884 568803 574342 575378 576540 581645 585016 589593 593169 593798 595166 601872 608378 618393 619606 628261 632340 632901 633092 633406 637318 643423 645844 649437 650113 650948 651536 651731 652881 657536 660283 661653 666492 669896 669941 674202 678780 683698 686338 689988 700907 703218 704613 705478 708226 713940 722360 729204 731119 737106 740567 742536 745936 754638 757003 757239 760315 761944 763052 764268 768025 768234 769122 774774 778448 782831 801810 801937 803886 804239 805234 807028 807825 810087 810390 810484 811319 811914 812038 812529 812551 813791 816147 819665 823778 823890 824000 824103 824663 825582 826873 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (5.05%) |
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 383388 416240 608378 810390 423703 473764 465489 544147 757003 549308 703218 30420 585016 530692 574342 705478 650113 722360 549502 568803 628261 805234 782831 760315 632901 807028 689988 704613 778448 812038 225591 553746 489377 186858 88505 645844 649437 708226 737106 742536 764268 465579 419616 226412 336085 88614 824103 824663 825582 816147 813791 819665 823890 824000 826873 458203 529865 549515 559863 575378 576540 652881 700907 683698 666492 669896 678780 589593 593798 632340 593169 595166 618393 619606 637318 601872 643423 774774 810484 812529 803886 811319 811914 769122 812551 729204 768234 761944 768025 754638 763052 731119 745936 633092 633406 801810 804239 807825 467841 823778 555226 757239 740567 801937 810087 503745 531732 560884 581645 550625 651731 674202 686338 661653 669941 713940 650948 651536 657536 660283 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.26%) |
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 30420 88505 88614 186858 225591 226412 336085 383388 416240 419616 423703 458203 465489 465579 467841 473764 489377 503745 529865 530692 531732 544147 549308 549502 549515 550625 553746 555226 559863 560884 568803 574342 575378 576540 581645 585016 589593 593169 593798 595166 601872 608378 618393 619606 628261 632340 632901 633092 633406 637318 643423 645844 649437 650113 650948 651536 651731 652881 657536 660283 661653 666492 669896 669941 674202 678780 683698 686338 689988 700907 703218 704613 705478 708226 713940 722360 729204 731119 737106 740567 742536 745936 754638 757003 757239 760315 761944 763052 764268 768025 768234 769122 774774 778448 782831 801810 801937 803886 804239 805234 807028 807825 810087 810390 810484 811319 811914 812038 812529 812551 813791 816147 819665 823778 823890 824000 824103 824663 825582 826873 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbation toilet"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк мастурбац туалет"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.