Query Metrics
7
Database Queries
7
Different statements
186.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.33 ms (85.33%) |
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 382650 383354 386781 391110 395848 406217 409822 410079 410814 411132 412841 413617 414940 415036 418375 419426 421550 423563 423853 424179 425479 425565 428374 434837 435688 435743 440951 441289 441689 441691 441714 443225 445057 452740 453467 453478 453549 455367 455554 456019 456248 456317 457958 459015 459832 463178 463244 463358 465675 468590 475260 475708 475872 476489 482746 485605 485948 487090 490214 491526 491537 491543 492622 494098 494382 496923 499705 499818 501839 502373 504440 505853 506848 507840 510740 512038 517243 519928 523244 523728 524155 524382 524393 525228 525402 526792 527305 527616 527623 528756 536201 551204 551419 552932 555774 556714 562242 562304 567753 569840 571127 571780 573633 576221 576833 578181 578360 583536 585973 606289 622535 677691 679566 685757 694618 700685 713386 719418 734155 749015 ] |
||||||||||||||||||||||||||||||
|
17.99 ms (9.63%) |
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 423563 435743 434837 443225 428374 414940 463358 492622 453478 456019 456317 476489 494098 506848 551419 555774 424179 475260 455554 501839 524382 524393 487090 510740 491537 494382 504440 505853 452740 576221 418375 459015 551204 573633 713386 382650 567753 719418 734155 571780 485605 578181 441691 441289 499818 445057 556714 576833 578360 677691 552932 585973 383354 453549 459832 525402 496923 536201 409822 435688 455367 468590 523728 523244 526792 517243 524155 499705 583536 527616 606289 423853 391110 412841 419426 410814 465675 485948 475872 507840 410079 463178 525228 386781 425479 441689 421550 440951 482746 463244 456248 490214 700685 395848 406217 413617 441714 453467 457958 475708 411132 512038 519928 527623 491526 528756 491543 527305 502373 679566 685757 569840 571127 749015 425565 415036 694618 562242 562304 622535 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.33%) |
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 382650 383354 386781 391110 395848 406217 409822 410079 410814 411132 412841 413617 414940 415036 418375 419426 421550 423563 423853 424179 425479 425565 428374 434837 435688 435743 440951 441289 441689 441691 441714 443225 445057 452740 453467 453478 453549 455367 455554 456019 456248 456317 457958 459015 459832 463178 463244 463358 465675 468590 475260 475708 475872 476489 482746 485605 485948 487090 490214 491526 491537 491543 492622 494098 494382 496923 499705 499818 501839 502373 504440 505853 506848 507840 510740 512038 517243 519928 523244 523728 524155 524382 524393 525228 525402 526792 527305 527616 527623 528756 536201 551204 551419 552932 555774 556714 562242 562304 567753 569840 571127 571780 573633 576221 576833 578181 578360 583536 585973 606289 622535 677691 679566 685757 694618 700685 713386 719418 734155 749015 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пизд а член"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин член"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин член"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.81%) |
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.