Query Metrics
7
Database Queries
7
Different statements
180.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.04 ms (87.23%) |
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 381783 391275 399511 409596 419804 422307 424199 434670 436139 443480 443590 444279 445879 447125 451999 453125 454101 454676 455351 455485 456722 458578 459316 459389 460854 462481 462991 463344 464024 464133 465773 466165 466610 470509 471508 472284 472439 472906 479644 483966 484342 486304 487189 487917 489279 489283 490268 491679 492538 496478 499043 499581 500469 503468 503730 504250 504684 504780 505627 507101 508246 509322 510591 510832 511464 513909 516919 518252 518456 520057 520870 522126 522839 523823 524283 524344 524567 525261 525994 526397 527088 527495 527885 528699 530741 539771 543883 548704 552067 554262 555716 556703 557648 558804 562734 564420 564860 565411 565953 567362 568618 572469 578477 580299 594866 596407 598417 599140 603902 615587 618673 622406 630243 647678 652526 653547 654369 655582 672574 676154 ] |
||||||||||||||||||||||||||||||
|
12.39 ms (6.88%) |
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 618673 526397 451999 447125 496478 527088 543883 455485 443590 486304 504250 487917 445879 483966 399511 548704 557648 580299 564420 654369 630243 594866 599140 489279 524567 596407 565411 524283 556703 652526 672574 572469 491679 647678 622406 464133 443480 455351 530741 523823 520870 381783 419804 436139 466610 454676 500469 539771 518456 503730 513909 479644 522839 524344 525261 422307 472284 520057 503468 504684 578477 552067 564860 655582 676154 554262 567362 615587 499581 653547 598417 568618 558804 444279 460854 490268 507101 508246 528699 462991 391275 453125 459316 499043 511464 565953 555716 603902 458578 466165 424199 459389 434670 472439 505627 518252 487189 525994 527885 510832 527495 454101 472906 456722 462481 522126 562734 409596 465773 470509 471508 463344 464024 509322 516919 484342 489283 492538 510591 504780 ] |
||||||||||||||||||||||||||||||
|
4.18 ms (2.32%) |
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 381783 391275 399511 409596 419804 422307 424199 434670 436139 443480 443590 444279 445879 447125 451999 453125 454101 454676 455351 455485 456722 458578 459316 459389 460854 462481 462991 463344 464024 464133 465773 466165 466610 470509 471508 472284 472439 472906 479644 483966 484342 486304 487189 487917 489279 489283 490268 491679 492538 496478 499043 499581 500469 503468 503730 504250 504684 504780 505627 507101 508246 509322 510591 510832 511464 513909 516919 518252 518456 520057 520870 522126 522839 523823 524283 524344 524567 525261 525994 526397 527088 527495 527885 528699 530741 539771 543883 548704 552067 554262 555716 556703 557648 558804 562734 564420 564860 565411 565953 567362 568618 572469 578477 580299 594866 596407 598417 599140 603902 615587 618673 622406 630243 647678 652526 653547 654369 655582 672574 676154 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член в шорт"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член в шорт"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.