Query Metrics
7
Database Queries
7
Different statements
152.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.36 ms (82.19%) |
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 14599 91510 214988 384042 384082 386892 400365 406488 408983 415093 415718 429815 446350 451650 459821 459823 460233 461585 470234 470334 470784 472960 478765 482608 483478 484872 487475 493263 494379 495211 501316 501492 501622 504672 505285 510506 523271 523598 528028 538417 546054 547842 550341 553107 553666 554355 558375 559604 561725 564960 576307 577718 585254 587331 595554 595580 595613 598541 602069 603943 604084 604137 606038 608426 617185 617617 620547 620808 621248 624879 632279 642527 649226 650098 651810 652129 652925 655359 656732 657066 658091 663224 663240 672992 673057 673430 675821 676191 676579 676769 682683 683724 684307 685399 687039 691292 692945 695872 696123 703656 705316 709492 709807 715899 716932 721417 724143 727673 733873 733902 735103 740709 788904 797817 801026 803267 806683 813268 821487 823000 ] |
||||||||||||||||||||||||||||||
|
17.49 ms (11.47%) |
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 564960 617617 788904 801026 727673 384042 406488 510506 483478 493263 429815 823000 482608 470234 487475 523598 505285 494379 504672 501622 550341 547842 650098 682683 695872 673057 673430 675821 709807 585254 803267 724143 733902 740709 797817 806683 735103 733873 602069 617185 624879 642527 813268 91510 470784 214988 384082 400365 470334 478765 408983 415718 451650 459821 459823 461585 472960 415093 460233 501316 501492 538417 523271 484872 528028 14599 386892 821487 446350 495211 553666 558375 561725 577718 554355 546054 553107 559604 649226 651810 652925 655359 672992 676191 683724 684307 685399 687039 656732 657066 658091 663224 663240 676579 676769 705316 709492 716932 652129 691292 692945 696123 703656 715899 721417 576307 595554 603943 608426 620547 587331 598541 621248 595580 595613 604084 604137 606038 620808 632279 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.71%) |
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 14599 91510 214988 384042 384082 386892 400365 406488 408983 415093 415718 429815 446350 451650 459821 459823 460233 461585 470234 470334 470784 472960 478765 482608 483478 484872 487475 493263 494379 495211 501316 501492 501622 504672 505285 510506 523271 523598 528028 538417 546054 547842 550341 553107 553666 554355 558375 559604 561725 564960 576307 577718 585254 587331 595554 595580 595613 598541 602069 603943 604084 604137 606038 608426 617185 617617 620547 620808 621248 624879 632279 642527 649226 650098 651810 652129 652925 655359 656732 657066 658091 663224 663240 672992 673057 673430 675821 676191 676579 676769 682683 683724 684307 685399 687039 691292 692945 695872 696123 703656 705316 709492 709807 715899 716932 721417 724143 727673 733873 733902 735103 740709 788904 797817 801026 803267 806683 813268 821487 823000 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute big"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute большие"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute большие"
]
|
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.