Query Metrics
7
Database Queries
7
Different statements
366.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.88 ms (57.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
129.29 ms (35.24%) |
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 182232 195768 208554 256821 382205 383500 385618 387749 398073 401861 410217 414124 419609 439993 442064 444395 446796 449921 468661 471091 471455 475920 486772 499930 505137 513830 514085 515423 521540 525489 529296 529632 529713 531580 531582 531839 531879 534443 535963 539470 539639 545453 547485 547502 561346 568501 573183 580139 584183 584301 589408 590255 597029 599477 600915 602329 607683 614957 624942 628104 634109 634750 640262 642149 648704 653028 658816 660394 662026 668305 669016 669880 671002 671020 679093 680484 687347 709937 713194 721521 738461 738501 738515 738820 739124 740523 744983 745087 745092 745111 749215 749672 752630 752639 752669 758163 760598 766266 766941 771887 777849 781326 784217 784310 784701 785109 785816 792726 796071 799759 804939 806834 806924 810776 811723 813206 813487 814140 827287 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (4.72%) |
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 539639 514085 539470 505137 547502 599477 471091 385618 414124 208554 814140 449921 499930 529713 531580 545453 568501 671002 648704 660394 669016 671020 658816 662026 668305 600915 628104 634109 602329 796071 745092 784701 792726 745111 752669 749672 752630 752639 806834 382205 383500 439993 468661 547485 580139 471455 442064 182232 444395 513830 515423 525489 531839 573183 584183 771887 401861 398073 680484 590255 419609 561346 584301 387749 446796 614957 624942 630427 589408 785109 256821 195768 410217 827287 486772 475920 521540 529296 529632 535963 531582 531879 534443 653028 669880 687347 709937 679093 713194 721521 642149 607683 634750 640262 597029 777849 784217 785816 799759 781326 784310 806924 810776 813487 738501 740523 744983 749215 760598 804939 811723 813206 738820 739124 758163 766941 766266 738461 738515 745087 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (0.72%) |
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 182232 195768 208554 256821 382205 383500 385618 387749 398073 401861 410217 414124 419609 439993 442064 444395 446796 449921 468661 471091 471455 475920 486772 499930 505137 513830 514085 515423 521540 525489 529296 529632 529713 531580 531582 531839 531879 534443 535963 539470 539639 545453 547485 547502 561346 568501 573183 580139 584183 584301 589408 590255 597029 599477 600915 602329 607683 614957 624942 628104 634109 634750 640262 642149 648704 653028 658816 660394 662026 668305 669016 669880 671002 671020 679093 680484 687347 709937 713194 721521 738461 738501 738515 738820 739124 740523 744983 745087 745092 745111 749215 749672 752630 752639 752669 758163 760598 766266 766941 771887 777849 781326 784217 784310 784701 785109 785816 792726 796071 799759 804939 806834 806924 810776 811723 813206 813487 814140 827287 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo huge dildo"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.