Query Metrics
7
Database Queries
7
Different statements
188.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.84 ms (86.23%) |
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 13703 80999 151180 362615 382408 383325 384084 385271 389325 389526 391134 391832 392748 395580 398815 402541 405820 406816 407018 407058 407305 407767 412289 413246 420227 421404 422230 422295 425035 426059 427753 429205 431512 432529 434282 438828 445906 446299 447767 449368 452648 454178 454877 455140 458163 459896 460702 461505 462762 463397 464700 466060 467810 469501 470340 470930 473290 474509 475539 476728 477625 478012 479215 483086 486925 491600 491976 495715 498903 500475 501512 504055 505851 508247 509812 510658 512731 513688 517772 519649 522001 522557 546977 551624 552209 552480 553261 553935 554897 557311 557948 561661 563205 563421 564145 568809 570254 570918 571637 574614 575077 575504 576351 576731 578972 580684 581541 584422 587933 606783 624406 626067 663365 665200 738736 740747 743458 744355 788275 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (7.91%) |
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 362615 398815 473290 463397 744355 413246 420227 407018 407305 454178 392748 452648 552480 438828 427753 429205 460702 500475 568809 580684 382408 383325 432529 468318 458163 469501 479215 522557 509812 504055 402541 431512 446299 454877 476728 491600 571637 551624 563421 570254 564145 570918 626067 407767 470340 478012 466060 426059 461505 475539 505851 483086 486925 498903 517772 491976 495715 522001 519649 434282 474509 412289 584422 587933 459896 407058 422230 553935 557948 421404 557311 663365 665200 624406 743458 738736 740747 13703 391832 477625 80999 405820 384084 385271 151180 395580 425035 445906 449368 464700 546977 575077 552209 554897 561661 563205 575504 581541 553261 574614 578972 576351 576731 606783 788275 389325 406816 422295 389526 391134 447767 467810 455140 462762 470930 508247 510658 513688 501512 512731 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.58%) |
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 13703 80999 151180 362615 382408 383325 384084 385271 389325 389526 391134 391832 392748 395580 398815 402541 405820 406816 407018 407058 407305 407767 412289 413246 420227 421404 422230 422295 425035 426059 427753 429205 431512 432529 434282 438828 445906 446299 447767 449368 452648 454178 454877 455140 458163 459896 460702 461505 462762 463397 464700 466060 467810 469501 470340 470930 473290 474509 475539 476728 477625 478012 479215 483086 486925 491600 491976 495715 498903 500475 501512 504055 505851 508247 509812 510658 512731 513688 517772 519649 522001 522557 546977 551624 552209 552480 553261 553935 554897 557311 557948 561661 563205 563421 564145 568809 570254 570918 571637 574614 575077 575504 576351 576731 578972 580684 581541 584422 587933 606783 624406 626067 663365 665200 738736 740747 743458 744355 788275 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебется с парнем подруги"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс парен подружк"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс парен подружк"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.97%) |
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.