Query Metrics
7
Database Queries
7
Different statements
149.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.64 ms (84.49%) |
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 263752 389208 399609 407657 426404 437868 449021 462484 468038 477210 479860 480367 480368 480382 502487 505396 528538 532164 533426 534274 534316 534377 535023 544686 564129 596571 603344 612053 613855 614515 621635 632018 632333 633166 634824 637758 638357 638360 643113 668377 695101 712696 713564 720747 727482 746339 767948 775351 792637 793642 793660 793665 797656 800879 803069 803074 805379 806205 808444 814890 814901 814903 815193 815204 815230 815231 815321 815335 815342 815407 815424 815500 815507 815530 815537 815551 815554 815575 815612 815622 815704 815726 815770 815812 815813 815844 815859 815860 815891 815902 815918 815931 815993 816054 816071 816074 816202 816207 816297 816367 816384 816397 816532 816564 816865 816910 816913 816927 816928 816929 816944 816955 822959 828282 828420 828633 828748 828856 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (8.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 815931 800879 797656 621635 462484 814903 480382 564129 596571 528538 534377 634824 814890 534274 534316 535023 532164 713564 633166 643113 695101 727482 638357 793642 805379 468038 437868 632018 775351 803069 533426 544686 613855 808444 792637 814901 603344 828856 803074 815530 746339 637758 407657 614515 505396 828282 668377 793665 479860 720747 638360 815204 632333 426404 793660 767948 480368 480367 815812 612053 449021 815575 828748 712696 24158 815902 816071 816865 816944 806205 815860 815770 828420 816927 816929 815231 828633 389208 502487 815342 815622 815859 816207 816913 815335 816202 816910 816054 822959 815537 815947 816955 815230 815407 815918 816397 815844 477210 815507 399609 263752 815424 815612 815704 815321 815891 816384 815500 815813 816297 816532 816928 815193 815551 815554 815726 815993 816074 816367 816564 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.78%) |
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 263752 389208 399609 407657 426404 437868 449021 462484 468038 477210 479860 480367 480368 480382 502487 505396 528538 532164 533426 534274 534316 534377 535023 544686 564129 596571 603344 612053 613855 614515 621635 632018 632333 633166 634824 637758 638357 638360 643113 668377 695101 712696 713564 720747 727482 746339 767948 775351 792637 793642 793660 793665 797656 800879 803069 803074 805379 806205 808444 814890 814901 814903 815193 815204 815230 815231 815321 815335 815342 815407 815424 815500 815507 815530 815537 815551 815554 815575 815612 815622 815704 815726 815770 815812 815813 815844 815859 815860 815891 815902 815918 815931 815993 816054 816071 816074 816202 816207 816297 816367 816384 816397 816532 816564 816865 816910 816913 816927 816928 816929 816944 816955 822959 828282 828420 828633 828748 828856 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers tits"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
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.