Query Metrics
7
Database Queries
7
Different statements
161.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.23 ms (84.39%) |
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 204605 383149 391049 407517 411342 412957 414940 417028 419018 420293 421151 421735 424926 428772 428979 429169 432889 435728 437555 446137 446900 448745 449096 452086 454258 460976 464457 465592 466806 467378 467896 472902 473226 473474 474761 485747 485941 491828 498290 501693 503165 505650 508142 512587 517026 517356 518054 518867 519336 521459 525402 525490 527016 534212 535059 536637 538203 543413 545670 549170 549433 568306 569953 576676 582767 584062 586486 591135 597689 599217 602743 603201 607155 611315 615810 619424 647669 676538 677322 680934 688003 699574 700328 710318 712804 725303 725367 727624 730933 736999 738020 759731 765444 766043 770464 772719 774158 779237 788514 790856 790957 793221 799206 805128 806203 806239 808613 815245 815288 815591 815920 816620 817466 817628 818325 818939 819823 822385 822986 825187 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (10.08%) |
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 437555 446900 448745 525490 534212 518867 582767 545670 710318 474761 454258 491828 521459 446137 535059 619424 766043 383149 421151 591135 725367 576676 549433 676538 699574 808613 825187 816620 818939 817466 712804 788514 793221 738020 806203 817628 819823 680934 700328 615810 727624 765444 736999 770464 790957 460976 677322 725303 464457 569953 429169 465592 508142 498290 473226 512587 538203 452086 467896 518054 519336 411342 435728 584062 815288 822385 815920 391049 428772 407517 417028 414940 815591 818325 822986 525402 517026 543413 647669 599217 607155 730933 774158 428979 473474 419018 467378 449096 421735 485941 688003 586486 602743 603201 527016 779237 799206 805128 806239 204605 412957 505650 790856 759731 472902 815245 466806 772719 517356 568306 549170 611315 597689 424926 503165 501693 536637 485747 432889 420293 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.63%) |
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 204605 383149 391049 407517 411342 412957 414940 417028 419018 420293 421151 421735 424926 428772 428979 429169 432889 435728 437555 446137 446900 448745 449096 452086 454258 460976 464457 465592 466806 467378 467896 472902 473226 473474 474761 485747 485941 491828 498290 501693 503165 505650 508142 512587 517026 517356 518054 518867 519336 521459 525402 525490 527016 534212 535059 536637 538203 543413 545670 549170 549433 568306 569953 576676 582767 584062 586486 591135 597689 599217 602743 603201 607155 611315 615810 619424 647669 676538 677322 680934 688003 699574 700328 710318 712804 725303 725367 727624 730933 736999 738020 759731 765444 766043 770464 772719 774158 779237 788514 790856 790957 793221 799206 805128 806203 806239 808613 815245 815288 815591 815920 816620 817466 817628 818325 818939 819823 822385 822986 825187 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits lick"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ лиза"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.