Query Metrics
7
Database Queries
7
Different statements
159.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.87 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang piss"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.01 ms |
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 631194 633446 701310 651082 712712 649543 784254 811270 784308 741862 784161 633736 642025 635275 543652 550207 542549 634774 600297 615717 637036 635215 642705 698133 630635 651062 656499 748951 545389 545409 676428 707391 680176 628332 639719 630552 550200 645973 679025 552938 637096 632586 635277 788257 545418 549514 579351 651051 565248 637065 639735 643122 599950 784259 748931 632655 642700 542583 678144 651079 702927 600332 597266 600352 601517 632694 633478 541197 546993 647635 651599 676623 630522 642018 627807 820759 647936 666535 647993 580264 632649 635224 627808 633775 540572 675001 557676 632595 632585 695123 ] |
||||||||||||||||||||||||||||||
| 4 | 2.66 ms |
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 540572 541197 542549 542583 543652 545389 545409 545418 546993 549514 550200 550207 552938 557676 565248 579351 580264 597266 599950 600297 600332 600352 601517 615717 627807 627808 628332 630522 630552 630635 631194 632585 632586 632595 632649 632655 632694 633446 633478 633736 633775 634774 635215 635224 635275 635277 637036 637065 637096 639719 639735 642018 642025 642700 642705 643122 645973 647635 647936 647993 649543 651051 651062 651079 651082 651599 656499 666535 675001 676428 676623 678144 679025 680176 695123 698133 701310 702927 707391 712712 741862 748931 748951 784161 784254 784259 784308 788257 811270 820759 ] |
||||||||||||||||||||||||||||||
| 5 | 131.39 ms |
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 540572 541197 542549 542583 543652 545389 545409 545418 546993 549514 550200 550207 552938 557676 565248 579351 580264 597266 599950 600297 600332 600352 601517 615717 627807 627808 628332 630522 630552 630635 631194 632585 632586 632595 632649 632655 632694 633446 633478 633736 633775 634774 635215 635224 635275 635277 637036 637065 637096 639719 639735 642018 642025 642700 642705 643122 645973 647635 647936 647993 649543 651051 651062 651079 651082 651599 656499 666535 675001 676428 676623 678144 679025 680176 695123 698133 701310 702927 707391 712712 741862 748931 748951 784161 784254 784259 784308 788257 811270 820759 ] |
||||||||||||||||||||||||||||||
| 6 | 1.91 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang писсинг"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.69 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.