Query Metrics
7
Database Queries
7
Different statements
172.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.55 ms (82.65%) |
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 4229 313187 396393 397385 404590 408206 409093 410683 424653 429416 433808 434455 435551 445238 446967 454868 457463 459411 469092 474798 477876 485061 489127 492136 499821 499915 515364 515849 521361 523133 524171 524910 526165 528849 532061 533963 534959 535835 541587 542090 547734 547738 549236 556657 565257 566760 567054 567097 570405 576680 580319 581454 581597 584244 585145 585380 592015 592857 593270 598864 603242 603897 607123 608637 627726 630028 638688 650195 664854 682071 685686 689305 695867 701253 705710 712106 714036 714730 716225 732547 733645 738202 738528 739985 744299 745078 756425 757883 758587 758910 776822 778471 789963 792904 792936 794609 797637 797788 797944 798509 799256 799383 799542 800510 801299 801742 802364 802505 805777 809354 810823 811325 813552 814335 815865 816115 817319 817768 818998 820529 ] |
||||||||||||||||||||||||||||||
|
17.15 ms (9.94%) |
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 664854 682071 685686 689305 695867 712106 714036 716225 567097 581597 585145 585380 592857 593270 598864 603242 607123 592015 608637 627726 630028 638688 778471 789963 797637 799256 799542 805777 811325 776822 794609 797944 809354 810823 733645 797788 801742 802364 732547 739985 757883 758910 738202 744299 756425 758587 745078 738528 603897 701253 705710 714730 792904 792936 798509 799383 800510 801299 802505 4229 313187 396393 410683 454868 477876 404590 429416 474798 409093 424653 445238 515849 521361 541587 485061 397385 433808 408206 434455 435551 820529 813552 816115 817319 818998 814335 815865 817768 457463 459411 469092 446967 489127 492136 515364 523133 535835 532061 499821 499915 526165 534959 524171 524910 528849 533963 542090 549236 567054 581454 584244 547738 556657 566760 570405 576680 580319 547734 565257 650195 ] |
||||||||||||||||||||||||||||||
|
4.78 ms (2.77%) |
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 4229 313187 396393 397385 404590 408206 409093 410683 424653 429416 433808 434455 435551 445238 446967 454868 457463 459411 469092 474798 477876 485061 489127 492136 499821 499915 515364 515849 521361 523133 524171 524910 526165 528849 532061 533963 534959 535835 541587 542090 547734 547738 549236 556657 565257 566760 567054 567097 570405 576680 580319 581454 581597 584244 585145 585380 592015 592857 593270 598864 603242 603897 607123 608637 627726 630028 638688 650195 664854 682071 685686 689305 695867 701253 705710 712106 714036 714730 716225 732547 733645 738202 738528 739985 744299 745078 756425 757883 758587 758910 776822 778471 789963 792904 792936 794609 797637 797788 797944 798509 799256 799383 799542 800510 801299 801742 802364 802505 805777 809354 810823 811325 813552 814335 815865 816115 817319 817768 818998 820529 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking mom"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking mom"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking mom"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.