Query Metrics
7
Database Queries
7
Different statements
167.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.21 ms (82.59%) |
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 188117 309449 312264 338075 387782 388219 398484 403334 409060 411681 423657 424248 430389 430543 437470 440911 443243 451042 466218 468631 474674 475836 482605 484735 485242 490261 496792 510395 512079 515934 516375 517847 519567 522885 522909 523027 523868 531121 531227 531236 531250 531836 531840 531861 532746 532804 532839 533064 534542 534545 536210 536305 536339 538817 541832 541849 566698 581302 583496 584001 598648 598918 599847 599958 600249 601636 603151 611307 613000 617428 620794 621314 621656 631178 632268 633150 636299 637042 637492 639752 640534 646152 646849 647939 650175 650459 669046 674519 676092 681547 699695 701237 708465 714122 715497 720072 731877 744775 745326 748695 756472 761530 770124 770125 775024 775946 786120 789529 789961 790382 794824 805990 806087 807617 809468 814037 816882 817377 818851 ] |
||||||||||||||||||||||||||||||
|
17.26 ms (10.32%) |
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 516375 517847 647939 621656 636299 523027 621314 611307 531840 531861 699695 775024 745326 430389 443243 816882 475836 482605 532804 531227 538817 490261 646152 650459 598918 633150 637042 601636 640534 775946 805990 731877 756472 806087 809468 309449 598648 188117 632268 398484 474674 466218 430543 541849 786120 423657 536339 531236 581302 650175 681547 720072 676092 566698 583496 584001 411681 510395 496792 515934 485242 522909 519567 409060 424248 531250 532746 531121 770124 817377 536305 531294 531836 761530 744775 312264 338075 818851 814037 534545 536210 512079 522885 534542 669046 715497 701237 674519 613000 637492 603151 807617 789529 790382 794824 770125 748695 599847 714122 440911 541832 451042 484735 403334 789961 388219 523868 639752 617428 620794 631178 437470 387782 468631 708465 599958 532839 533064 646849 600249 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (2.26%) |
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 188117 309449 312264 338075 387782 388219 398484 403334 409060 411681 423657 424248 430389 430543 437470 440911 443243 451042 466218 468631 474674 475836 482605 484735 485242 490261 496792 510395 512079 515934 516375 517847 519567 522885 522909 523027 523868 531121 531227 531236 531250 531836 531840 531861 532746 532804 532839 533064 534542 534545 536210 536305 536339 538817 541832 541849 566698 581302 583496 584001 598648 598918 599847 599958 600249 601636 603151 611307 613000 617428 620794 621314 621656 631178 632268 633150 636299 637042 637492 639752 640534 646152 646849 647939 650175 650459 669046 674519 676092 681547 699695 701237 708465 714122 715497 720072 731877 744775 745326 748695 756472 761530 770124 770125 775024 775946 786120 789529 789961 790382 794824 805990 806087 807617 809468 814037 816882 817377 818851 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал double"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal double"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал double"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.16%) |
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.