Query Metrics
8
Database Queries
8
Different statements
440.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.62 ms (48.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
202.93 ms (46.02%) |
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 204545 381742 386783 391965 405143 424651 458066 461397 488564 533569 537817 550535 565969 566051 570202 572479 580561 581329 585782 586006 613150 617272 624800 640451 646211 652099 660072 662899 663904 667274 670987 673217 685416 686069 697553 697828 701487 704022 714015 715701 720811 721160 725447 728974 729304 729740 731711 733537 734990 735486 738872 741582 742831 742898 743799 746618 747601 755925 755978 759480 759796 761380 763424 764696 765229 766179 766257 766776 767278 770380 773193 774204 774533 776325 776769 776970 779114 781854 783162 784246 785622 787458 787802 789591 789604 790508 791219 792011 792415 792420 794714 795858 796732 796795 797539 797881 799282 799715 800871 802605 802881 804269 805914 806004 806698 806774 807545 810264 810280 811950 813457 814761 816053 817878 817942 820377 820685 824995 825495 827520 ] |
||||||||||||||||||||||||||||||
|
11.49 ms (2.61%) |
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 386783 461397 673217 405143 817878 488564 566051 685416 662899 652099 813457 738872 741582 729740 742831 747601 640451 550535 799282 806698 424651 779114 806004 790508 811950 746618 585782 783162 787802 458066 204545 381742 814761 817942 820377 825495 827520 820685 824995 537817 572479 570202 667274 701487 714015 646211 670987 697553 704022 721160 663904 720811 581329 613150 617272 784246 789591 789604 796795 799715 776325 785622 787458 797881 804269 725447 765229 767278 794714 796732 800871 802881 807545 810264 810280 761380 770380 773193 728974 763424 759796 766179 729304 731711 734990 759480 764696 766257 766776 774204 715701 776769 776970 805914 806774 391965 686069 816053 533569 580561 697828 660072 565969 624800 586006 781854 792420 795858 797539 774533 791219 792011 792415 802605 733537 735486 742898 755925 743799 755978 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (0.68%) |
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 204545 381742 386783 391965 405143 424651 458066 461397 488564 533569 537817 550535 565969 566051 570202 572479 580561 581329 585782 586006 613150 617272 624800 640451 646211 652099 660072 662899 663904 667274 670987 673217 685416 686069 697553 697828 701487 704022 714015 715701 720811 721160 725447 728974 729304 729740 731711 733537 734990 735486 738872 741582 742831 742898 743799 746618 747601 755925 755978 759480 759796 761380 763424 764696 765229 766179 766257 766776 767278 770380 773193 774204 774533 776325 776769 776970 779114 781854 783162 784246 785622 787458 787802 789591 789604 790508 791219 792011 792415 792420 794714 795858 796732 796795 797539 797881 799282 799715 800871 802605 802881 804269 805914 806004 806698 806774 807545 810264 810280 811950 813457 814761 816053 817878 817942 820377 820685 824995 825495 827520 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.47%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”\x07t\eq%¬æ\x00,[;¬"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.40%) |
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.