Query Metrics
7
Database Queries
7
Different statements
569.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
417.32 ms (73.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum close up"
]
|
||||||||||||||||||||||||||||||
|
129.59 ms (22.77%) |
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 386735 392624 420655 424012 443443 449459 452732 452753 459122 466458 469026 473118 498723 499517 504803 505359 506649 507273 522749 531383 541061 542509 546360 553242 554208 554349 555469 562482 563792 565472 568917 583744 583808 609998 620585 622272 624599 627721 630146 631745 646902 649558 653070 653117 656872 660028 666447 673420 680094 690050 691982 693848 695896 695914 696116 696605 697400 704998 706438 714149 715566 720345 722123 722162 725617 730079 731134 732176 732605 739496 742276 743824 744576 744730 745197 746440 747962 750458 754113 761341 762584 763802 765365 767824 771914 773601 774245 780965 782686 783271 783471 792167 792359 793754 793826 794712 795346 795349 797935 801354 802001 804695 811280 816811 819758 819828 820468 823875 824091 824140 825104 825352 825389 826263 826464 826580 827138 828193 828793 ] |
||||||||||||||||||||||||||||||
|
13.16 ms (2.31%) |
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 546360 542509 583808 562482 673420 680094 695896 695914 696116 690050 553242 563792 609998 631745 622272 624599 627721 620585 797935 802001 742276 774245 739496 706438 715566 811280 473118 386735 443443 449459 469026 452732 459122 452753 420655 499517 498723 504803 506649 507273 505359 783471 466458 660028 666447 693848 697400 629530 783271 793826 732605 754113 765365 714149 780965 424012 820468 827138 646902 653070 804695 794712 795349 392624 816811 823875 824140 826580 825104 825389 819758 819828 824091 826263 826464 825352 828793 828193 522749 531383 565472 568917 541061 554208 555469 554349 583744 649558 696605 653117 704998 720345 722123 656872 691982 722162 630146 792167 793754 801354 792359 795346 725617 731134 732176 743824 750458 767824 782686 746440 761341 762584 773601 744730 747962 730079 744576 745197 763802 771914 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (0.53%) |
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 386735 392624 420655 424012 443443 449459 452732 452753 459122 466458 469026 473118 498723 499517 504803 505359 506649 507273 522749 531383 541061 542509 546360 553242 554208 554349 555469 562482 563792 565472 568917 583744 583808 609998 620585 622272 624599 627721 630146 631745 646902 649558 653070 653117 656872 660028 666447 673420 680094 690050 691982 693848 695896 695914 696116 696605 697400 704998 706438 714149 715566 720345 722123 722162 725617 730079 731134 732176 732605 739496 742276 743824 744576 744730 745197 746440 747962 750458 754113 761341 762584 763802 765365 767824 771914 773601 774245 780965 782686 783271 783471 792167 792359 793754 793826 794712 795346 795349 797935 801354 802001 804695 811280 816811 819758 819828 820468 823875 824091 824140 825104 825352 825389 826263 826464 826580 827138 828193 828793 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum close up"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum close up"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.31%) |
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.