Query Metrics
7
Database Queries
7
Different statements
363.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.93 ms (57.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин сперм в рот"
]
|
||||||||||||||||||||||||||||||
|
129.37 ms (35.55%) |
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 80699 130016 190891 375930 385198 385491 388411 390139 391208 393102 394453 396946 400653 401013 404021 405827 407024 407491 411842 412989 418080 426783 428468 428781 430534 438324 439465 443677 443738 445089 445297 446766 447527 450647 459595 462347 465473 466840 469726 470167 478183 478362 480282 484285 486290 486477 486684 497284 497391 499341 499427 500037 501482 504668 509271 513361 518126 522653 523835 525200 526724 527845 530185 535806 539561 544943 547743 552828 555066 555089 555936 558778 561033 565015 566760 567360 569655 573327 573757 576644 583941 588984 597546 597843 598839 604129 610148 613543 614858 623396 624148 625860 630328 636208 641874 666892 715001 717794 717949 720122 734461 738314 742544 749009 758572 762994 766041 769443 769668 779534 780427 781078 788883 795978 795988 796155 802012 807305 807846 809787 ] |
||||||||||||||||||||||||||||||
|
15.90 ms (4.37%) |
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 469726 504668 779534 385198 499341 518126 80699 411842 478183 624148 583941 405827 480282 525200 588984 625860 499427 613543 445297 565015 401013 795988 445089 539561 666892 614858 742544 558778 497284 597843 466840 478362 573757 576644 391208 486290 604129 641874 486684 547743 717949 762994 769443 567360 561033 597546 407491 500037 535806 400653 443677 513361 418080 749009 470167 428468 447527 393102 443738 530185 734461 552828 497391 190891 636208 780427 526724 555089 527845 807846 428781 623396 396946 426783 501482 720122 796155 438324 388411 544943 758572 807305 738314 802012 390139 769668 717794 569655 610148 394453 450647 412989 430534 385491 573327 715001 795978 788883 809787 439465 459595 598839 407024 375930 509271 130016 465473 484285 522653 555936 630328 566760 404021 446766 462347 555066 486477 523835 766041 781078 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (0.72%) |
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 80699 130016 190891 375930 385198 385491 388411 390139 391208 393102 394453 396946 400653 401013 404021 405827 407024 407491 411842 412989 418080 426783 428468 428781 430534 438324 439465 443677 443738 445089 445297 446766 447527 450647 459595 462347 465473 466840 469726 470167 478183 478362 480282 484285 486290 486477 486684 497284 497391 499341 499427 500037 501482 504668 509271 513361 518126 522653 523835 525200 526724 527845 530185 535806 539561 544943 547743 552828 555066 555089 555936 558778 561033 565015 566760 567360 569655 573327 573757 576644 583941 588984 597546 597843 598839 604129 610148 613543 614858 623396 624148 625860 630328 636208 641874 666892 715001 717794 717949 720122 734461 738314 742544 749009 758572 762994 766041 769443 769668 779534 780427 781078 788883 795978 795988 796155 802012 807305 807846 809787 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамка кончил в рот"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.37%) |
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.