Query Metrics
7
Database Queries
7
Different statements
158.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.48 ms (82.33%) |
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 109313 130089 388492 390565 397302 397849 403641 414358 414360 425181 431105 458555 474680 483548 510750 520413 520771 525864 530792 531136 532667 534631 541863 543860 545387 559061 565154 570395 578210 595729 596464 599851 599893 600012 601544 603162 603238 603243 603247 603269 603398 604331 606501 607594 613375 614407 617422 617424 630857 632663 632712 635486 640858 645850 646899 648819 649543 651082 651135 667017 671712 671739 673357 675007 677676 678117 680142 681235 683301 684126 691996 693194 696355 702677 711891 714193 716373 720127 720642 725598 728233 728444 745245 747090 748210 748212 748244 748253 748389 750867 756023 770208 772038 775140 775787 775810 775818 784308 789998 790019 795139 801934 801950 803459 806268 810757 810823 811486 811837 813759 814893 815875 816568 817346 817841 818160 819511 819623 821532 827201 ] |
||||||||||||||||||||||||||||||
|
16.78 ms (10.59%) |
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 819623 827201 814893 816568 570395 651082 720642 691996 696355 711891 714193 716373 648819 649543 684126 603162 635486 601544 613375 614407 640858 775787 775810 789998 801950 810757 775140 801934 810823 745245 784308 795139 806268 811486 728233 750867 728444 747090 770208 756023 775818 397302 109313 130089 397849 545387 603238 604331 599851 603243 748210 803459 748212 748253 772038 725598 543860 483548 520771 531136 541863 565154 678117 702677 646899 675007 677676 617424 632663 458555 525864 603247 431105 559061 606501 748389 474680 532667 520413 617422 403641 414358 813759 534631 667017 651135 600012 603269 632712 790019 811837 748244 390565 510750 388492 425181 414360 818160 819511 815875 817346 817841 821532 530792 578210 683301 693194 671712 671739 680142 681235 720127 645850 673357 599893 607594 595729 630857 596464 603398 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.20%) |
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 109313 130089 388492 390565 397302 397849 403641 414358 414360 425181 431105 458555 474680 483548 510750 520413 520771 525864 530792 531136 532667 534631 541863 543860 545387 559061 565154 570395 578210 595729 596464 599851 599893 600012 601544 603162 603238 603243 603247 603269 603398 604331 606501 607594 613375 614407 617422 617424 630857 632663 632712 635486 640858 645850 646899 648819 649543 651082 651135 667017 671712 671739 673357 675007 677676 678117 680142 681235 683301 684126 691996 693194 696355 702677 711891 714193 716373 720127 720642 725598 728233 728444 745245 747090 748210 748212 748244 748253 748389 750867 756023 770208 772038 775140 775787 775810 775818 784308 789998 790019 795139 801934 801950 803459 806268 810757 810823 811486 811837 813759 814893 815875 816568 817346 817841 818160 819511 819623 821532 827201 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group mature gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group mature gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group mature gangbang"
]
|
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.