Query Metrics
7
Database Queries
7
Different statements
224.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.85 ms (88.55%) |
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 423968 424234 426875 429776 432520 433327 433600 433755 433854 435378 435638 436953 437985 438459 446975 455501 458080 464511 465997 467818 469688 473644 475177 475868 477894 478738 479464 488413 494587 494592 499420 499496 503749 505786 507034 507435 515598 519728 521487 522334 529480 542077 545493 546718 546911 565303 565433 575696 579886 590131 601640 608127 608165 613871 642249 644104 677203 700058 705075 708141 716195 724736 725185 730323 730383 730795 735719 736879 738121 738835 739230 742220 742561 744421 744677 744860 744944 745074 746130 750342 752744 753534 754232 758409 758572 759932 761929 762098 762526 764036 764201 766265 769047 777266 777996 778273 779261 779367 782430 783159 783630 788833 789466 790554 791757 791968 792701 793289 793970 795966 800370 802078 803565 804736 805108 809307 811233 812108 819268 824749 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (7.08%) |
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 608127 608165 644104 809307 779261 779367 788833 791757 793289 802078 804736 805108 736879 744421 750342 754232 758572 759932 762526 782430 783630 790554 791968 792701 795966 800370 811233 730795 762098 766265 730383 738835 742561 744944 746130 753534 758409 761929 764036 764201 769047 725185 735719 739230 742220 745074 724736 738121 744677 700058 705075 708141 777266 777996 778273 783159 793970 803565 812108 436953 464511 426875 475868 519728 505786 521487 824749 458080 473644 446975 465997 515598 507034 613871 730323 744860 522334 579886 565303 677203 716195 590131 789466 752744 642249 499496 433327 819268 455501 469688 467818 478738 494587 545493 546911 542077 546718 575696 565433 601640 423968 433600 438459 433755 433854 424234 429776 432520 435378 437985 475177 477894 479464 435638 503749 529480 499420 507435 488413 494592 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.01%) |
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 423968 424234 426875 429776 432520 433327 433600 433755 433854 435378 435638 436953 437985 438459 446975 455501 458080 464511 465997 467818 469688 473644 475177 475868 477894 478738 479464 488413 494587 494592 499420 499496 503749 505786 507034 507435 515598 519728 521487 522334 529480 542077 545493 546718 546911 565303 565433 575696 579886 590131 601640 608127 608165 613871 642249 644104 677203 700058 705075 708141 716195 724736 725185 730323 730383 730795 735719 736879 738121 738835 739230 742220 742561 744421 744677 744860 744944 745074 746130 750342 752744 753534 754232 758409 758572 759932 761929 762098 762526 764036 764201 766265 769047 777266 777996 778273 779261 779367 782430 783159 783630 788833 789466 790554 791757 791968 792701 793289 793970 795966 800370 802078 803565 804736 805108 809307 811233 812108 819268 824749 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск жен fucked"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife fucked"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен fucked"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.