Query Metrics
7
Database Queries
7
Different statements
175.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.58 ms (82.98%) |
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 426866 446457 446713 448695 452242 453726 454325 455465 460263 462904 468856 469690 469879 470335 470343 470716 472876 472942 474264 477353 477355 482910 483635 484124 487758 489015 489984 491751 491753 493017 496591 498279 502745 503272 503953 503975 504158 504189 504304 505885 509414 510686 511132 511159 511200 511776 511803 513779 514693 518145 521407 521508 521526 523055 523625 525881 526274 528631 530560 537634 547836 548020 548747 550475 550478 552946 554913 554962 555868 555979 555983 555986 556684 557947 558543 560512 560804 565700 566128 568283 569028 569561 571334 575706 578709 578790 588802 591510 594564 594765 596622 596920 596929 599707 600586 605559 605987 613318 613396 621347 621348 622356 625219 658486 695182 696287 721894 724425 724537 734684 748396 774037 784689 784767 794301 795829 796606 800081 800084 809704 ] |
||||||||||||||||||||||||||||||
|
17.51 ms (9.98%) |
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 566128 578790 658486 554962 569561 600586 594765 622356 605987 625219 794301 468856 470716 505885 509414 510686 518145 523055 523625 484124 493017 496591 528631 454325 578709 504304 568283 446713 477353 460263 526274 513779 521407 489015 489984 547836 556684 555983 555986 560512 565700 569028 555979 575706 588802 594564 724425 470343 448695 469879 474264 482910 483635 503953 504158 487758 596929 525881 470335 548747 426866 503975 514693 511200 511132 511776 511803 491751 446457 469690 462904 554913 558543 621347 453726 455465 504189 502745 596622 477355 498279 521508 521526 491753 560804 571334 621348 605559 452242 503272 550475 591510 552946 555868 557947 613318 613396 472942 537634 721894 809704 530560 796606 784689 596920 795829 800081 734684 748396 800084 774037 724537 695182 784767 550478 472876 599707 696287 548020 511159 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (2.06%) |
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 426866 446457 446713 448695 452242 453726 454325 455465 460263 462904 468856 469690 469879 470335 470343 470716 472876 472942 474264 477353 477355 482910 483635 484124 487758 489015 489984 491751 491753 493017 496591 498279 502745 503272 503953 503975 504158 504189 504304 505885 509414 510686 511132 511159 511200 511776 511803 513779 514693 518145 521407 521508 521526 523055 523625 525881 526274 528631 530560 537634 547836 548020 548747 550475 550478 552946 554913 554962 555868 555979 555983 555986 556684 557947 558543 560512 560804 565700 566128 568283 569028 569561 571334 575706 578709 578790 588802 591510 594564 594765 596622 596920 596929 599707 600586 605559 605987 613318 613396 621347 621348 622356 625219 658486 695182 696287 721894 724425 724537 734684 748396 774037 784689 784767 794301 795829 796606 800081 800084 809704 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт горничн"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden maid"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт горничн"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.01%) |
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.