Query Metrics
7
Database Queries
7
Different statements
222.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.81 ms (88.44%) |
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 24158 144379 387773 389208 407646 407657 419131 426404 437868 449021 462484 468038 479860 480367 480368 480382 502487 505396 523051 525249 528538 532357 533426 534288 534312 534377 536370 544686 564129 596571 603344 605093 606748 612053 613855 614515 621635 629961 632018 632023 632333 634824 637681 637758 638282 638292 638357 638360 663561 663566 668377 683313 695101 712695 712696 712698 720747 723443 727482 746256 746339 756395 767948 775351 788815 788882 792637 793628 793642 793660 793665 797656 797659 800879 803069 803074 805379 808444 809930 814816 814901 814903 815173 815204 815230 815231 815335 815368 815482 815483 815530 815537 815575 815764 815770 815780 815812 815822 815860 815902 815903 815931 816054 816071 816202 816385 816523 816865 816910 816929 816933 816944 816955 816987 822959 828282 828420 828633 828856 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (7.49%) |
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 815931 815368 712698 663561 638282 746256 387773 407646 695101 712695 723443 637681 638292 727482 788882 814901 814903 480382 534288 536370 525249 534312 564129 606748 596571 756395 629961 809930 621635 808444 792637 797659 528538 532357 534377 815530 663566 683313 638357 793642 800879 805379 746339 788815 797656 637758 793628 468038 407657 437868 533426 544686 815483 462484 720747 632018 613855 632023 634824 638360 775351 803069 523051 828282 614515 828856 814816 668377 605093 603344 793660 793665 767948 803074 479860 419131 505396 815204 632333 426404 480368 480367 815812 449021 612053 389208 502487 815902 815482 144379 815860 815770 816385 828420 712696 816929 815822 815231 815903 815764 816523 828633 24158 815335 816071 816202 816865 816910 815780 816054 816987 822959 815173 815537 815575 815947 816933 816944 816955 815230 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.20%) |
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 24158 144379 387773 389208 407646 407657 419131 426404 437868 449021 462484 468038 479860 480367 480368 480382 502487 505396 523051 525249 528538 532357 533426 534288 534312 534377 536370 544686 564129 596571 603344 605093 606748 612053 613855 614515 621635 629961 632018 632023 632333 634824 637681 637758 638282 638292 638357 638360 663561 663566 668377 683313 695101 712695 712696 712698 720747 723443 727482 746256 746339 756395 767948 775351 788815 788882 792637 793628 793642 793660 793665 797656 797659 800879 803069 803074 805379 808444 809930 814816 814901 814903 815173 815204 815230 815231 815335 815368 815482 815483 815530 815537 815575 815764 815770 815780 815812 815822 815860 815902 815903 815931 816054 816071 816202 816385 816523 816865 816910 816929 816933 816944 816955 816987 822959 828282 828420 828633 828856 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers 2023"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers"
]
|
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.