Query Metrics
7
Database Queries
7
Different statements
222.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.44 ms (85.66%) |
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 391437 402632 410242 413432 416022 416192 416512 416614 417396 418219 418521 424556 424721 426399 429692 432179 434364 434374 436942 444794 445493 446241 448575 449086 450889 452923 452937 455132 455217 458761 460012 469431 471148 473203 476082 476668 477125 477757 477762 478055 493249 493837 495566 497888 499922 500340 500341 500734 500799 508882 508968 511379 512975 513223 515435 517710 517807 521425 521637 522231 527237 529988 536393 541258 541832 541839 547242 556426 556885 561970 564383 568379 569133 569656 573748 575366 577062 578258 583508 584301 585079 585446 585826 585951 586821 588228 589836 590804 593292 595209 595471 596779 596857 597691 597750 598406 601861 602183 604387 604426 604731 605745 613356 613976 615918 617045 617047 621252 621737 622693 632169 637460 650598 661510 675897 683083 696485 724997 760209 823695 ] |
||||||||||||||||||||||||||||||
|
21.21 ms (9.54%) |
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 588228 597750 613356 596857 595209 432179 434374 452923 418219 416614 434364 455132 517807 413432 536393 458761 515435 500340 500734 500341 529988 556426 569133 577062 604426 605745 452937 511379 477757 495566 521425 615918 450889 410242 561970 589836 617045 617047 418521 508882 477762 547242 573748 585951 602183 613976 601861 417396 426399 416512 449086 471148 476082 541839 578258 661510 621252 585446 632169 598406 604387 445493 521637 493837 478055 569656 585826 508968 575366 597691 604731 637460 477125 586821 683083 584301 460012 541258 564383 675897 444794 585079 473203 455217 512975 500799 568379 402632 595471 424721 556885 823695 424556 527237 650598 590804 622693 583508 593292 621737 499922 696485 448575 429692 446241 517710 416192 541832 760209 724997 391437 416022 436942 497888 493249 469431 522231 513223 476668 596779 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (1.69%) |
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 391437 402632 410242 413432 416022 416192 416512 416614 417396 418219 418521 424556 424721 426399 429692 432179 434364 434374 436942 444794 445493 446241 448575 449086 450889 452923 452937 455132 455217 458761 460012 469431 471148 473203 476082 476668 477125 477757 477762 478055 493249 493837 495566 497888 499922 500340 500341 500734 500799 508882 508968 511379 512975 513223 515435 517710 517807 521425 521637 522231 527237 529988 536393 541258 541832 541839 547242 556426 556885 561970 564383 568379 569133 569656 573748 575366 577062 578258 583508 584301 585079 585446 585826 585951 586821 588228 589836 590804 593292 595209 595471 596779 596857 597691 597750 598406 601861 602183 604387 604426 604731 605745 613356 613976 615918 617045 617047 621252 621737 622693 632169 637460 650598 661510 675897 683083 696485 724997 760209 823695 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло анальная дрочка"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло анал дрочк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло анал дрочк"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.69%) |
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.