Query Metrics
7
Database Queries
7
Different statements
202.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.99 ms (85.46%) |
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 409046 410874 411398 416912 417121 418083 422345 423434 423706 423880 424228 424353 424491 425485 425921 427997 432228 433436 434407 434885 435962 436441 436849 437114 437302 439345 439382 442408 442482 442663 442857 443599 448545 450473 451725 453834 455213 456743 458435 459275 462758 463699 464224 465906 467852 470503 471523 475618 478016 478157 479036 481174 483967 483982 484897 485363 486091 488000 489296 489662 492807 492989 499266 500157 506519 507792 508677 509406 509945 512025 515314 515839 517458 518606 521109 523428 523972 526036 526627 528206 529094 529508 530166 547731 548436 549769 551563 552514 552822 555938 557677 560252 562072 562708 563592 564380 564688 569469 569471 572409 572439 572755 573500 575789 578967 581453 582579 587843 590706 591898 594048 602332 603417 612302 638841 639096 664987 672744 719807 738826 ] |
||||||||||||||||||||||||||||||
|
19.52 ms (9.64%) |
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 563592 569471 581453 547731 551563 552822 562072 562708 572755 575789 582579 548436 552514 557677 578967 664987 719807 564380 564688 572439 573500 602332 587843 591898 594048 603417 639096 738826 612302 409046 425921 436849 439345 453834 478016 418083 434885 435962 467852 479036 481174 411398 423880 424228 424491 434407 436441 463699 464224 470503 437302 442408 450473 459275 471523 478157 529094 483967 488000 492807 499266 507792 512025 485363 492989 509945 515839 521109 526036 526627 529508 530166 483982 486091 489662 508677 509406 515314 518606 549769 424353 572409 638841 465906 475618 423434 433436 443599 456743 489296 458435 448545 517458 523972 560252 569469 672744 555938 590706 422345 437114 462758 425485 442857 455213 500157 484897 506519 523428 528206 416912 410874 432228 427997 417121 442663 423706 439382 442482 451725 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.28%) |
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 409046 410874 411398 416912 417121 418083 422345 423434 423706 423880 424228 424353 424491 425485 425921 427997 432228 433436 434407 434885 435962 436441 436849 437114 437302 439345 439382 442408 442482 442663 442857 443599 448545 450473 451725 453834 455213 456743 458435 459275 462758 463699 464224 465906 467852 470503 471523 475618 478016 478157 479036 481174 483967 483982 484897 485363 486091 488000 489296 489662 492807 492989 499266 500157 506519 507792 508677 509406 509945 512025 515314 515839 517458 518606 521109 523428 523972 526036 526627 528206 529094 529508 530166 547731 548436 549769 551563 552514 552822 555938 557677 560252 562072 562708 563592 564380 564688 569469 569471 572409 572439 572755 573500 575789 578967 581453 582579 587843 590706 591898 594048 602332 603417 612302 638841 639096 664987 672744 719807 738826 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в черной"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в черная"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.66%) |
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.