Query Metrics
7
Database Queries
7
Different statements
166.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.73 ms (82.66%) |
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 193666 390533 394406 395687 395981 396600 406308 408601 413971 425709 432970 435624 435664 443480 444906 446165 447150 447454 447885 453067 454997 466554 467561 467583 469923 470778 474036 475975 478781 478786 480293 482632 483326 486776 494620 497560 498497 499543 507310 509802 513780 519261 521923 521927 526145 529114 530492 531085 531242 531257 531989 532984 533466 535028 536618 537186 538190 543877 548609 549093 550305 550327 553926 558129 563411 563534 565283 566691 566695 567581 567957 568185 570691 577376 581726 584550 588298 593348 593835 596351 599902 599937 600002 600017 600290 600350 603686 615456 628365 628392 631195 631249 632695 633747 636998 637009 637078 637147 637731 640763 640779 641395 641667 645238 647938 648870 648871 649576 666881 670112 676025 679799 680154 696996 703836 716027 720381 749266 775788 814069 ] |
||||||||||||||||||||||||||||||
|
17.73 ms (10.64%) |
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 435624 475975 570691 454997 600350 395687 467583 549093 596351 537186 647938 550327 447454 509802 432970 599902 447150 593835 444906 425709 543877 645238 406308 494620 666881 567581 498497 193666 538190 396600 507310 680154 584550 478781 435664 467561 486776 558129 565283 466554 497560 529114 513780 720381 521923 553926 519261 482632 814069 566695 550305 563534 670112 716027 641395 394406 469923 446165 408601 548609 390533 480293 474036 499543 563411 649576 566691 603686 470778 526145 535028 530492 628365 637009 636998 640779 413971 447885 443480 532984 581726 615456 637731 478786 395981 531989 531085 568185 577376 567957 599937 600017 637147 775788 749266 483326 521927 453067 531242 531257 536618 533466 676025 679799 696996 648870 648871 703836 588298 593348 631195 631249 633747 632695 600290 628392 637078 600002 640763 641667 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (2.09%) |
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 193666 390533 394406 395687 395981 396600 406308 408601 413971 425709 432970 435624 435664 443480 444906 446165 447150 447454 447885 453067 454997 466554 467561 467583 469923 470778 474036 475975 478781 478786 480293 482632 483326 486776 494620 497560 498497 499543 507310 509802 513780 519261 521923 521927 526145 529114 530492 531085 531242 531257 531989 532984 533466 535028 536618 537186 538190 543877 548609 549093 550305 550327 553926 558129 563411 563534 565283 566691 566695 567581 567957 568185 570691 577376 581726 584550 588298 593348 593835 596351 599902 599937 600002 600017 600290 600350 603686 615456 628365 628392 631195 631249 632695 633747 636998 637009 637078 637147 637731 640763 640779 641395 641667 645238 647938 648870 648871 649576 666881 670112 676025 679799 680154 696996 703836 716027 720381 749266 775788 814069 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny double blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые double минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые double минет оральн секс"
]
|
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.