Query Metrics
7
Database Queries
7
Different statements
180.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.71 ms (82.80%) |
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 101353 418861 420428 422731 427573 435239 436091 438486 452306 456415 458496 460785 466809 470651 477702 479243 480071 480284 481315 484514 485356 486323 487578 487798 491146 491622 493573 494074 494894 496464 496469 497127 498149 498288 498945 500225 502260 502799 506473 506637 507346 507383 507508 509743 512850 516537 516846 517110 519332 522467 523347 524429 526854 527440 529495 541420 541545 546871 555600 556291 558249 559617 560695 564892 567739 568823 571401 571467 571741 572242 574408 575979 579861 580906 580982 584088 588915 594495 597015 603888 605668 608860 610450 616517 619068 620812 621113 624587 626070 627144 629541 635604 636893 641890 642084 650682 673158 678858 686397 692870 707148 708057 709430 711416 714352 714739 716952 717972 719514 736112 745229 762442 762525 762667 765386 772376 772389 780260 794403 797929 ] |
||||||||||||||||||||||||||||||
|
21.86 ms (12.09%) |
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 487578 580982 559617 436091 529495 466809 708057 541420 512850 522467 491622 621113 608860 797929 762525 772389 736112 765386 780260 794403 438486 560695 619068 481315 555600 507346 420428 500225 580906 626070 485356 491146 498288 524429 509743 624587 597015 427573 484514 497127 498945 506473 470651 584088 745229 629541 458496 486323 519332 517110 571467 709430 477702 527440 493573 494894 762667 101353 479243 546871 707148 716952 717972 650682 714352 678858 714739 635604 616517 588915 636893 772376 762442 711416 422731 516846 642084 564892 579861 567739 571741 594495 498149 719514 686397 692870 435239 452306 506637 507383 502799 480284 556291 574408 673158 620812 480071 456415 507508 502260 496469 487798 523347 494074 496464 516537 572242 418861 526854 558249 575979 460785 568823 571401 541545 641890 603888 610450 605668 627144 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.43%) |
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 101353 418861 420428 422731 427573 435239 436091 438486 452306 456415 458496 460785 466809 470651 477702 479243 480071 480284 481315 484514 485356 486323 487578 487798 491146 491622 493573 494074 494894 496464 496469 497127 498149 498288 498945 500225 502260 502799 506473 506637 507346 507383 507508 509743 512850 516537 516846 517110 519332 522467 523347 524429 526854 527440 529495 541420 541545 546871 555600 556291 558249 559617 560695 564892 567739 568823 571401 571467 571741 572242 574408 575979 579861 580906 580982 584088 588915 594495 597015 603888 605668 608860 610450 616517 619068 620812 621113 624587 626070 627144 629541 635604 636893 641890 642084 650682 673158 678858 686397 692870 707148 708057 709430 711416 714352 714739 716952 717972 719514 736112 745229 762442 762525 762667 765386 772376 772389 780260 794403 797929 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хуй в позже крупно"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член в крупныйпла"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.77%) |
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.