Query Metrics
7
Database Queries
7
Different statements
171.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.22 ms (79.82%) |
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 33917 67242 172420 386043 391594 400489 400845 406128 410390 410543 434353 437793 439727 460773 461282 461318 463780 470468 471458 472868 472879 472953 482338 489952 490904 510064 518762 519585 519940 521843 527873 537263 537267 541804 551916 555170 557240 558036 566774 570972 576628 580950 586965 592548 596872 601930 605209 609968 614881 615571 620258 636005 639593 641708 642226 650312 666852 670364 695733 695799 699404 703471 703533 705359 705449 710018 710410 715891 719544 720171 724996 727343 727732 727764 730973 733375 734373 736099 743829 752121 757312 761027 765311 768000 769887 777420 785915 788592 788983 790093 792733 795702 796945 796957 797174 799695 800537 801175 802028 803457 803656 809293 810297 811470 811480 811697 815151 815849 816112 816184 817293 817508 818368 818409 818833 820156 820159 820550 820947 ] |
||||||||||||||||||||||||||||||
|
24.77 ms (14.41%) |
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 172420 816184 817508 820156 400845 434353 470468 586965 727732 743829 765311 733375 736099 570972 715891 790093 797174 792733 769887 605209 720171 788983 811697 555170 705449 724996 527873 641708 490904 472879 551916 576628 580950 519940 601930 472953 666852 596872 777420 796957 757312 761027 537263 592548 400489 816112 815151 639593 727764 818409 820159 820947 558036 642226 67242 461318 566774 650312 695799 705359 614881 795702 800537 703471 710018 817293 802028 719544 33917 437793 796945 519585 537267 460773 463780 472868 609968 699404 615571 727343 811480 822133 695733 620258 799695 734373 803457 803656 811470 410543 818833 820550 815849 703533 636005 801175 788592 730973 768000 818368 489952 809293 391594 482338 810297 410390 521843 541804 471458 510064 439727 710410 406128 785915 752121 386043 461282 518762 557240 670364 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.39%) |
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 33917 67242 172420 386043 391594 400489 400845 406128 410390 410543 434353 437793 439727 460773 461282 461318 463780 470468 471458 472868 472879 472953 482338 489952 490904 510064 518762 519585 519940 521843 527873 537263 537267 541804 551916 555170 557240 558036 566774 570972 576628 580950 586965 592548 596872 601930 605209 609968 614881 615571 620258 636005 639593 641708 642226 650312 666852 670364 695733 695799 699404 703471 703533 705359 705449 710018 710410 715891 719544 720171 724996 727343 727732 727764 730973 733375 734373 736099 743829 752121 757312 761027 765311 768000 769887 777420 785915 788592 788983 790093 792733 795702 796945 796957 797174 799695 800537 801175 802028 803457 803656 809293 810297 811470 811480 811697 815151 815849 816112 816184 817293 817508 818368 818409 818833 820156 820159 820550 820947 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf maid anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf горничн анал"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf горничн анал"
]
|
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.