Query Metrics
7
Database Queries
7
Different statements
150.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.38 ms (84.45%) |
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 411344 426908 428712 434849 439601 441858 441929 446612 447198 449450 457108 467763 477691 478238 488249 492416 492554 493494 494952 498279 498963 507291 511501 514220 515358 517431 518725 519503 526257 527424 534826 542127 555098 558992 563015 567600 568756 583184 589073 589522 600708 600934 600951 600957 603067 603740 604420 604565 607542 607785 619782 619935 620938 621488 622691 626589 628459 636379 655247 662055 663567 665784 666440 667986 672822 674522 679191 689498 689558 689794 690988 695463 695686 699309 705075 706022 712542 714622 715277 715818 720202 720206 726634 728684 728755 730723 730975 731458 733399 733409 739033 739815 740527 741786 742847 743916 745924 756411 757372 758069 768347 771038 783693 787519 788128 788646 789518 794097 796672 796712 806773 807432 807645 808334 809699 813608 818944 824577 825365 827693 ] |
||||||||||||||||||||||||||||||
|
13.23 ms (8.77%) |
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 600708 607785 636379 620938 788646 787519 789518 796672 788128 809699 741786 733409 756411 728755 771038 726634 745924 758069 604420 699309 705075 706022 714622 783693 794097 796712 806773 807432 807645 428712 667986 449450 492554 498963 518725 514220 519503 526257 493494 542127 583184 568756 662055 665784 689498 603067 619782 619935 628459 589073 720206 434849 457108 477691 478238 441929 447198 441858 446612 467763 730975 488249 517431 527424 567600 674522 715818 672822 743916 511501 426908 507291 558992 498279 515358 439601 411344 712542 600934 555098 720202 757372 604565 813608 818944 827693 825365 824577 492416 494952 534826 563015 666440 715277 655247 689794 695686 663567 679191 689558 690988 695463 607542 622691 600957 589522 600951 603740 621488 626589 808334 730723 768347 728684 740527 742847 731458 733399 739033 739815 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.16%) |
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 411344 426908 428712 434849 439601 441858 441929 446612 447198 449450 457108 467763 477691 478238 488249 492416 492554 493494 494952 498279 498963 507291 511501 514220 515358 517431 518725 519503 526257 527424 534826 542127 555098 558992 563015 567600 568756 583184 589073 589522 600708 600934 600951 600957 603067 603740 604420 604565 607542 607785 619782 619935 620938 621488 622691 626589 628459 636379 655247 662055 663567 665784 666440 667986 672822 674522 679191 689498 689558 689794 690988 695463 695686 699309 705075 706022 712542 714622 715277 715818 720202 720206 726634 728684 728755 730723 730975 731458 733399 733409 739033 739815 740527 741786 742847 743916 745924 756411 757372 758069 768347 771038 783693 787519 788128 788646 789518 794097 796672 796712 806773 807432 807645 808334 809699 813608 818944 824577 825365 827693 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock dildo wife"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock дилд жен"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock дилд жен"
]
|
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.