Query Metrics
7
Database Queries
7
Different statements
156.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.44 ms (80.73%) |
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 403588 414126 425829 428139 435158 437443 438283 444337 449356 459397 464341 464413 467859 471088 471848 472910 474662 475543 476203 478049 482620 483134 488359 490427 492133 494312 503154 508275 509983 512447 512479 515370 515663 516462 516741 525088 527001 527742 532504 537946 540071 541846 541863 544788 553927 565783 567457 569829 572259 574386 575324 576604 583723 584667 586480 590411 592776 598122 598225 598654 600251 600321 600965 601324 601636 603705 604369 604811 607398 615800 617032 617137 617416 617423 621489 623334 632693 634856 637042 637706 637741 639823 640691 642063 650992 668534 670951 674780 676162 677674 678095 681637 696499 718695 718745 732068 733204 763724 779618 790794 804464 805420 807386 811296 814808 815963 825864 ] |
||||||||||||||||||||||||||||||
|
19.18 ms (12.25%) |
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 640691 779618 437443 464341 467859 476203 490427 814808 825864 482620 488359 515663 527001 537946 567457 584667 718745 575324 576604 604811 637706 592776 600965 617032 637042 586480 601636 600251 603705 790794 811296 732068 763724 623334 414126 428139 475543 459397 464413 483134 492133 503154 512479 525088 515370 815963 494312 532504 553927 574386 674780 676162 569829 572259 637741 639823 604369 805420 807386 617416 718695 403588 444337 438283 435158 449356 471848 527742 540071 544788 541846 668534 677674 650992 598122 590411 598225 600321 733204 804464 425829 474662 471088 472910 509983 478049 541863 670951 696499 642063 617137 632693 607398 634856 516462 681637 516741 678095 583723 615800 621489 512447 508275 598654 601324 617423 565783 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.81%) |
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 403588 414126 425829 428139 435158 437443 438283 444337 449356 459397 464341 464413 467859 471088 471848 472910 474662 475543 476203 478049 482620 483134 488359 490427 492133 494312 503154 508275 509983 512447 512479 515370 515663 516462 516741 525088 527001 527742 532504 537946 540071 541846 541863 544788 553927 565783 567457 569829 572259 574386 575324 576604 583723 584667 586480 590411 592776 598122 598225 598654 600251 600321 600965 601324 601636 603705 604369 604811 607398 615800 617032 617137 617416 617423 621489 623334 632693 634856 637042 637706 637741 639823 640691 642063 650992 668534 670951 674780 676162 677674 678095 681637 696499 718695 718745 732068 733204 763724 779618 790794 804464 805420 807386 811296 814808 815963 825864 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom all"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom for all"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom all"
]
|
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.