Query Metrics
7
Database Queries
7
Different statements
154.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.60 ms (78.12%) |
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 385181 391585 395941 396654 400396 417656 418797 421593 423646 425330 426111 431505 434301 434750 434781 434841 436335 437006 437146 439909 447601 448440 451094 451330 452493 453937 455844 458935 459483 459532 461650 462428 462726 462981 463077 463086 463360 467065 467667 468450 478143 480327 480349 485641 493367 494672 496619 497816 498671 500146 505864 507530 507667 509545 510058 513404 513865 515855 516071 518399 520482 521364 521622 523326 523636 525914 527665 552801 554185 555140 555465 558581 558618 560315 562463 568536 572320 577455 582477 582565 586103 587888 588111 593991 601472 601588 604077 605278 605442 605840 605875 621267 622405 624011 625181 650457 701522 703591 705346 711820 714756 722822 723264 736637 749482 753259 753457 758545 759870 759946 761078 767020 769043 779707 784970 790498 790541 798618 811042 812565 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (11.00%) |
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 769043 798618 385181 714756 753457 400396 423646 601588 790498 811042 784970 767020 758545 723264 605875 605840 437006 779707 516071 711820 554185 560315 703591 436335 462726 753259 749482 510058 426111 391585 604077 523326 513865 463086 624011 736637 453937 496619 497816 558618 701522 761078 468450 505864 480327 418797 434750 434841 451330 461650 480349 586103 509545 605278 439909 463077 582565 650457 431505 521364 621267 790541 500146 525914 552801 582477 812565 462428 518399 521622 498671 527665 555465 705346 601472 507530 478143 759870 437146 625181 588111 463360 434781 467667 462981 722822 417656 493367 562463 587888 395941 425330 458935 759946 396654 451094 572320 568536 577455 434301 455844 485641 513404 515855 467065 494672 507667 558581 555140 622405 421593 447601 452493 605442 523636 448440 593991 459483 459532 520482 ] |
||||||||||||||||||||||||||||||
|
9.33 ms (6.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"passionate sex"
]
|
||||||||||||||||||||||||||||||
|
2.67 ms (1.73%) |
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 385181 391585 395941 396654 400396 417656 418797 421593 423646 425330 426111 431505 434301 434750 434781 434841 436335 437006 437146 439909 447601 448440 451094 451330 452493 453937 455844 458935 459483 459532 461650 462428 462726 462981 463077 463086 463360 467065 467667 468450 478143 480327 480349 485641 493367 494672 496619 497816 498671 500146 505864 507530 507667 509545 510058 513404 513865 515855 516071 518399 520482 521364 521622 523326 523636 525914 527665 552801 554185 555140 555465 558581 558618 560315 562463 568536 572320 577455 582477 582565 586103 587888 588111 593991 601472 601588 604077 605278 605442 605840 605875 621267 622405 624011 625181 650457 701522 703591 705346 711820 714756 722822 723264 736637 749482 753259 753457 758545 759870 759946 761078 767020 769043 779707 784970 790498 790541 798618 811042 812565 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"passionate секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"passionate секс"
]
|
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.