Query Metrics
7
Database Queries
7
Different statements
185.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.30 ms (85.88%) |
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 451878 478425 481115 498765 501324 501509 502136 509251 512950 513905 514697 515895 516407 518126 528108 533867 536147 540805 544741 547573 551368 559256 565011 566116 583732 586322 586505 587821 590472 591170 591341 595137 598903 602509 603363 606152 610266 613153 613880 615685 619013 623361 624378 625605 626124 629855 631207 634422 635259 643573 645349 647026 647996 653807 666709 681782 686877 695123 700760 715497 720965 724304 725166 729265 733195 733246 733577 737588 738347 742684 744777 745896 746117 755132 756294 759088 760973 762028 763187 763296 763762 763890 766883 768590 773982 775173 775984 775992 775994 776219 776375 776894 777646 779576 779941 780072 783033 783742 785849 787006 789533 789870 789901 790114 790155 790933 791279 791457 791782 794824 800109 802801 803208 803723 804518 808751 808908 810187 813029 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (7.95%) |
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 777646 779576 789870 775173 808908 729265 733246 746117 760973 775992 785849 512950 478425 759088 547573 619013 808751 789901 744777 800109 766883 763762 783559 791782 647026 603363 629855 695123 516407 533867 536147 715497 566116 598903 606152 623361 591170 610266 625605 780072 804518 776219 776894 724304 745896 787006 791457 794824 763187 742684 773982 738347 763890 613153 775984 775994 776375 451878 513905 613880 587821 498765 518126 528108 666709 686877 615685 544741 783033 626124 737588 756294 515895 514697 645349 653807 595137 635259 624378 802801 790114 803723 733195 755132 733577 763296 559256 720965 681782 590472 602509 803208 813029 790933 631207 501509 509251 591341 768590 501324 540805 586505 586322 634422 643573 790155 779941 791279 789533 810187 725166 762028 700760 783742 481115 502136 583732 551368 647996 565011 ] |
||||||||||||||||||||||||||||||
|
4.48 ms (2.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 451878 478425 481115 498765 501324 501509 502136 509251 512950 513905 514697 515895 516407 518126 528108 533867 536147 540805 544741 547573 551368 559256 565011 566116 583732 586322 586505 587821 590472 591170 591341 595137 598903 602509 603363 606152 610266 613153 613880 615685 619013 623361 624378 625605 626124 629855 631207 634422 635259 643573 645349 647026 647996 653807 666709 681782 686877 695123 700760 715497 720965 724304 725166 729265 733195 733246 733577 737588 738347 742684 744777 745896 746117 755132 756294 759088 760973 762028 763187 763296 763762 763890 766883 768590 773982 775173 775984 775992 775994 776219 776375 776894 777646 779576 779941 780072 783033 783742 785849 787006 789533 789870 789901 790114 790155 790933 791279 791457 791782 794824 800109 802801 803208 803723 804518 808751 808908 810187 813029 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк кремпа сперм"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк кремпа сперм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочит и кончает внутрь"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.