Query Metrics
7
Database Queries
7
Different statements
187.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.57 ms (86.37%) |
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 383464 411246 422270 426549 433718 439680 450143 450181 451502 452146 453308 453838 454048 456128 456551 459947 462148 462351 462572 467682 469967 474467 474831 476630 477904 479673 482843 483421 483607 485929 486539 488441 495394 495808 498388 499327 502579 506318 507757 509620 510172 513686 515260 517527 521166 524376 525557 528466 531511 531963 531967 532133 534579 549745 549748 549844 554225 555320 555417 555461 555930 555987 560869 564816 566854 567683 571107 578442 579876 587566 591906 596529 598631 602534 604374 605999 607258 607529 610013 610962 619070 636396 637511 642354 660115 670234 701224 710264 715058 715871 754156 757237 762994 765025 765297 767271 769422 770331 779202 786195 789005 789496 798637 803789 804512 805685 807480 810130 812108 814823 819021 820313 821010 823244 823471 824572 825762 826557 826650 827887 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (8.66%) |
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 770331 637511 803789 531511 591906 528466 825762 502579 482843 450181 453838 495808 439680 426549 452146 479673 549844 549748 549745 564816 767271 462572 566854 579876 578442 462351 521166 495394 798637 483607 607258 498388 670234 610013 560869 422270 710264 779202 819021 826557 820313 814823 823244 824572 827887 485929 525557 531963 532133 515260 517527 531967 483421 555320 555461 701224 715058 715871 571107 587566 598631 607529 642354 610962 810130 789005 757237 769422 807480 765025 805685 812108 486539 513686 789496 474467 510172 456128 383464 459947 454048 450143 476630 462148 467682 555417 567683 660115 602534 636396 596529 754156 605999 477904 451502 499327 488441 506318 821010 469967 554225 765297 604374 433718 804512 474831 534579 524376 509620 762994 453308 555987 555930 456551 411246 823471 826650 507757 619070 786195 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.42%) |
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 383464 411246 422270 426549 433718 439680 450143 450181 451502 452146 453308 453838 454048 456128 456551 459947 462148 462351 462572 467682 469967 474467 474831 476630 477904 479673 482843 483421 483607 485929 486539 488441 495394 495808 498388 499327 502579 506318 507757 509620 510172 513686 515260 517527 521166 524376 525557 528466 531511 531963 531967 532133 534579 549745 549748 549844 554225 555320 555417 555461 555930 555987 560869 564816 566854 567683 571107 578442 579876 587566 591906 596529 598631 602534 604374 605999 607258 607529 610013 610962 619070 636396 637511 642354 660115 670234 701224 710264 715058 715871 754156 757237 762994 765025 765297 767271 769422 770331 779202 786195 789005 789496 798637 803789 804512 805685 807480 810130 812108 814823 819021 820313 821010 823244 823471 824572 825762 826557 826650 827887 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature pov blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature пов минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature пов минет оральн секс"
]
|
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.