Query Metrics
7
Database Queries
7
Different statements
158.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.70 ms (84.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 30791 382726 419453 432769 440914 444052 452600 456578 464010 465154 465846 467089 471017 471108 473222 479619 484972 489278 494208 500434 501170 503763 509608 513966 516486 517445 519054 519520 520761 522025 524680 525538 526919 527518 527574 528322 528442 528608 528987 529709 529912 532020 532213 542383 545207 546593 547418 548745 549769 552183 552674 552676 554711 554998 555480 555784 557559 559356 559944 565453 565838 567272 567720 569962 570393 574745 576305 577580 579487 580471 580511 581577 585300 587274 587843 588345 591675 594451 595105 596910 597933 598803 599328 599738 600207 600483 601034 601174 601388 602467 602952 603184 605074 605498 605584 609192 614696 617107 618069 618118 619071 619544 619576 621044 621472 621687 623808 625108 628443 629815 635684 639208 642879 662912 667818 669337 690935 725508 ] |
||||||||||||||||||||||||||||||
|
14.16 ms (8.91%) |
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 587274 602952 440914 432769 467089 580511 545207 528987 725508 618069 520761 532213 574745 580471 577580 579487 605584 602467 546593 570393 540618 513966 557559 559356 585300 596910 601174 494208 528442 479619 549769 555784 554998 605074 471017 595105 567720 628443 484972 599738 617107 500434 489278 569962 619576 635684 619071 473222 517445 552183 576305 419453 587843 594451 609192 591675 623808 509608 452600 526919 601388 456578 567272 605498 639208 503763 669337 598803 525538 552674 625108 621687 465846 614696 464010 600207 527574 619544 471108 501170 529912 542383 559944 629815 527518 547418 552676 554711 599328 465154 667818 382726 528608 603184 581577 30791 519054 519520 565838 662912 621472 642879 600483 528322 597933 524680 529709 555480 601034 690935 548745 621044 532020 522025 565453 618118 588345 516486 444052 513372 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.74%) |
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 30791 382726 419453 432769 440914 444052 452600 456578 464010 465154 465846 467089 471017 471108 473222 479619 484972 489278 494208 500434 501170 503763 509608 513966 516486 517445 519054 519520 520761 522025 524680 525538 526919 527518 527574 528322 528442 528608 528987 529709 529912 532020 532213 542383 545207 546593 547418 548745 549769 552183 552674 552676 554711 554998 555480 555784 557559 559356 559944 565453 565838 567272 567720 569962 570393 574745 576305 577580 579487 580471 580511 581577 585300 587274 587843 588345 591675 594451 595105 596910 597933 598803 599328 599738 600207 600483 601034 601174 601388 602467 602952 603184 605074 605498 605584 609192 614696 617107 618069 618118 619071 619544 619576 621044 621472 621687 623808 625108 628443 629815 635684 639208 642879 662912 667818 669337 690935 725508 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties in ass"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел жоп"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.03%) |
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.