Query Metrics
7
Database Queries
7
Different statements
164.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.68 ms (82.26%) |
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 415817 418277 426637 427075 432389 432470 433385 433413 433490 433614 433696 433742 433789 434610 434887 435020 435413 436129 437260 437419 438730 444349 447848 456121 457146 458080 459225 460894 461912 462259 475610 476071 483224 490271 493844 499021 499750 500010 502938 509155 509573 512051 513017 519738 521478 522118 522446 522447 522793 524935 525456 525807 527197 534494 547392 549604 554963 555965 556482 558624 558918 562716 578930 579532 591204 592181 602694 605011 606010 609146 612426 615999 616807 619213 619538 619955 622416 625442 627103 645905 650076 655558 663165 687937 695544 695793 696455 702313 706470 712307 716182 717433 746555 747735 750198 756302 759675 763842 764703 766500 767448 770595 770813 774935 775295 777096 778014 779656 779912 782753 788050 793959 795773 802024 803137 808314 810005 810187 813572 818080 ] |
||||||||||||||||||||||||||||||
|
18.39 ms (11.15%) |
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 500010 522446 522447 426637 695793 645905 717433 774935 777096 808314 810187 747735 764703 746555 750198 602694 605011 779656 779912 437419 527197 436129 813572 444349 433614 415817 502938 525456 456121 578930 554963 432389 432470 458080 462259 433696 447848 460894 461912 457146 434610 433413 433490 475610 476071 512051 483224 499750 524935 493844 716182 795773 802024 775295 756302 759675 763842 778014 793959 803137 810005 433385 509155 555965 579532 695544 702313 650076 706470 663165 609146 622416 513017 696455 655558 770595 788050 521478 435020 509573 435413 556482 591204 615999 782753 766500 767448 770813 427075 434887 433789 438730 437260 490271 433742 525807 522118 459225 522793 499021 519738 534494 818080 549604 562716 547392 687937 558624 558918 592181 606010 616807 619213 612426 619538 619955 625442 627103 712307 418277 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.54%) |
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 415817 418277 426637 427075 432389 432470 433385 433413 433490 433614 433696 433742 433789 434610 434887 435020 435413 436129 437260 437419 438730 444349 447848 456121 457146 458080 459225 460894 461912 462259 475610 476071 483224 490271 493844 499021 499750 500010 502938 509155 509573 512051 513017 519738 521478 522118 522446 522447 522793 524935 525456 525807 527197 534494 547392 549604 554963 555965 556482 558624 558918 562716 578930 579532 591204 592181 602694 605011 606010 609146 612426 615999 616807 619213 619538 619955 622416 625442 627103 645905 650076 655558 663165 687937 695544 695793 696455 702313 706470 712307 716182 717433 746555 747735 750198 756302 759675 763842 764703 766500 767448 770595 770813 774935 775295 777096 778014 779656 779912 782753 788050 793959 795773 802024 803137 808314 810005 810187 813572 818080 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск sister любительск"
]
|
||||||||||||||||||||||||||||||
|
2.27 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sister amateur"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск sister любительск"
]
|
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.