Query Metrics
7
Database Queries
7
Different statements
161.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.60 ms (82.96%) |
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 62175 118164 384117 387334 390573 400942 401841 413958 435593 441129 471663 478038 488724 491368 495726 510822 512352 516064 517928 530272 530384 530791 530796 530941 531089 531202 531235 531419 532343 532913 533063 533382 535054 541846 543249 565161 566563 574656 580290 582323 590377 590411 599875 599890 599899 600185 601600 604513 606101 639258 639719 639752 639784 640435 641678 642002 642016 642018 642660 643079 644918 644941 644986 644998 646029 646786 647939 648795 648839 648868 651607 656916 662423 666853 668526 669000 676623 678063 678128 678493 680484 683261 688617 705277 707315 708441 720138 721141 721184 722428 728215 730074 731916 733981 738476 738487 750549 758325 761176 770058 775859 777057 777577 779610 779682 781615 783425 786454 787047 787101 787427 788790 800334 801880 801957 809104 809412 811491 812639 813770 ] |
||||||||||||||||||||||||||||||
|
17.43 ms (10.83%) |
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 62175 491368 730074 471663 390573 512352 384117 118164 387334 400942 413958 441129 495726 510822 574656 656916 722428 783425 738487 738476 728215 761176 720138 435593 401841 516064 733981 721184 775859 813770 809412 812639 787101 731916 770058 721141 478038 644986 639258 642660 639719 642016 644998 533063 643079 543249 644941 566563 705277 669000 707315 606101 777057 777577 779682 800334 809104 779610 787047 788790 801957 750549 786454 811491 758325 640435 781615 787427 801880 644918 488724 530272 530384 530796 533382 531202 532343 532913 535054 517928 530791 530941 531089 531235 531419 580290 582323 541846 565161 651607 662423 678493 688617 648795 648839 666853 668526 678063 683261 646029 646786 647939 648868 676623 678128 680484 708441 599890 600185 604513 639784 641678 642002 642018 590411 601600 639752 590377 599875 599899 ] |
||||||||||||||||||||||||||||||
|
2.76 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 62175 118164 384117 387334 390573 400942 401841 413958 435593 441129 471663 478038 488724 491368 495726 510822 512352 516064 517928 530272 530384 530791 530796 530941 531089 531202 531235 531419 532343 532913 533063 533382 535054 541846 543249 565161 566563 574656 580290 582323 590377 590411 599875 599890 599899 600185 601600 604513 606101 639258 639719 639752 639784 640435 641678 642002 642016 642018 642660 643079 644918 644941 644986 644998 646029 646786 647939 648795 648839 648868 651607 656916 662423 666853 668526 669000 676623 678063 678128 678493 680484 683261 688617 705277 707315 708441 720138 721141 721184 722428 728215 730074 731916 733981 738476 738487 750549 758325 761176 770058 775859 777057 777577 779610 779682 781615 783425 786454 787047 787101 787427 788790 800334 801880 801957 809104 809412 811491 812639 813770 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жесткое порно с милфами"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор порн милф"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.95%) |
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.