Query Metrics
7
Database Queries
7
Different statements
167.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.31 ms (85.21%) |
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 69950 477222 478991 483485 492421 497595 497601 498759 499305 506901 506931 507159 511286 512392 515012 521268 524036 524482 525699 525729 526348 527105 528881 530635 530996 536565 536718 536720 536725 536764 536941 537044 538547 538646 538782 539503 539932 539968 542884 545345 545623 546105 546217 546556 547009 547027 547321 547784 548474 550150 550165 552293 553164 555505 555521 555616 556542 557606 560222 560297 562970 563241 563907 563931 567595 568126 568127 568136 573164 574217 574722 575993 577285 578779 578814 579252 580140 580147 580872 582747 584190 586745 591569 591594 591997 592510 593093 594120 599236 599810 600721 603397 604182 604422 604841 604916 605247 609990 610053 610241 614348 615048 615182 615899 618291 624537 624897 625947 631676 632437 636251 644091 644150 647721 648005 651686 659004 659066 672237 676412 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (8.24%) |
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 624897 615182 530996 575993 563241 538547 579252 538782 536720 624537 521268 603397 492421 511286 574722 555616 536941 557606 563907 592510 648005 483485 604422 580147 672237 567595 631676 552293 599236 507159 478991 538646 604841 615899 560297 547784 578779 525729 568127 542884 550150 604916 556542 546217 562970 614348 636251 497601 497595 577285 644150 512392 539503 536718 536725 547321 651686 573164 547027 555505 69950 525699 600721 537044 498759 582747 546556 546105 547009 610241 599810 609990 530635 539968 545623 568136 586745 524036 536764 580140 676412 550165 499305 548474 574217 584190 593093 591594 560222 515012 524482 536565 580872 594120 618291 644091 591997 477222 659066 568126 625947 539932 647721 604182 528881 591569 506901 526348 545345 578814 605247 610053 563931 527105 632437 659004 553164 615048 506931 555521 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.92%) |
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 69950 477222 478991 483485 492421 497595 497601 498759 499305 506901 506931 507159 511286 512392 515012 521268 524036 524482 525699 525729 526348 527105 528881 530635 530996 536565 536718 536720 536725 536764 536941 537044 538547 538646 538782 539503 539932 539968 542884 545345 545623 546105 546217 546556 547009 547027 547321 547784 548474 550150 550165 552293 553164 555505 555521 555616 556542 557606 560222 560297 562970 563241 563907 563931 567595 568126 568127 568136 573164 574217 574722 575993 577285 578779 578814 579252 580140 580147 580872 582747 584190 586745 591569 591594 591997 592510 593093 594120 599236 599810 600721 603397 604182 604422 604841 604916 605247 609990 610053 610241 614348 615048 615182 615899 618291 624537 624897 625947 631676 632437 636251 644091 644150 647721 648005 651686 659004 659066 672237 676412 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"показывает большую грудь"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"показыва большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"показыва большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.