Query Metrics
7
Database Queries
7
Different statements
201.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.75 ms (88.18%) |
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 76853 81496 123257 406046 460370 486860 494539 507929 519251 542082 545851 563686 563967 573250 573915 574051 577314 584722 595313 599628 624377 624762 641524 642154 648009 649731 670412 671697 675167 679287 689407 689917 702386 710108 713311 716268 718620 719240 720562 721991 725394 725453 726126 727649 728988 741943 741994 742277 754213 755004 755324 758944 759854 761480 765962 768461 768577 768625 768643 770088 770637 771336 773776 780062 782661 782705 783167 783266 784635 788561 790265 791609 791872 793028 793147 794117 794377 794407 794959 794972 795876 796046 796137 797524 800159 800353 801798 803062 803301 805628 808104 810859 813032 817955 818808 819793 823718 824494 824716 825356 825464 825660 825837 826080 826164 826229 826376 826412 826575 826622 827034 827098 828235 828237 828439 828543 828549 828691 828763 828778 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (6.67%) |
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 794407 803062 791872 794117 725453 761480 768625 768643 784635 794959 800353 801798 741994 755004 758944 771336 741943 754213 727649 728988 755324 759854 765962 768577 770637 773776 788561 793147 796046 808104 813032 519251 542082 545851 584722 624762 642154 460370 486860 76853 123257 81496 406046 823718 826229 826376 826575 826412 825837 826622 817955 818808 819793 824716 827034 827098 825464 826080 826164 824494 825356 825660 828778 828237 828235 828763 828543 828691 828549 828439 494539 507929 573250 577314 563967 574051 573915 648009 649731 671697 702386 710108 713311 716268 718620 675167 689407 719240 670412 679287 689917 720562 721991 563686 599628 595313 641524 624377 782661 782705 794377 795876 780062 783266 790265 791609 796137 725394 742277 770088 783167 793028 794972 797524 800159 803301 805628 810859 726126 768461 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.61%) |
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 76853 81496 123257 406046 460370 486860 494539 507929 519251 542082 545851 563686 563967 573250 573915 574051 577314 584722 595313 599628 624377 624762 641524 642154 648009 649731 670412 671697 675167 679287 689407 689917 702386 710108 713311 716268 718620 719240 720562 721991 725394 725453 726126 727649 728988 741943 741994 742277 754213 755004 755324 758944 759854 761480 765962 768461 768577 768625 768643 770088 770637 771336 773776 780062 782661 782705 783167 783266 784635 788561 790265 791609 791872 793028 793147 794117 794377 794407 794959 794972 795876 796046 796137 797524 800159 800353 801798 803062 803301 805628 808104 810859 813032 817955 818808 819793 823718 824494 824716 825356 825464 825660 825837 826080 826164 826229 826376 826412 826575 826622 827034 827098 828235 828237 828439 828543 828549 828691 828763 828778 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum and"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.