Query Metrics
7
Database Queries
7
Different statements
146.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.73 ms (82.35%) |
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 61315 61597 156688 233532 271496 382326 382878 382935 383073 385024 390012 390150 391518 401856 402042 403087 411249 411883 413170 413463 418929 425508 427220 428127 428543 432129 438430 444223 445474 445669 447887 447933 448934 453541 453713 453922 454103 454184 454393 454565 454960 456682 458080 460160 460433 461923 462075 465833 465886 469067 469481 470448 472174 472768 472924 473247 474854 474855 475685 477903 477929 477937 484539 484903 485377 485924 488933 490152 490499 491104 494193 494571 494625 496322 496586 503408 506352 511118 517494 520944 525009 527417 539360 546651 550223 565300 585132 591358 627076 645352 645925 663887 667291 667836 668888 680537 681193 714887 715226 716247 719707 723069 725476 727014 730735 741780 742641 742642 759762 770105 773217 781922 781997 782007 782460 784550 798473 803424 808238 814289 ] |
||||||||||||||||||||||||||||||
|
15.70 ms (10.71%) |
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 271496 403087 418929 428543 413170 485377 539360 488933 550223 681193 741780 453713 454565 458080 517494 490499 491104 511118 382935 469067 714887 411249 233532 477937 383073 390150 427220 445474 454960 454184 527417 496322 645352 716247 781997 803424 472768 156688 444223 484539 485924 477903 453922 454393 460160 490152 565300 723069 667291 667836 719707 668888 808238 784550 773217 725476 742641 742642 781922 391518 61597 445669 472924 782460 759762 462075 425508 448934 474855 447887 472174 503408 663887 591358 727014 385024 465833 447933 520944 413463 456682 680537 494571 814289 454103 465886 525009 506352 546651 645925 798473 730735 770105 61315 473247 477929 432129 428127 494193 402042 469481 382878 382326 390012 401856 411883 461923 585132 496586 494625 782007 470448 715226 627076 438430 460433 453541 474854 475685 484903 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.97%) |
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 61315 61597 156688 233532 271496 382326 382878 382935 383073 385024 390012 390150 391518 401856 402042 403087 411249 411883 413170 413463 418929 425508 427220 428127 428543 432129 438430 444223 445474 445669 447887 447933 448934 453541 453713 453922 454103 454184 454393 454565 454960 456682 458080 460160 460433 461923 462075 465833 465886 469067 469481 470448 472174 472768 472924 473247 474854 474855 475685 477903 477929 477937 484539 484903 485377 485924 488933 490152 490499 491104 494193 494571 494625 496322 496586 503408 506352 511118 517494 520944 525009 527417 539360 546651 550223 565300 585132 591358 627076 645352 645925 663887 667291 667836 668888 680537 681193 714887 715226 716247 719707 723069 725476 727014 730735 741780 742641 742642 759762 770105 773217 781922 781997 782007 782460 784550 798473 803424 808238 814289 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"толстая сиськ секс"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстая грудь секса"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"толстая сиськ секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.04%) |
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.