Query Metrics
7
Database Queries
7
Different statements
157.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.17 ms (84.97%) |
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 402434 416128 424247 426624 427129 427985 434470 434531 435833 441815 442542 452719 457093 460109 461809 463807 472095 475571 480700 493846 495483 505378 507000 507519 511841 516606 519252 530213 531118 537240 541202 541388 542509 551587 558361 559615 559618 561314 564125 573473 585176 590557 592834 599176 601237 604856 610173 612581 617038 629776 630917 634615 636399 637304 650478 650808 652530 670863 678225 696605 699681 700812 710277 710346 714143 714989 718863 720151 722091 728633 728879 730746 732147 732744 733348 733938 734304 737018 739981 741021 742987 745357 746536 751261 752505 762522 762994 763661 763802 764609 765089 767521 767813 768241 771512 777461 779461 779719 779722 780026 781030 781621 786653 789843 791250 792292 796015 798904 799476 804474 805274 807663 808261 818701 819326 824939 824974 824991 825850 826690 ] |
||||||||||||||||||||||||||||||
|
15.70 ms (9.94%) |
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 818701 733348 734304 551587 435833 700812 585176 807663 599176 507519 728879 573473 519252 558361 541388 779719 825850 652530 764609 733938 714143 798904 786653 732147 472095 779722 630917 710346 426624 463807 457093 789843 434531 427129 434470 542509 732744 461809 475571 564125 424247 604856 460109 427985 537240 516606 507000 495483 416128 559618 601237 505378 493846 561314 805274 511841 541202 531118 767813 696605 737018 730746 634615 699681 718863 792292 765089 763661 762994 637304 670863 617038 710277 779461 824974 636399 559615 480700 720151 799476 610173 781621 763802 530213 751261 781030 745357 819326 612581 650478 442542 742987 777461 762522 650808 796015 804474 746536 678225 629776 791250 780026 767521 771512 768241 824939 452719 402434 714989 741021 722091 752505 441815 826690 824991 590557 592834 728633 808261 739981 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.46%) |
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 402434 416128 424247 426624 427129 427985 434470 434531 435833 441815 442542 452719 457093 460109 461809 463807 472095 475571 480700 493846 495483 505378 507000 507519 511841 516606 519252 530213 531118 537240 541202 541388 542509 551587 558361 559615 559618 561314 564125 573473 585176 590557 592834 599176 601237 604856 610173 612581 617038 629776 630917 634615 636399 637304 650478 650808 652530 670863 678225 696605 699681 700812 710277 710346 714143 714989 718863 720151 722091 728633 728879 730746 732147 732744 733348 733938 734304 737018 739981 741021 742987 745357 746536 751261 752505 762522 762994 763661 763802 764609 765089 767521 767813 768241 771512 777461 779461 779719 779722 780026 781030 781621 786653 789843 791250 792292 796015 798904 799476 804474 805274 807663 808261 818701 819326 824939 824974 824991 825850 826690 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob cum swallow"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс cum глота"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.77%) |
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.