Query Metrics
7
Database Queries
7
Different statements
216.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.57 ms (86.01%) |
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 149612 415878 422392 435795 443233 443956 448553 450112 456312 458047 464987 465990 466092 467102 469591 470660 471420 472409 472418 475561 475885 476471 476613 478381 478940 478949 485400 487007 487633 490399 491102 494204 495031 496334 498193 501699 506329 507266 512089 517397 517399 519489 525656 525882 526473 532388 538468 538730 544219 544952 545972 546456 547008 547885 548392 548467 552510 556446 557525 558172 559832 562458 562561 564032 564371 564753 564760 566652 568017 575634 579221 579867 582321 592988 593271 597162 616635 618682 627156 627696 649476 668782 668829 709894 713422 715535 716309 731010 732987 742688 754994 768081 768893 781918 782358 800981 813738 817069 817206 817542 817551 817560 817574 818955 818957 818984 819869 820055 823273 823651 823846 823999 824479 824520 824886 825270 826438 826890 827225 ] |
||||||||||||||||||||||||||||||
|
19.78 ms (9.12%) |
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 435795 415878 458047 464987 465990 487007 485400 487633 512089 496334 467102 469591 472418 478940 545972 582321 548392 668782 579221 579867 597162 443233 448553 475561 476613 478949 443956 466092 422392 470660 471420 472409 476471 450112 456312 475885 478381 525882 526473 490399 495031 506329 507266 517399 519489 525656 494204 498193 501699 517397 558172 491102 592988 826438 538730 538468 532388 544219 548467 564032 564371 546456 547008 564753 564760 566652 649476 556446 557525 627156 616635 593271 800981 781918 782358 731010 768081 732987 754994 768893 742688 618682 149612 817551 818957 818984 826523 824520 826890 827225 813738 817069 817542 819869 820055 823651 823999 824479 817206 817560 817574 818955 823273 823846 824886 825270 544952 559832 562458 552510 709894 715535 716309 668829 713422 547885 562561 568017 575634 627696 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.65%) |
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 149612 415878 422392 435795 443233 443956 448553 450112 456312 458047 464987 465990 466092 467102 469591 470660 471420 472409 472418 475561 475885 476471 476613 478381 478940 478949 485400 487007 487633 490399 491102 494204 495031 496334 498193 501699 506329 507266 512089 517397 517399 519489 525656 525882 526473 532388 538468 538730 544219 544952 545972 546456 547008 547885 548392 548467 552510 556446 557525 558172 559832 562458 562561 564032 564371 564753 564760 566652 568017 575634 579221 579867 582321 592988 593271 597162 616635 618682 627156 627696 649476 668782 668829 709894 713422 715535 716309 731010 732987 742688 754994 768081 768893 781918 782358 800981 813738 817069 817206 817542 817551 817560 817574 818955 818957 818984 819869 820055 823273 823651 823846 823999 824479 824520 824886 825270 826438 826890 827225 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"обвисшая грудь веб-камера"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"обвисшая сиськ вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.64%) |
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.