Query Metrics
7
Database Queries
7
Different statements
175.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.12 ms (82.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 418013 422270 422380 423317 423330 424387 425523 425990 426653 428158 428164 430623 430633 431476 432582 433359 433375 436933 437346 437632 439612 439689 439693 442505 442805 443215 443357 444269 446148 446988 448644 448669 448672 448687 448763 449717 451576 453473 453558 454846 455044 458923 459877 460282 461599 462545 465009 468531 470817 473799 476590 482254 484108 486185 486587 487150 495317 500384 503753 504962 509312 509324 512103 512988 513095 513564 517831 520801 520826 520966 521166 521447 521783 522434 526819 527128 527908 528216 531512 533278 540794 547821 547824 549027 549569 552702 557594 559164 560188 561236 562060 562136 566257 566951 575889 576103 578509 579495 579669 580326 587416 590865 596417 598243 598786 601234 602604 608787 609133 617322 625225 630766 650056 658935 693965 795757 805558 807340 809668 820871 ] |
||||||||||||||||||||||||||||||
|
20.31 ms (11.59%) |
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 575889 579669 561236 547821 547824 557594 579495 693965 650056 658935 559164 566951 596417 598786 587416 598243 602604 609133 617322 601234 625225 807340 809668 473799 476590 431476 448763 462545 422380 423330 424387 433359 451576 454846 482254 444269 468531 470817 428164 442505 453473 500384 504962 512988 517831 520801 528216 484108 503753 509324 520966 486587 495317 560188 527908 422270 430623 448644 425523 448669 433375 443357 428158 425990 436933 820871 448687 449717 453558 458923 446148 455044 522434 526819 527128 531512 461599 562136 549027 552702 566257 576103 590865 630766 805558 418013 423317 437632 437346 432582 446988 442805 426653 439612 439689 439693 487150 509312 513095 513564 521166 540794 521447 533278 578509 795757 443215 486185 512103 430633 465009 448672 459877 520826 521783 460282 562060 580326 549569 608787 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.56%) |
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 418013 422270 422380 423317 423330 424387 425523 425990 426653 428158 428164 430623 430633 431476 432582 433359 433375 436933 437346 437632 439612 439689 439693 442505 442805 443215 443357 444269 446148 446988 448644 448669 448672 448687 448763 449717 451576 453473 453558 454846 455044 458923 459877 460282 461599 462545 465009 468531 470817 473799 476590 482254 484108 486185 486587 487150 495317 500384 503753 504962 509312 509324 512103 512988 513095 513564 517831 520801 520826 520966 521166 521447 521783 522434 526819 527128 527908 528216 531512 533278 540794 547821 547824 549027 549569 552702 557594 559164 560188 561236 562060 562136 566257 566951 575889 576103 578509 579495 579669 580326 587416 590865 596417 598243 598786 601234 602604 608787 609133 617322 625225 630766 650056 658935 693965 795757 805558 807340 809668 820871 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov young"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов young"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов young"
]
|
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.