Query Metrics
7
Database Queries
7
Different statements
211.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.46 ms (83.00%) |
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 46186 233426 408765 413237 413295 415906 418610 420266 429457 429934 430801 443497 444810 449185 452828 456623 457578 459494 459496 459503 461774 464194 466624 468122 475483 475961 484740 486634 489523 491501 491860 492382 501730 503183 510631 510635 510652 512236 513281 513305 514392 517637 522398 523099 523452 524550 526106 526774 535531 538665 548744 550011 551903 554366 554777 558020 558058 558843 560416 560422 561675 562239 562618 565250 571924 574503 574846 574849 574851 575062 575432 575810 576045 576371 576412 576858 577520 585103 585109 592569 594093 596670 598395 598801 600049 603026 611563 623458 628865 633533 641638 646000 649991 650802 651879 655186 668834 670996 678915 680179 680199 686133 686214 687339 695262 702157 703947 716321 721088 721579 723483 740908 752653 752676 757020 757454 770421 788839 811808 814246 ] |
||||||||||||||||||||||||||||||
|
21.55 ms (10.19%) |
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 716321 459503 459496 459494 420266 466624 510635 491501 512236 513281 449185 703947 600049 752676 752653 721088 514392 523099 475483 522398 565250 526774 510631 576412 429934 633533 430801 429457 585103 475961 576858 686214 687339 668834 680199 561675 574849 576045 598395 641638 596670 598801 628865 811808 233426 461774 464194 413237 413295 501730 510652 513305 523452 491860 484740 585109 486634 538665 558058 571924 646000 686133 655186 611563 603026 788839 740908 757020 757454 770421 46186 489523 418610 649991 468122 550011 577520 457578 517637 492382 452828 575810 408765 415906 443497 444810 814246 456623 503183 524550 526106 535531 554777 560422 574846 575432 558020 560416 562618 574503 548744 562239 575062 576371 650802 651879 723483 678915 695262 702157 721579 670996 680179 551903 554366 558843 574851 592569 594093 623458 ] |
||||||||||||||||||||||||||||||
|
4.68 ms (2.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits teen fucking"
]
|
||||||||||||||||||||||||||||||
|
4.20 ms (1.99%) |
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 46186 233426 408765 413237 413295 415906 418610 420266 429457 429934 430801 443497 444810 449185 452828 456623 457578 459494 459496 459503 461774 464194 466624 468122 475483 475961 484740 486634 489523 491501 491860 492382 501730 503183 510631 510635 510652 512236 513281 513305 514392 517637 522398 523099 523452 524550 526106 526774 535531 538665 548744 550011 551903 554366 554777 558020 558058 558843 560416 560422 561675 562239 562618 565250 571924 574503 574846 574849 574851 575062 575432 575810 576045 576371 576412 576858 577520 585103 585109 592569 594093 596670 598395 598801 600049 603026 611563 623458 628865 633533 641638 646000 649991 650802 651879 655186 668834 670996 678915 680179 680199 686133 686214 687339 695262 702157 703947 716321 721088 721579 723483 740908 752653 752676 757020 757454 770421 788839 811808 814246 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ teen fucking"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ teen fucking"
]
|
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.