Query Metrics
7
Database Queries
7
Different statements
148.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.26 ms (80.07%) |
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 395384 420799 423945 432379 432464 433054 433928 436728 455059 456315 458252 458909 460436 462231 473618 478590 479456 481054 482095 483691 484311 487855 489049 489195 490824 493415 496196 499232 500779 503398 505317 509546 512596 521918 522655 525310 525772 526510 536217 538419 552187 556599 559462 560872 564056 565004 568675 570374 570616 573419 574108 587055 589927 598788 604895 608127 616007 616450 616795 617596 643250 653282 657514 671558 674475 675604 677681 678823 679049 681371 688829 693313 695767 696148 696366 706442 707867 711805 713749 721332 722996 731232 733910 739158 742195 746094 751307 754198 766716 767722 769839 779945 783391 785225 785445 787373 790075 790264 790316 790730 792479 792730 792975 798257 798265 799832 799834 801580 803385 805164 806398 807290 809951 810532 810732 813138 813369 813582 813595 814427 ] |
||||||||||||||||||||||||||||||
|
19.94 ms (13.39%) |
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 478590 432379 433054 458909 479456 503398 505317 653282 696366 679049 604895 608127 790316 799834 810732 807290 742195 799832 803385 711805 423945 493415 420799 813582 693313 790264 556599 432464 570374 751307 559462 696148 589927 617596 806398 526510 707867 500779 481054 573419 525310 657514 688829 616007 810532 813369 792730 792975 798265 787373 790730 767722 739158 809951 458252 460436 489195 538419 814427 675604 616450 792479 801580 779945 790075 722996 785445 395384 433928 560872 598788 805164 766716 521918 487855 813595 536217 552187 706442 678823 695767 671558 713749 643250 785225 813138 731232 754198 798257 746094 783391 570616 677681 483691 436728 482095 587055 455059 473618 522655 525772 489049 490824 484311 496196 565004 568675 674475 681371 721332 616795 769839 733910 509546 499232 564056 462231 456315 512596 574108 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.22%) |
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 395384 420799 423945 432379 432464 433054 433928 436728 455059 456315 458252 458909 460436 462231 473618 478590 479456 481054 482095 483691 484311 487855 489049 489195 490824 493415 496196 499232 500779 503398 505317 509546 512596 521918 522655 525310 525772 526510 536217 538419 552187 556599 559462 560872 564056 565004 568675 570374 570616 573419 574108 587055 589927 598788 604895 608127 616007 616450 616795 617596 643250 653282 657514 671558 674475 675604 677681 678823 679049 681371 688829 693313 695767 696148 696366 706442 707867 711805 713749 721332 722996 731232 733910 739158 742195 746094 751307 754198 766716 767722 769839 779945 783391 785225 785445 787373 790075 790264 790316 790730 792479 792730 792975 798257 798265 799832 799834 801580 803385 805164 806398 807290 809951 810532 810732 813138 813369 813582 813595 814427 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодёжь русские оргазмы"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодые молодая девушк молодой русск оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
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.