Query Metrics
7
Database Queries
7
Different statements
160.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.94 ms (84.04%) |
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 7161 32620 32937 69821 81810 96297 147280 196166 196306 227502 382188 382330 382662 384332 384422 385081 386796 387344 388379 390362 393049 393267 393677 394597 396554 396728 397232 397981 398416 400967 402110 403909 409680 412593 413929 414021 415586 415883 452226 456048 460309 468790 478653 486067 489276 497894 501290 506100 507872 510024 514237 514415 515572 517288 519253 521136 522407 524196 529883 530666 531085 531811 531915 533283 533476 533569 534056 534567 536167 536177 536475 536597 536741 537750 539064 540942 542690 545465 547386 554257 564241 564247 564249 571015 574372 575087 596208 598844 600972 605762 610029 623920 631504 633514 639715 651955 665404 672636 677295 694556 711291 716724 734099 742428 750775 759624 763292 784932 786461 789463 792753 795665 801975 803458 805494 809605 817210 821411 823766 827831 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (9.18%) |
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 596208 784932 413929 575087 415883 403909 631504 412593 623920 507872 605762 521136 598844 387344 32937 564241 750775 529883 547386 533476 786461 147280 196166 734099 803458 69821 539064 801975 792753 393677 415586 633514 452226 382330 397981 534567 486067 468790 823766 536741 542690 386796 805494 789463 809605 759624 400967 510024 711291 506100 531915 795665 610029 382188 672636 763292 536167 564249 533569 531811 393049 385081 651955 522407 694556 515572 384422 574372 81810 564247 639715 393267 409680 396554 414021 396728 716724 227502 665404 397232 390362 402110 456048 460309 398416 536177 517288 519253 32620 514415 600972 524196 677295 96297 821411 827831 537750 534056 536597 540942 554257 388379 478653 501290 531085 536475 545465 742428 196306 489276 530666 7161 533283 497894 394597 817210 382662 514237 571015 384332 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.88%) |
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 7161 32620 32937 69821 81810 96297 147280 196166 196306 227502 382188 382330 382662 384332 384422 385081 386796 387344 388379 390362 393049 393267 393677 394597 396554 396728 397232 397981 398416 400967 402110 403909 409680 412593 413929 414021 415586 415883 452226 456048 460309 468790 478653 486067 489276 497894 501290 506100 507872 510024 514237 514415 515572 517288 519253 521136 522407 524196 529883 530666 531085 531811 531915 533283 533476 533569 534056 534567 536167 536177 536475 536597 536741 537750 539064 540942 542690 545465 547386 554257 564241 564247 564249 571015 574372 575087 596208 598844 600972 605762 610029 623920 631504 633514 639715 651955 665404 672636 677295 694556 711291 716724 734099 742428 750775 759624 763292 784932 786461 789463 792753 795665 801975 803458 805494 809605 817210 821411 823766 827831 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор большой большие член"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme big dick"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.10%) |
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.