Query Metrics
7
Database Queries
7
Different statements
212.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.38 ms (89.62%) |
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 88788 119769 154543 162000 218669 233398 237982 381764 382285 385206 392989 393393 395242 395781 399500 403129 404216 406074 413648 414217 416620 417720 418221 418858 419558 420324 420865 422355 425102 428621 429301 431585 432196 433426 433618 433635 433787 434230 441192 442011 442158 444234 445448 446281 447657 451012 452656 452728 454631 456330 456589 456838 459753 459799 460406 461139 461253 466793 469498 469716 470055 470805 472085 474430 474854 476694 478296 478394 480096 480966 482619 483490 483878 486031 487309 487891 487980 490709 494242 494799 496520 497394 498631 499369 499497 500314 501441 503344 504019 505017 512604 515507 515948 516715 521883 522804 524657 525595 526137 527829 528276 529480 546721 547726 549604 552731 553260 558487 559470 561307 562702 566607 571539 572322 577988 582048 582641 586327 601695 621277 ] |
||||||||||||||||||||||||||||||
|
12.62 ms (5.94%) |
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 451012 419558 381764 482619 469498 526137 490709 582048 119769 516715 522804 601695 469716 499369 431585 218669 406074 621277 447657 154543 470055 501441 504019 559470 527829 499497 461139 572322 233398 393393 420324 459753 470805 547726 88788 416620 452656 515948 162000 505017 521883 494799 392989 432196 425102 456330 237982 446281 486031 417720 529480 395242 442011 480966 562702 403129 418858 445448 480096 474430 433426 496520 483878 487980 561307 442158 500314 385206 433635 466793 571539 461253 428621 399500 456589 497394 404216 395781 420865 441192 459799 476694 498631 478296 546721 552731 577988 452728 429301 433618 434230 460406 454631 472085 528276 515507 524657 487891 494242 422355 444234 433787 478394 525595 512604 487309 413648 503344 483490 558487 549604 586327 382285 418221 414217 553260 456838 474854 566607 582641 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.26%) |
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 88788 119769 154543 162000 218669 233398 237982 381764 382285 385206 392989 393393 395242 395781 399500 403129 404216 406074 413648 414217 416620 417720 418221 418858 419558 420324 420865 422355 425102 428621 429301 431585 432196 433426 433618 433635 433787 434230 441192 442011 442158 444234 445448 446281 447657 451012 452656 452728 454631 456330 456589 456838 459753 459799 460406 461139 461253 466793 469498 469716 470055 470805 472085 474430 474854 476694 478296 478394 480096 480966 482619 483490 483878 486031 487309 487891 487980 490709 494242 494799 496520 497394 498631 499369 499497 500314 501441 503344 504019 505017 512604 515507 515948 516715 521883 522804 524657 525595 526137 527829 528276 529480 546721 547726 549604 552731 553260 558487 559470 561307 562702 566607 571539 572322 577988 582048 582641 586327 601695 621277 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в лифчика"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.