Query Metrics
7
Database Queries
7
Different statements
141.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.21 ms (84.09%) |
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 13249 17058 150798 382158 397079 400668 401666 408318 418836 461677 462784 464903 467938 469778 471111 508916 510368 515990 526143 526273 530750 536516 538760 541270 546784 548957 561012 566393 568478 568524 580119 584298 601550 604309 604361 604565 605155 605401 607254 613445 614035 620480 627418 640375 652874 656483 662070 665976 668663 669967 673665 680472 683052 687310 687583 695603 699767 700925 701001 715092 715737 717072 718651 718666 718679 718687 718704 720651 722583 722649 728146 731615 731827 735964 736233 736324 737185 738121 740073 741193 741959 745424 747119 747142 747493 747519 748343 748710 750582 750660 756670 756678 758194 758720 760453 761555 761595 766637 766691 768419 768729 770419 770911 785582 787505 789184 791529 795137 795630 798736 801286 801540 804995 814851 814962 815023 815541 821197 822067 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (8.89%) |
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 715737 13249 607254 804995 720651 150798 418836 469778 17058 695603 798736 737185 768729 728146 766691 604565 791529 408318 526273 464903 568524 668663 680472 687583 620480 766637 461677 530750 401666 510368 814851 815541 471111 795137 795630 748710 770911 397079 815023 538760 561012 541270 687310 701001 718704 662070 669967 673665 683052 652874 717072 722649 548957 580119 614035 640375 605401 605155 785582 731827 747142 747519 760453 787505 741959 748343 745424 747493 758720 735964 761555 768419 741193 747119 750582 761595 770419 771893 613445 718666 718679 718687 462784 821197 822067 546784 568478 627418 604309 789184 736233 758194 756670 756678 738121 508916 467938 515990 715092 718651 656483 722583 736324 740073 731615 814962 526143 604361 536516 400668 382158 566393 584298 700925 665976 699767 601550 801540 801286 750660 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.71%) |
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 13249 17058 150798 382158 397079 400668 401666 408318 418836 461677 462784 464903 467938 469778 471111 508916 510368 515990 526143 526273 530750 536516 538760 541270 546784 548957 561012 566393 568478 568524 580119 584298 601550 604309 604361 604565 605155 605401 607254 613445 614035 620480 627418 640375 652874 656483 662070 665976 668663 669967 673665 680472 683052 687310 687583 695603 699767 700925 701001 715092 715737 717072 718651 718666 718679 718687 718704 720651 722583 722649 728146 731615 731827 735964 736233 736324 737185 738121 740073 741193 741959 745424 747119 747142 747493 747519 748343 748710 750582 750660 756670 756678 758194 758720 760453 761555 761595 766637 766691 768419 768729 770419 770911 785582 787505 789184 791529 795137 795630 798736 801286 801540 804995 814851 814962 815023 815541 821197 822067 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big toys anal"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие toys анал"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.26%) |
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.