Query Metrics
7
Database Queries
7
Different statements
173.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.59 ms (85.41%) |
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 233504 391881 396064 398714 398784 402219 408489 410741 412528 414647 418034 424493 425748 425889 428402 429591 429959 432211 435263 438838 439049 439376 441759 442155 443428 443754 444128 444198 444247 446077 447083 447518 449000 451484 451700 453586 456262 458738 459600 460029 461150 461776 462728 465332 467758 469899 469900 470334 473905 473979 477137 477908 479033 479088 479283 479613 480028 480831 481061 481187 482095 482763 482767 483233 483373 484577 487006 490597 491438 494111 498900 500391 503706 504251 508035 510652 512643 512650 513282 516151 522461 525938 538376 538419 541734 546659 552211 552248 558599 560942 561669 562226 562976 563206 563584 563993 570040 570051 570198 570204 570259 570280 570307 570418 570506 570646 572363 572467 573543 573596 573675 573711 573826 573954 574588 578997 581360 587055 596670 598553 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (8.55%) |
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 396064 398784 435263 447518 459600 391881 429591 439376 453586 460029 479283 408489 443754 447083 516151 483233 498900 504251 508035 513282 522461 483373 487006 525938 538376 512643 512650 482763 570051 570418 598553 596670 443428 233504 410741 444128 465332 467758 473979 479033 425748 432211 438838 412528 414647 451700 510652 484577 494111 500391 482767 469899 481061 469900 477137 479088 482095 558599 562976 563206 570040 570646 572363 573543 573596 581360 552211 563584 570198 570506 572467 573675 573711 573954 574588 546659 561669 563993 570259 570280 570307 552248 560942 562226 570204 573826 578997 587055 428402 462728 479613 480028 441759 449000 461150 470334 402219 425889 439049 461776 473905 477908 481187 398714 418034 424493 429959 442155 444198 444247 480831 446077 451484 456262 458738 491438 503706 538419 541734 490597 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.82%) |
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 233504 391881 396064 398714 398784 402219 408489 410741 412528 414647 418034 424493 425748 425889 428402 429591 429959 432211 435263 438838 439049 439376 441759 442155 443428 443754 444128 444198 444247 446077 447083 447518 449000 451484 451700 453586 456262 458738 459600 460029 461150 461776 462728 465332 467758 469899 469900 470334 473905 473979 477137 477908 479033 479088 479283 479613 480028 480831 481061 481187 482095 482763 482767 483233 483373 484577 487006 490597 491438 494111 498900 500391 503706 504251 508035 510652 512643 512650 513282 516151 522461 525938 538376 538419 541734 546659 552211 552248 558599 560942 561669 562226 562976 563206 563584 563993 570040 570051 570198 570204 570259 570280 570307 570418 570506 570646 572363 572467 573543 573596 573675 573711 573826 573954 574588 578997 581360 587055 596670 598553 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худая руская"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая русск"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
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.