Query Metrics
7
Database Queries
7
Different statements
395.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.66 ms (54.09%) |
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 14360 382073 391623 392655 396618 401654 419151 421734 422810 446721 447122 448738 449473 453960 455593 456284 457307 460487 463366 465031 468659 470823 472908 475085 476507 479164 479874 484720 486067 489249 489860 490841 492775 497391 508513 508683 510510 512752 516995 517376 517598 518463 521032 521351 523399 524053 525174 526860 529569 529833 530601 530823 531668 532279 532457 532633 533259 533352 533392 533558 536067 536205 536911 537027 537683 538272 538910 538919 539365 540814 544638 579295 588273 606849 615894 620324 626858 634768 646174 649162 650464 651080 655758 669558 691253 692404 697766 707687 707719 711559 716592 716845 723381 727663 738758 741131 748912 750339 752343 761567 774724 781550 785024 789158 796586 797469 815435 815764 815822 815903 822596 823133 823536 826061 828005 828058 828382 828459 ] |
||||||||||||||||||||||||||||||
|
153.04 ms (38.74%) |
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 14360 382073 391623 392655 396618 401654 419151 421734 422810 446721 447122 448738 449473 453960 455593 456284 457307 460487 463366 465031 468659 470823 472908 475085 476507 479164 479874 484720 486067 489249 489860 490841 492775 497391 508513 508683 510510 512752 516995 517376 517598 518463 521032 521351 523399 524053 525174 526860 529569 529833 530601 530823 531668 532279 532457 532633 533259 533352 533392 533558 536067 536205 536911 537027 537683 538272 538910 538919 539365 540814 544638 579295 588273 606849 615894 620324 626858 634768 646174 649162 650464 651080 655758 669558 691253 692404 697766 707687 707719 711559 716592 716845 723381 727663 738758 741131 748912 750339 752343 761567 774724 781550 785024 789158 796586 797469 815435 815764 815822 815903 822596 823133 823536 826061 828005 828058 828382 828459 ] |
||||||||||||||||||||||||||||||
|
22.19 ms (5.62%) |
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 761567 738758 697766 723381 785024 391623 489860 524053 823105 823133 815822 826061 815903 815435 815764 828382 828058 828005 828459 457307 532279 533259 521351 533558 530823 531668 537027 510510 781550 727663 401654 448738 533352 539365 716592 707687 512752 508683 508513 649162 470823 475085 382073 497391 465031 518463 823536 634768 529569 532457 460487 716845 752343 446721 453960 455593 711559 588273 463366 421734 540814 479874 492775 456284 468659 476507 516995 523399 536911 525174 529833 651080 626858 447122 419151 472908 526860 484720 489249 490841 517376 14360 396618 822596 828523 533392 537683 538910 532633 530601 538272 486067 650464 707719 655758 669558 691253 692404 646174 579295 615894 606849 620324 789158 797469 741131 750339 796586 748912 774724 392655 422810 479164 449473 517598 536067 521032 536205 538919 544638 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long big dick"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.