Query Metrics
7
Database Queries
7
Different statements
149.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.78 ms (83.26%) |
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 366036 387015 387603 391959 428375 428924 432963 435567 435572 438532 439532 441162 448575 452949 455603 459563 459718 459731 466356 471101 471110 477038 480671 493700 496714 511140 513460 513631 518614 537371 543993 553656 555075 555101 560337 561748 564102 564475 564642 576128 578857 596864 597081 600125 601460 605791 614631 617604 617796 619636 621755 623280 631358 640331 648570 655575 661424 666969 671479 678701 679491 686474 693310 700272 703619 703945 704072 704700 705451 712580 715584 718678 736813 738926 739113 741119 742364 742681 744266 751309 751571 760238 766401 766433 770383 772579 776829 778266 780192 781250 782093 782236 782274 782547 784671 785814 785982 786416 788360 791206 791212 792700 792715 792735 794041 799725 801628 806527 806577 806815 808337 808548 808796 811100 813558 814989 816176 827181 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (10.62%) |
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 704072 705451 715584 678701 693310 601460 776829 781250 782274 782547 785814 785982 806577 786416 794041 806505 807147 808337 808548 811100 766401 736813 742364 742681 744266 751571 760238 617796 703945 704700 780192 792700 792735 799725 806527 477038 459731 435572 537371 428375 432963 576128 718678 782236 560337 578857 387603 471110 564642 428924 455603 439532 518614 471101 700272 827181 816176 655575 366036 814989 813558 511140 493700 564475 564102 543993 553656 555101 666969 686474 703619 648570 679491 671479 712580 555075 614631 640331 617604 621755 619636 631358 806815 778266 791212 741119 766433 772579 784671 788360 801628 808796 739113 751309 738926 770383 623280 782093 791206 792715 459718 480671 448575 441162 438532 513631 513460 496714 466356 597081 605791 600125 391959 387015 452949 459563 435567 561748 661424 596864 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.59%) |
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 366036 387015 387603 391959 428375 428924 432963 435567 435572 438532 439532 441162 448575 452949 455603 459563 459718 459731 466356 471101 471110 477038 480671 493700 496714 511140 513460 513631 518614 537371 543993 553656 555075 555101 560337 561748 564102 564475 564642 576128 578857 596864 597081 600125 601460 605791 614631 617604 617796 619636 621755 623280 631358 640331 648570 655575 661424 666969 671479 678701 679491 686474 693310 700272 703619 703945 704072 704700 705451 712580 715584 718678 736813 738926 739113 741119 742364 742681 744266 751309 751571 760238 766401 766433 770383 772579 776829 778266 780192 781250 782093 782236 782274 782547 784671 785814 785982 786416 788360 791206 791212 792700 792715 792735 794041 799725 801628 806527 806577 806815 808337 808548 808796 811100 813558 814989 816176 827181 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo russian"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд русск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.97%) |
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.