Query Metrics
7
Database Queries
7
Different statements
160.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.83 ms (85.19%) |
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 33715 58636 66217 68618 197442 203742 210349 219957 234067 382085 382318 393274 407830 408435 408912 429491 479724 521449 532577 533506 533820 536490 537741 542858 546477 613819 631332 643975 644200 644255 646248 648742 651253 672378 673125 682602 684917 690461 693064 714169 720528 723750 723983 724261 726325 726580 729674 736029 736051 736459 738081 738104 745196 746673 749362 749376 749393 750843 752221 752252 752259 752353 752896 752924 756369 757447 760112 767484 768411 769326 770536 772329 774627 775523 776685 776867 777811 781343 782636 784180 787335 788152 788349 789053 790808 797861 798311 799144 799160 800714 801237 802409 802574 802634 805949 807623 812980 813851 814557 816955 817021 817710 818171 818287 818593 819081 819250 820015 820142 821108 822814 822919 823130 824654 825521 827886 827905 827911 ] |
||||||||||||||||||||||||||||||
|
13.31 ms (8.29%) |
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 746673 760112 772329 768411 736051 787335 807623 210349 197442 817710 824654 818171 820142 827905 827911 537741 542858 646248 672378 682602 684917 644200 774627 729674 752896 631332 802574 66217 673125 723750 724261 782636 802634 736459 644255 752221 749362 767484 736029 738104 818287 818593 819250 822814 825521 816955 817021 819081 820015 822919 823130 813851 821108 827886 479724 521449 533506 546477 720528 648742 690461 693064 643975 776867 799144 776744 781343 749376 752353 770536 784180 788152 789053 790808 797861 726580 738081 755279 745196 750843 752252 752259 757447 749393 756369 776685 777811 788349 799160 613819 68618 58636 407830 382318 769326 234067 203742 393274 33715 408435 429491 814557 532577 775523 801237 802409 800714 805949 723983 726325 752924 798311 812980 408912 382085 219957 533820 536490 714169 651253 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (2.14%) |
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 33715 58636 66217 68618 197442 203742 210349 219957 234067 382085 382318 393274 407830 408435 408912 429491 479724 521449 532577 533506 533820 536490 537741 542858 546477 613819 631332 643975 644200 644255 646248 648742 651253 672378 673125 682602 684917 690461 693064 714169 720528 723750 723983 724261 726325 726580 729674 736029 736051 736459 738081 738104 745196 746673 749362 749376 749393 750843 752221 752252 752259 752353 752896 752924 756369 757447 760112 767484 768411 769326 770536 772329 774627 775523 776685 776867 777811 781343 782636 784180 787335 788152 788349 789053 790808 797861 798311 799144 799160 800714 801237 802409 802574 802634 805949 807623 812980 813851 814557 816955 817021 817710 818171 818287 818593 819081 819250 820015 820142 821108 822814 822919 823130 824654 825521 827886 827905 827911 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопы сиськи"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.93%) |
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.