Query Metrics
7
Database Queries
7
Different statements
162.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.93 ms (85.48%) |
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 12546 77051 96118 393868 395262 395393 398486 400019 402020 417940 466484 479496 486645 494062 494409 516019 524027 529259 535185 537400 547672 551051 574524 575591 579737 583086 583528 583592 584074 615059 617601 620324 636958 639699 646139 646579 649166 650881 652338 659055 660329 660629 663907 664536 668710 669240 672629 673711 675869 677746 678339 682379 684238 684943 685262 687796 690541 692092 698226 706348 706508 707093 708451 709797 713622 715109 715230 715384 717499 717726 718156 719969 720797 723269 746808 750330 754584 754630 761342 762651 763895 765422 766806 769767 773751 777021 778896 779683 780061 781623 783386 783997 787567 788906 790037 790531 791154 792165 800355 801861 803920 806858 810279 813510 814433 814502 817400 820385 820444 820855 821116 823971 824198 824415 825297 826154 827429 828445 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (8.00%) |
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 400019 479496 529259 494062 494409 537400 668710 583592 636958 417940 524027 395262 402020 826154 814502 817400 820855 824198 824415 827429 828445 466484 516019 575591 547672 664536 672629 673711 677746 692092 713622 717499 706508 723269 663907 675869 706348 715230 574524 617601 620324 615059 639699 778896 779683 781623 783997 791154 810279 780061 790037 800355 813510 750330 754630 758948 783386 787567 788906 790531 792165 806858 762651 744999 763895 766806 746808 765422 754584 761342 769767 773751 707093 777021 801861 803920 395393 96118 393868 77051 12546 398486 814433 820385 823971 825297 820444 821116 486645 535185 584074 551051 579737 583086 646139 646579 652338 715384 717726 719969 720797 649166 650881 659055 660329 660629 669240 678339 682379 684238 684943 685262 687796 690541 698226 708451 709797 715109 718156 583528 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (2.07%) |
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 12546 77051 96118 393868 395262 395393 398486 400019 402020 417940 466484 479496 486645 494062 494409 516019 524027 529259 535185 537400 547672 551051 574524 575591 579737 583086 583528 583592 584074 615059 617601 620324 636958 639699 646139 646579 649166 650881 652338 659055 660329 660629 663907 664536 668710 669240 672629 673711 675869 677746 678339 682379 684238 684943 685262 687796 690541 692092 698226 706348 706508 707093 708451 709797 713622 715109 715230 715384 717499 717726 718156 719969 720797 723269 746808 750330 754584 754630 761342 762651 763895 765422 766806 769767 773751 777021 778896 779683 780061 781623 783386 783997 787567 788906 790037 790531 791154 792165 800355 801861 803920 806858 810279 813510 814433 814502 817400 820385 820444 820855 821116 823971 824198 824415 825297 826154 827429 828445 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen fucked"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen fucked"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen fucked"
]
|
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.