Query Metrics
7
Database Queries
7
Different statements
203.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.20 ms (85.22%) |
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 390624 396168 402683 422550 433572 448537 451523 467428 467973 468091 476079 478771 483328 484554 487262 487872 489237 490851 491319 494693 497953 499852 500455 502680 506264 507834 508538 509135 510070 512099 516780 517000 519993 520310 521043 521871 522585 524492 525391 525878 530064 535094 535306 535937 538007 538290 545725 549823 551989 552294 557034 558127 558468 558524 558640 561275 562995 565572 569562 573074 573603 573981 579527 580706 582258 586533 587933 591247 591249 594400 598161 598724 598838 599216 601846 601867 601906 601995 602010 603812 604021 604364 608407 608553 611616 613210 613359 613396 613401 614649 614717 616905 617641 618334 618335 619519 619794 619965 620048 621112 621239 621454 621489 622407 622838 623235 624131 624776 625437 625441 625533 626302 626485 636248 636250 651937 655410 659216 662445 663347 ] |
||||||||||||||||||||||||||||||
|
19.86 ms (9.77%) |
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 591247 591249 601995 604021 613210 614649 619794 622838 599216 601867 601906 626485 625441 402683 467428 467973 476079 509135 520310 502680 535937 535094 558127 651937 624131 489237 522585 662445 613396 497953 491319 510070 549823 552294 558468 569562 573074 573603 573981 545725 558640 579527 580706 557034 586533 433572 390624 468091 451523 500455 516780 494693 507834 521871 525391 525878 490851 506264 535306 487872 512099 538007 562995 582258 551989 655410 659216 663347 558524 565572 611616 621454 622407 623235 625437 625533 636250 594400 598724 598838 601846 603812 614717 616905 621112 621239 621489 587933 598161 613401 618335 619965 620048 626302 608407 608553 613359 617641 618334 624776 602010 604364 619519 636248 396168 478771 521043 538290 483328 519993 484554 508538 524492 530064 499852 517000 422550 448537 487262 561275 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.53%) |
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 390624 396168 402683 422550 433572 448537 451523 467428 467973 468091 476079 478771 483328 484554 487262 487872 489237 490851 491319 494693 497953 499852 500455 502680 506264 507834 508538 509135 510070 512099 516780 517000 519993 520310 521043 521871 522585 524492 525391 525878 530064 535094 535306 535937 538007 538290 545725 549823 551989 552294 557034 558127 558468 558524 558640 561275 562995 565572 569562 573074 573603 573981 579527 580706 582258 586533 587933 591247 591249 594400 598161 598724 598838 599216 601846 601867 601906 601995 602010 603812 604021 604364 608407 608553 611616 613210 613359 613396 613401 614649 614717 616905 617641 618334 618335 619519 619794 619965 620048 621112 621239 621454 621489 622407 622838 623235 624131 624776 625437 625441 625533 626302 626485 636248 636250 651937 655410 659216 662445 663347 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"не встал"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"не встал"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"не встал"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.