Query Metrics
7
Database Queries
7
Different statements
149.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.89 ms (81.05%) |
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 403891 408928 414137 416681 418069 418893 420163 424624 424721 425452 425804 428710 429563 431719 434307 434683 438316 439405 442196 443245 450287 451651 454511 455631 468206 469100 469171 471035 471124 472266 475406 475420 475752 476748 476778 480348 482061 489376 491431 497799 499701 500342 500436 504791 506688 514399 515004 515350 515661 517697 526536 527360 528572 529898 529905 534106 541418 542902 547679 553208 553845 553964 555963 555983 555990 555996 556471 557486 558316 559216 564744 568640 568660 568759 571335 574465 574768 580223 580265 586136 588362 588411 591277 592333 593296 593384 601142 601672 602314 603184 603980 605117 605250 614328 615296 620395 624191 624204 624207 631701 641095 643517 644849 645893 660263 684666 694098 695868 710638 714468 742281 749646 761039 790677 796831 796877 799190 799239 805149 ] |
||||||||||||||||||||||||||||||
|
18.29 ms (12.26%) |
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 636661 588362 641095 790677 799239 742281 431719 475406 469171 418893 424624 489376 515004 500436 424721 450287 471035 517697 555990 568660 574465 615296 620395 796831 796877 553208 403891 428710 475420 515661 694098 469100 482061 527360 593384 624207 499701 451651 644849 515350 558316 455631 442196 529898 529905 475752 557486 684666 555963 568759 586136 591277 592333 601142 603184 438316 468206 439405 480348 408928 472266 534106 497799 555983 542902 547679 631701 425804 443245 434683 454511 476748 476778 559216 568640 555996 553845 556471 571335 580265 695868 645893 660263 710638 553964 564744 601672 602314 603980 614328 605250 805149 799190 418069 420163 528572 541418 588411 429563 506688 574768 714468 425452 434307 500342 526536 580223 624204 605117 504791 761039 491431 416681 471124 624191 643517 749646 414137 514399 593296 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.78%) |
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 403891 408928 414137 416681 418069 418893 420163 424624 424721 425452 425804 428710 429563 431719 434307 434683 438316 439405 442196 443245 450287 451651 454511 455631 468206 469100 469171 471035 471124 472266 475406 475420 475752 476748 476778 480348 482061 489376 491431 497799 499701 500342 500436 504791 506688 514399 515004 515350 515661 517697 526536 527360 528572 529898 529905 534106 541418 542902 547679 553208 553845 553964 555963 555983 555990 555996 556471 557486 558316 559216 564744 568640 568660 568759 571335 574465 574768 580223 580265 586136 588362 588411 591277 592333 593296 593384 601142 601672 602314 603184 603980 605117 605250 614328 615296 620395 624191 624204 624207 631701 641095 643517 644849 645893 660263 684666 694098 695868 710638 714468 742281 749646 761039 790677 796831 796877 799190 799239 805149 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy solo tits"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy соло сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy соло сиськ"
]
|
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.