Query Metrics
7
Database Queries
7
Different statements
153.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.59 ms (82.62%) |
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 420635 420692 426653 427543 428158 428164 428554 430601 430621 430623 430635 431476 431749 434553 436820 438278 439641 442281 442829 443357 444269 448644 448669 448763 449635 449717 455044 459877 460282 460673 472524 473799 473948 477890 480270 486185 486540 486587 492534 506467 512103 513095 513564 515610 517176 518603 519038 520697 522013 522556 523026 523154 523411 526594 526819 527128 527967 528216 528921 530513 531413 531431 531512 533182 533278 543906 547824 549027 555864 556535 559050 560188 562060 573393 573800 575104 576103 584336 584514 584739 585668 587901 590865 591351 596168 596739 601900 601982 605430 607258 608206 608549 608787 610588 611525 619527 620048 621655 622668 625225 625408 641687 750704 775809 ] |
||||||||||||||||||||||||||||||
|
17.11 ms (11.17%) |
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 547824 431476 444269 428164 486587 560188 585668 449717 576103 473948 477890 518603 625225 473799 448763 528216 533278 625408 531512 587901 590865 426653 486185 596739 526819 448644 448669 460282 519038 526594 480270 430623 527128 549027 512103 584336 608206 431749 443357 455044 533182 596168 420635 607258 428158 513095 513564 775809 621655 430621 459877 641687 562060 605430 449635 434553 608787 608549 523026 601900 420692 523411 472524 492534 573393 531431 442829 430601 523154 438278 611525 601982 439641 428554 436820 591351 584739 750704 573800 555864 610588 559050 530513 517176 543906 575104 460673 556535 430635 427543 620048 531413 527967 520697 515610 528921 522013 522556 622668 506467 619527 486540 442281 584514 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.62%) |
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 420635 420692 426653 427543 428158 428164 428554 430601 430621 430623 430635 431476 431749 434553 436820 438278 439641 442281 442829 443357 444269 448644 448669 448763 449635 449717 455044 459877 460282 460673 472524 473799 473948 477890 480270 486185 486540 486587 492534 506467 512103 513095 513564 515610 517176 518603 519038 520697 522013 522556 523026 523154 523411 526594 526819 527128 527967 528216 528921 530513 531413 531431 531512 533182 533278 543906 547824 549027 555864 556535 559050 560188 562060 573393 573800 575104 576103 584336 584514 584739 585668 587901 590865 591351 596168 596739 601900 601982 605430 607258 608206 608549 608787 610588 611525 619527 620048 621655 622668 625225 625408 641687 750704 775809 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov young blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов young минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов young минет оральн секс"
]
|
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.