Query Metrics
7
Database Queries
7
Different statements
150.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.88 ms (83.80%) |
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 366354 393298 396314 400453 400493 402101 407296 407320 408313 411694 417643 418948 418971 421658 429105 431452 435468 447611 453129 455354 455864 456065 457458 458378 458777 461065 461098 465001 467854 472249 474989 479685 484088 485698 499968 504050 509836 510907 512873 513131 515225 516793 523803 523808 524146 530632 545739 556690 558019 559236 559791 561314 561356 564132 566075 572975 575473 577705 593900 594644 594863 598871 611299 617660 619221 624291 627724 628063 636338 639908 644959 655462 668540 709257 714494 716073 717189 722718 723175 725613 726486 726689 726696 730098 731884 732029 732086 738367 741116 744683 751877 761459 764352 767359 771023 774000 776638 786455 787616 788573 790213 790888 791362 791368 791704 792634 795757 796072 796118 798990 799801 800535 803222 804011 805331 806722 807301 810774 814699 814701 ] |
||||||||||||||||||||||||||||||
|
15.23 ms (10.14%) |
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 627724 628063 593900 791704 795757 803222 804011 805331 791368 800535 741116 791362 796072 796118 732029 732086 767359 738367 764352 771023 726696 730098 731884 744683 751877 774000 725613 726486 726689 761459 776638 786455 787616 790213 792634 798990 807301 407296 421658 431452 455354 455864 400453 407320 456065 400493 417643 418948 418971 458777 461098 411694 435468 447611 472249 479685 515225 516793 524146 504050 484088 393298 366354 396314 402101 408313 429105 644959 814701 814699 453129 461065 465001 485698 458378 474989 457458 510907 513131 523803 499968 530632 509836 512873 523808 467854 558019 559236 566075 545739 559791 561356 577705 717189 723175 655462 668540 709257 722718 714494 716073 556690 561314 564132 572975 575473 611299 594644 639908 619221 624291 636338 594863 598871 617660 799801 806722 810774 788573 790888 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.60%) |
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 366354 393298 396314 400453 400493 402101 407296 407320 408313 411694 417643 418948 418971 421658 429105 431452 435468 447611 453129 455354 455864 456065 457458 458378 458777 461065 461098 465001 467854 472249 474989 479685 484088 485698 499968 504050 509836 510907 512873 513131 515225 516793 523803 523808 524146 530632 545739 556690 558019 559236 559791 561314 561356 564132 566075 572975 575473 577705 593900 594644 594863 598871 611299 617660 619221 624291 627724 628063 636338 639908 644959 655462 668540 709257 714494 716073 717189 722718 723175 725613 726486 726689 726696 730098 731884 732029 732086 738367 741116 744683 751877 761459 764352 767359 771023 774000 776638 786455 787616 788573 790213 790888 791362 791368 791704 792634 795757 796072 796118 798990 799801 800535 803222 804011 805331 806722 807301 810774 814699 814701 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old cum in"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old cum"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old cum"
]
|
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.