Query Metrics
7
Database Queries
7
Different statements
593.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
347.72 ms (58.62%) |
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 393298 398680 420000 423996 430225 433501 442479 442892 442925 449270 450321 451523 453425 453935 456329 457569 457975 458981 460093 461804 465551 466381 466780 467667 468604 468806 475285 475499 475512 478207 478220 478356 479600 480668 487553 491680 493453 494725 495257 495444 496822 496942 497730 498358 498420 501047 503056 505566 505643 509645 511362 512487 512835 515622 518808 519611 519664 519953 520510 520929 523132 524373 524681 525540 525863 526984 527806 527810 528748 528839 528925 535535 543254 544564 546487 550240 551616 551787 555723 556722 558075 558923 559724 563741 563744 564988 565955 566331 574153 575539 575928 578721 579471 579648 579821 584463 586912 587974 590683 597753 598249 604288 607432 612121 612441 642515 646105 675053 675093 675127 675441 675654 675691 676423 679294 685625 714487 727959 764761 771148 ] |
||||||||||||||||||||||||||||||
|
217.71 ms (36.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие doggystyle"
]
|
||||||||||||||||||||||||||||||
|
18.12 ms (3.05%) |
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 604288 475499 480668 420000 449270 467667 479600 423996 453935 460093 466780 468604 475512 478207 466381 468806 478220 519611 524681 493453 511362 512487 520510 495257 496822 501047 505643 520929 523132 525863 496942 497730 509645 512835 519664 527806 527810 494725 543254 528925 456329 457975 491680 535535 764761 430225 498358 487553 393298 450321 478356 457569 458981 528839 579648 676423 607432 727959 771148 453425 442892 398680 461804 451523 524373 498420 528748 433501 526984 475285 646105 612121 586912 597753 598249 465551 519953 525540 503056 515622 518808 442479 442925 505566 495444 544564 546487 555723 558923 563741 563744 566331 575539 575928 584463 551616 551787 559724 564988 565955 578721 579821 550240 579471 675093 685625 714487 675441 675654 675053 675127 675691 679294 556722 558075 574153 612441 642515 587974 590683 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (0.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 393298 398680 420000 423996 430225 433501 442479 442892 442925 449270 450321 451523 453425 453935 456329 457569 457975 458981 460093 461804 465551 466381 466780 467667 468604 468806 475285 475499 475512 478207 478220 478356 479600 480668 487553 491680 493453 494725 495257 495444 496822 496942 497730 498358 498420 501047 503056 505566 505643 509645 511362 512487 512835 515622 518808 519611 519664 519953 520510 520929 523132 524373 524681 525540 525863 526984 527806 527810 528748 528839 528925 535535 543254 544564 546487 550240 551616 551787 555723 556722 558075 558923 559724 563741 563744 564988 565955 566331 574153 575539 575928 578721 579471 579648 579821 584463 586912 587974 590683 597753 598249 604288 607432 612121 612441 642515 646105 675053 675093 675127 675441 675654 675691 676423 679294 685625 714487 727959 764761 771148 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big doggystyle"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие doggystyle"
]
|
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.