Query Metrics
7
Database Queries
7
Different statements
149.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.30 ms (83.81%) |
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 387014 390707 414259 416448 416696 416901 417035 418411 419213 422460 422908 425023 425420 427221 429802 431463 432122 433516 435027 435558 435822 438873 446461 448524 449586 451316 452417 452746 454283 455569 458303 459599 460765 463332 468404 468426 468949 469100 470840 470855 471132 471753 472767 472845 475748 476710 476784 479838 480452 481903 482828 483537 483710 483749 484720 489441 490639 490675 491232 491474 495480 497338 497887 498643 500780 506098 506408 507559 510170 513472 516431 516937 517727 518066 523153 523529 534065 536379 539216 546155 546510 551340 560585 564417 566741 570436 575872 576397 576657 577100 581048 583172 585863 588935 589589 591627 594866 596638 598533 599571 606438 632931 656956 657268 657282 659526 698855 716044 719326 740930 761111 778112 785750 789533 793884 795902 797373 819100 823403 826957 ] |
||||||||||||||||||||||||||||||
|
14.49 ms (9.69%) |
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 427221 449586 490675 446461 470855 471132 510170 536379 476784 560585 606438 588935 594866 596638 435822 431463 468404 523153 534065 497887 518066 484720 500780 506098 506408 491474 498643 719326 416901 422460 433516 475748 490639 452746 483537 448524 452417 539216 570436 583172 551340 581048 657282 546510 585863 598533 793884 789533 632931 454283 471753 463332 455569 495480 432122 416696 480452 451316 472845 460765 468949 507559 576397 577100 564417 414259 469100 387014 470840 482828 513472 497338 517727 523529 425023 516431 516937 591627 419213 826957 458303 489441 483749 546155 575872 656956 698855 589589 599571 785750 795902 761111 716044 778112 417035 425420 459599 390707 659526 797373 416448 422908 472767 429802 418411 435027 491232 740930 657268 819100 438873 435558 823403 468426 479838 481903 483710 476710 576657 566741 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.52%) |
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 387014 390707 414259 416448 416696 416901 417035 418411 419213 422460 422908 425023 425420 427221 429802 431463 432122 433516 435027 435558 435822 438873 446461 448524 449586 451316 452417 452746 454283 455569 458303 459599 460765 463332 468404 468426 468949 469100 470840 470855 471132 471753 472767 472845 475748 476710 476784 479838 480452 481903 482828 483537 483710 483749 484720 489441 490639 490675 491232 491474 495480 497338 497887 498643 500780 506098 506408 507559 510170 513472 516431 516937 517727 518066 523153 523529 534065 536379 539216 546155 546510 551340 560585 564417 566741 570436 575872 576397 576657 577100 581048 583172 585863 588935 589589 591627 594866 596638 598533 599571 606438 632931 656956 657268 657282 659526 698855 716044 719326 740930 761111 778112 785750 789533 793884 795902 797373 819100 823403 826957 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long girl"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные девушк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
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.