Query Metrics
7
Database Queries
7
Different statements
148.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.58 ms (82.30%) |
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 384162 386215 397206 400484 403871 408694 409016 418719 446772 453275 455928 458910 459258 462229 463394 466995 471060 484102 485955 485958 489924 490125 494198 499531 504614 510904 527384 531379 540208 545167 548284 553436 556085 560409 563036 563292 563751 564234 576483 577311 579559 583625 585261 588613 589936 593060 600700 605686 608670 609139 609554 614059 618930 619230 621496 627052 637197 646088 666055 670249 670914 680718 685509 685527 700468 701339 707605 714125 714203 714319 714357 715444 719385 720459 725742 728983 729294 729972 731010 731544 732093 734753 739778 739782 741217 742777 758780 758799 759015 762230 769448 772210 781238 781917 791857 794937 795909 801764 802311 804027 804265 804435 809869 810379 813172 814723 817262 819334 819350 824531 824630 824735 824857 825396 826391 826597 827298 827501 827507 828294 ] |
||||||||||||||||||||||||||||||
|
16.86 ms (11.32%) |
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 685509 707605 714319 666055 680718 685527 714357 714203 720459 545167 556085 563036 605686 588613 589936 600700 609139 621496 585261 614059 593060 609554 781917 801764 729972 741217 758780 758799 772210 791857 795909 742777 739778 739782 759015 608670 804265 804435 453275 462229 409016 384162 817262 819334 824531 471060 577311 400484 408694 485958 494198 386215 397206 824630 827501 826391 527384 564234 719385 670249 701339 714125 646088 670914 715444 548284 637197 618930 781238 802311 809869 731010 732093 729294 728983 734753 725742 627052 794937 804027 814723 484102 810379 762230 813172 403871 731544 458910 504614 418719 560409 824735 825396 489924 446772 455928 463394 499531 510904 485955 466995 459258 563292 579559 700468 619230 769448 826597 827298 827507 824857 819350 828294 490125 531379 540208 553436 563751 576483 583625 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.73%) |
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 384162 386215 397206 400484 403871 408694 409016 418719 446772 453275 455928 458910 459258 462229 463394 466995 471060 484102 485955 485958 489924 490125 494198 499531 504614 510904 527384 531379 540208 545167 548284 553436 556085 560409 563036 563292 563751 564234 576483 577311 579559 583625 585261 588613 589936 593060 600700 605686 608670 609139 609554 614059 618930 619230 621496 627052 637197 646088 666055 670249 670914 680718 685509 685527 700468 701339 707605 714125 714203 714319 714357 715444 719385 720459 725742 728983 729294 729972 731010 731544 732093 734753 739778 739782 741217 742777 758780 758799 759015 762230 769448 772210 781238 781917 791857 794937 795909 801764 802311 804027 804265 804435 809869 810379 813172 814723 817262 819334 819350 824531 824630 824735 824857 825396 826391 826597 827298 827501 827507 828294 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam pussy hairy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер pussy волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер pussy волосатая"
]
|
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.