Query Metrics
7
Database Queries
7
Different statements
215.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.19 ms (86.96%) |
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 311897 385755 388729 409016 413277 414157 414256 415965 415981 415992 416515 416596 416635 420277 428174 428241 430103 430559 431540 432246 432274 432289 437859 446095 447191 448414 448588 449083 452436 455084 456232 456699 457966 460535 463689 466637 468165 470092 471455 473066 479727 480207 493411 494156 500340 500341 500748 502770 508541 516339 522167 532778 535621 537899 541440 541836 541850 545369 550124 551556 555056 568756 569594 590263 590373 592187 595249 598675 606597 611437 614957 623267 623333 628094 629287 639803 643671 654097 664091 671810 677147 680484 696598 697833 699767 702342 702357 709316 712162 714622 734483 737052 749693 752700 752709 752758 755079 758787 765248 765569 769100 770258 774712 776059 779560 787505 799937 800807 801313 803557 805228 806591 806688 808655 811296 817334 826589 827178 827294 ] |
||||||||||||||||||||||||||||||
|
17.84 ms (8.29%) |
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 551556 606597 639803 623267 800807 787505 769100 770258 752709 765569 452436 414157 500748 752700 432246 446095 494156 569594 677147 592187 590373 468165 541836 680484 493411 447191 508541 416596 432289 456232 466637 811296 413277 430559 448414 480207 568756 827294 455084 502770 664091 448588 414256 479727 409016 457966 522167 420277 428174 470092 532778 537899 541440 614957 630427 749693 806591 460535 463689 385755 416635 431540 516339 500340 500341 590263 471455 535621 473066 449083 456699 550124 388729 817334 826589 827178 654097 671810 699767 611437 774712 779560 805228 801313 765248 752758 697833 702342 702357 712162 714622 643671 734483 432274 415992 416515 430103 428241 415965 555056 541850 545369 696598 598675 628094 629287 595249 623333 808655 776059 799937 803557 737052 755079 806688 758787 709316 437859 311897 415981 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.41%) |
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 311897 385755 388729 409016 413277 414157 414256 415965 415981 415992 416515 416596 416635 420277 428174 428241 430103 430559 431540 432246 432274 432289 437859 446095 447191 448414 448588 449083 452436 455084 456232 456699 457966 460535 463689 466637 468165 470092 471455 473066 479727 480207 493411 494156 500340 500341 500748 502770 508541 516339 522167 532778 535621 537899 541440 541836 541850 545369 550124 551556 555056 568756 569594 590263 590373 592187 595249 598675 606597 611437 614957 623267 623333 628094 629287 639803 643671 654097 664091 671810 677147 680484 696598 697833 699767 702342 702357 709316 712162 714622 734483 737052 749693 752700 752709 752758 755079 758787 765248 765569 769100 770258 774712 776059 779560 787505 799937 800807 801313 803557 805228 806591 806688 808655 811296 817334 826589 827178 827294 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toys dildo anal"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"toys дилд анал"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"toys дилд анал"
]
|
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.