Query Metrics
7
Database Queries
7
Different statements
145.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.07 ms (81.09%) |
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 91379 96341 109313 130089 130289 320078 381883 387218 388097 388492 390466 391070 397273 397302 403141 414360 424634 425181 447038 448874 530788 530792 530837 532779 534631 534650 536210 536285 536287 536290 536339 536344 544508 597271 599893 599928 601548 601593 601636 603269 604331 604383 604868 604890 613375 617652 629886 630678 630679 630857 636070 637042 640771 640858 641413 642016 645850 649543 649595 651082 656904 666579 671712 671739 673363 673366 680121 680142 683301 684126 690809 692796 693194 696355 704525 704953 705144 715497 720127 725612 741269 745245 748357 752989 756023 758099 760240 775140 775787 775818 775848 775858 775960 775967 784308 784908 786007 790382 795139 801934 801950 801958 801975 802343 802610 805587 805594 810061 810823 811459 814893 815121 815875 817346 817841 818160 820771 821532 824130 827201 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (11.29%) |
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 320078 381883 91379 690809 666579 673363 673366 692796 802610 805594 760240 642016 544508 604890 705144 824130 827201 814893 820771 536210 651082 715497 696355 649543 684126 613375 640858 775787 801950 775140 801934 810823 745245 784308 790382 795139 748357 756023 775818 397302 109313 130089 424634 448874 656904 629886 775858 810061 536287 536344 391070 630678 725612 641413 388492 414360 821532 447038 530792 671739 617652 630679 397273 534650 775848 388097 604331 536290 530837 530788 640771 390466 403141 815121 704525 704953 597271 599928 775960 775967 801958 425181 818160 815875 817346 817841 683301 693194 671712 680142 720127 645850 680121 599893 630857 601548 601593 784908 786007 801975 802343 758099 752989 604383 636070 805587 811459 534631 603269 637042 601636 741269 532779 536285 536339 649595 604868 130289 96341 387218 ] |
||||||||||||||||||||||||||||||
|
3.99 ms (2.74%) |
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 91379 96341 109313 130089 130289 320078 381883 387218 388097 388492 390466 391070 397273 397302 403141 414360 424634 425181 447038 448874 530788 530792 530837 532779 534631 534650 536210 536285 536287 536290 536339 536344 544508 597271 599893 599928 601548 601593 601636 603269 604331 604383 604868 604890 613375 617652 629886 630678 630679 630857 636070 637042 640771 640858 641413 642016 645850 649543 649595 651082 656904 666579 671712 671739 673363 673366 680121 680142 683301 684126 690809 692796 693194 696355 704525 704953 705144 715497 720127 725612 741269 745245 748357 752989 756023 758099 760240 775140 775787 775818 775848 775858 775960 775967 784308 784908 786007 790382 795139 801934 801950 801958 801975 802343 802610 805587 805594 810061 810823 811459 814893 815121 815875 817346 817841 818160 820771 821532 824130 827201 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал 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.