Query Metrics
7
Database Queries
7
Different statements
189.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.04 ms (82.99%) |
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 398412 399445 413898 420494 425479 429611 430429 437176 441300 453015 469684 473018 474944 477497 478773 481657 483048 483993 489160 492583 493273 495432 495977 501829 508732 508834 510350 511703 517103 521348 523916 524913 531273 536125 544875 549299 549562 550215 554346 556308 557445 559515 560434 561330 562047 565839 567701 568961 572241 575831 576351 579116 579433 583426 584185 584664 585680 591032 601691 602648 607211 613372 613426 622585 630504 633908 651911 654492 654766 655591 656046 656335 656349 657987 658005 658051 659578 659757 659794 664655 666611 668737 668849 674006 687584 690894 694499 695544 697226 716804 718893 721561 725398 729758 730478 738147 743807 746561 748688 760340 764042 764530 767448 767478 768367 773199 783734 789049 793224 794662 802094 804834 808825 809201 814216 817018 820430 822292 826759 ] |
||||||||||||||||||||||||||||||
|
21.17 ms (11.19%) |
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 531273 549299 550215 544875 554346 657987 659578 659757 694499 721561 654492 656349 658051 666611 687584 651911 656046 656335 668737 674006 602648 613372 630504 789049 802094 804834 809201 738147 760340 794662 808825 768367 729758 730478 748688 764042 767478 697226 826759 817018 822292 826111 556308 718893 793224 783734 746561 655591 474944 492583 536125 695544 767448 773199 469684 495432 575831 425479 441300 413898 429611 549562 561330 557445 579116 583426 559515 567701 690894 562047 576351 579433 585680 601691 607211 420494 398412 437176 478773 483048 814216 584185 584664 659794 668849 654766 658005 633908 743807 764530 725398 664655 613426 568961 510350 493273 495977 716804 591032 572241 820430 622585 560434 430429 489160 565839 481657 399445 453015 473018 477497 523916 501829 508834 483993 511703 524913 508732 517103 521348 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.86%) |
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 398412 399445 413898 420494 425479 429611 430429 437176 441300 453015 469684 473018 474944 477497 478773 481657 483048 483993 489160 492583 493273 495432 495977 501829 508732 508834 510350 511703 517103 521348 523916 524913 531273 536125 544875 549299 549562 550215 554346 556308 557445 559515 560434 561330 562047 565839 567701 568961 572241 575831 576351 579116 579433 583426 584185 584664 585680 591032 601691 602648 607211 613372 613426 622585 630504 633908 651911 654492 654766 655591 656046 656335 656349 657987 658005 658051 659578 659757 659794 664655 666611 668737 668849 674006 687584 690894 694499 695544 697226 716804 718893 721561 725398 729758 730478 738147 743807 746561 748688 760340 764042 764530 767448 767478 768367 773199 783734 789049 793224 794662 802094 804834 808825 809201 814216 817018 820430 822292 826759 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob skinny handjob"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член худые дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.82%) |
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.