Query Metrics
7
Database Queries
7
Different statements
166.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.63 ms (83.10%) |
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 70191 384809 386016 387720 388723 421377 426367 443765 443791 446695 448832 469084 471792 476905 481904 483752 490307 496792 503866 508699 511254 513265 515934 517847 522895 522913 523565 523868 528098 530791 531089 531186 531188 531235 532174 532343 532363 533382 534566 534808 535054 535456 536207 536286 536538 537203 537672 540511 540577 541336 547470 547936 550205 555091 559121 559162 561131 581383 583496 584073 589761 595768 599852 599861 599941 599994 600215 600275 600295 600334 600340 600354 600968 604902 610271 612855 617418 620663 630679 634131 634782 634789 636070 643079 647932 649147 649186 650175 650846 665662 671732 676092 678962 681547 710412 710485 719336 720241 720288 728268 729814 738619 759948 770124 770546 775846 779560 783109 796976 801941 801967 802161 803392 803659 804765 806113 807951 808059 818404 818852 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (10.58%) |
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 541336 550205 559121 561131 581383 650175 681547 720288 649186 650846 676092 719336 583496 634131 595768 600340 617418 643079 599852 600215 600275 600354 600968 599941 599994 600295 600334 620663 634782 803659 471792 496792 508699 515934 522895 528098 729814 448832 535456 522913 728268 671732 387720 469084 710412 770124 536538 647932 503866 443765 476905 559162 678962 610271 384809 443791 523868 511254 540577 517847 599861 584073 540511 388723 70191 612855 808059 738619 818852 818404 604902 446695 483752 547936 710485 589761 779560 386016 536207 532174 532363 536286 531188 534566 534808 547470 555091 649147 665662 630679 775846 803392 804765 806113 796976 802161 759948 783109 801967 770546 634789 636070 720241 801941 807951 421377 426367 513265 490307 523565 481904 533382 537672 531186 532343 535054 537203 530791 531089 531235 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.65%) |
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 70191 384809 386016 387720 388723 421377 426367 443765 443791 446695 448832 469084 471792 476905 481904 483752 490307 496792 503866 508699 511254 513265 515934 517847 522895 522913 523565 523868 528098 530791 531089 531186 531188 531235 532174 532343 532363 533382 534566 534808 535054 535456 536207 536286 536538 537203 537672 540511 540577 541336 547470 547936 550205 555091 559121 559162 561131 581383 583496 584073 589761 595768 599852 599861 599941 599994 600215 600275 600295 600334 600340 600354 600968 604902 610271 612855 617418 620663 630679 634131 634782 634789 636070 643079 647932 649147 649186 650175 650846 665662 671732 676092 678962 681547 710412 710485 719336 720241 720288 728268 729814 738619 759948 770124 770546 775846 779560 783109 796976 801941 801967 802161 803392 803659 804765 806113 807951 808059 818404 818852 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"двойное зрелая"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"двойн зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.89%) |
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.