Query Metrics
7
Database Queries
7
Different statements
168.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.75 ms (81.70%) |
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 391092 392820 395723 395753 395757 396234 403464 404412 404459 404612 407089 412299 424505 425809 431361 434676 441019 442387 443963 445500 446743 447890 449384 451552 452324 452641 455596 456745 457770 460392 461394 462280 462547 462886 463456 464737 469073 470280 470482 470654 472300 473179 473308 473594 474016 474025 474473 474942 476419 479064 479593 482292 483440 484721 485066 485475 486435 487313 492336 497052 497185 500636 504196 504232 506141 506148 507275 509913 510558 512086 512274 512369 513445 518334 518357 520025 520972 523395 523954 523992 524729 524833 524838 525377 526006 527340 527560 527731 542770 550232 552220 556520 556851 558474 559386 559532 559692 560019 562311 568349 568733 569895 570407 571618 572120 573501 573810 574520 574878 575511 576364 597154 599055 607389 625677 653463 654739 655725 657368 659593 ] |
||||||||||||||||||||||||||||||
|
20.75 ms (12.31%) |
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 574878 575511 597154 455596 463456 473308 474942 476419 396234 403464 461394 462547 462886 479593 395723 470280 404412 434676 472300 456745 500636 504196 504232 523954 524833 497052 513445 518334 525377 486435 497185 506141 507275 512274 520025 524729 524838 487313 510558 520972 392820 404612 404459 464737 474025 452641 473179 462280 512369 559532 560019 570407 576364 556851 552220 654739 550232 599055 625677 395753 479064 460392 412299 441019 451552 470482 470654 523992 506148 512086 485475 518357 526006 527340 527731 407089 446743 449384 445500 457770 482292 559386 568733 569895 542770 559692 571618 568349 657368 659593 556520 562311 607389 391092 474016 424505 443963 442387 447890 452324 473594 527560 484721 492336 509913 483440 485066 523395 395757 431361 425809 474473 469073 573501 574520 558474 572120 573810 653463 655725 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.62%) |
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 391092 392820 395723 395753 395757 396234 403464 404412 404459 404612 407089 412299 424505 425809 431361 434676 441019 442387 443963 445500 446743 447890 449384 451552 452324 452641 455596 456745 457770 460392 461394 462280 462547 462886 463456 464737 469073 470280 470482 470654 472300 473179 473308 473594 474016 474025 474473 474942 476419 479064 479593 482292 483440 484721 485066 485475 486435 487313 492336 497052 497185 500636 504196 504232 506141 506148 507275 509913 510558 512086 512274 512369 513445 518334 518357 520025 520972 523395 523954 523992 524729 524833 524838 525377 526006 527340 527560 527731 542770 550232 552220 556520 556851 558474 559386 559532 559692 560019 562311 568349 568733 569895 570407 571618 572120 573501 573810 574520 574878 575511 576364 597154 599055 607389 625677 653463 654739 655725 657368 659593 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"парочка"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парочк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
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.