Query Metrics
7
Database Queries
7
Different statements
396.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.34 ms (53.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скача русск соск"
]
|
||||||||||||||||||||||||||||||
|
153.25 ms (38.68%) |
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 106162 358449 392622 394406 395933 401631 417749 418459 418821 422401 422426 423967 426689 428967 435015 435541 438421 438992 439539 439747 442696 443119 445044 446111 447543 449675 450372 451035 453868 455203 456261 456536 457540 458192 458269 458684 459432 461582 461584 461659 462059 464711 466236 467550 470206 470560 470764 471076 472326 472340 472422 475201 477154 480822 485295 492505 496037 497719 499741 506068 509699 510647 511349 511722 512156 512337 517552 520543 520796 523595 524414 524973 526331 527279 527422 528274 528564 535403 541068 542262 545016 546109 546788 547450 549201 550526 551645 552839 556550 566751 567309 567411 568592 573286 574506 576915 580890 581419 586199 587534 590133 598569 598803 614417 623076 636742 652892 655407 659380 669335 673823 676531 687285 741688 741739 741749 772759 789638 794424 795262 ] |
||||||||||||||||||||||||||||||
|
23.15 ms (5.84%) |
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 470560 418459 394406 418821 439539 471076 428967 470206 512156 524414 526331 423967 422426 455203 456261 456536 458192 459432 485295 506068 511349 517552 520796 523595 496037 497719 527279 535403 528564 477154 541068 547450 549201 552839 568592 542262 546788 550526 556550 573286 574506 580890 567309 581419 652892 659380 673823 676531 687285 655407 669335 545016 546109 551645 566751 567411 576915 598569 598803 587534 590133 623076 586199 789638 772759 794424 795262 741688 741739 741749 614417 636742 395933 438421 438992 443119 446111 449675 458269 472326 475201 106162 358449 392622 417749 426689 442696 462059 466236 480822 439747 450372 451035 457540 458684 461659 467550 401631 422401 435015 435541 447543 461582 464711 472422 445044 461584 470764 472340 510647 524973 527422 492505 509699 511722 520543 528274 499741 512337 453868 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (0.67%) |
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 106162 358449 392622 394406 395933 401631 417749 418459 418821 422401 422426 423967 426689 428967 435015 435541 438421 438992 439539 439747 442696 443119 445044 446111 447543 449675 450372 451035 453868 455203 456261 456536 457540 458192 458269 458684 459432 461582 461584 461659 462059 464711 466236 467550 470206 470560 470764 471076 472326 472340 472422 475201 477154 480822 485295 492505 496037 497719 499741 506068 509699 510647 511349 511722 512156 512337 517552 520543 520796 523595 524414 524973 526331 527279 527422 528274 528564 535403 541068 542262 545016 546109 546788 547450 549201 550526 551645 552839 556550 566751 567309 567411 568592 573286 574506 576915 580890 581419 586199 587534 590133 598569 598803 614417 623076 636742 652892 655407 659380 669335 673823 676531 687285 741688 741739 741749 772759 789638 794424 795262 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скача русск соск"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.