Query Metrics
7
Database Queries
7
Different statements
200.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.93 ms (85.91%) |
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 8207 51659 72666 90460 100535 181584 191343 246527 330764 361992 383149 383402 383659 389983 394134 394158 402063 404052 407636 408468 409272 409945 418377 419004 449337 462980 510315 557155 566559 566633 567729 585896 591895 594205 599800 610013 614950 621832 625727 634462 638131 640183 653081 654984 667749 669251 671375 673497 677743 682644 683478 684589 688142 690446 690830 692412 693702 693950 696279 698187 698196 701844 709815 711579 714156 714905 715352 718353 718604 722685 730450 730958 731685 736400 737395 737478 739443 739567 739624 742591 745261 752288 754792 755373 756017 764751 766886 775396 777277 778503 782330 783225 784232 786319 788498 789305 791991 793693 799717 800158 802442 804216 807343 807608 808212 808484 808500 810499 810576 810578 816810 817761 818599 818647 819942 821997 822921 825075 827302 828407 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (9.00%) |
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 383659 634462 566559 669251 714156 625727 730450 701844 696279 737395 777277 394158 407636 788498 361992 654984 690830 810499 778503 383149 72666 793693 739624 827302 821997 799717 246527 816810 599800 191343 394134 810576 667749 449337 817761 819942 822921 828407 671375 688142 693950 709815 677743 698196 614950 764751 808212 739567 754792 638131 698187 714905 808500 409272 51659 621832 90460 389983 419004 715352 566633 640183 594205 742591 745261 755373 736400 711579 718604 402063 418377 808484 409945 100535 383402 682644 786319 802442 408468 783225 653081 800158 684589 8207 404052 510315 818599 818647 825075 693702 718353 722685 690446 692412 591895 791991 775396 784232 804216 789305 807608 730958 739443 782330 807343 462980 557155 567729 756017 181584 330764 610013 752288 731685 737478 683478 673497 585896 810578 766886 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.40%) |
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 8207 51659 72666 90460 100535 181584 191343 246527 330764 361992 383149 383402 383659 389983 394134 394158 402063 404052 407636 408468 409272 409945 418377 419004 449337 462980 510315 557155 566559 566633 567729 585896 591895 594205 599800 610013 614950 621832 625727 634462 638131 640183 653081 654984 667749 669251 671375 673497 677743 682644 683478 684589 688142 690446 690830 692412 693702 693950 696279 698187 698196 701844 709815 711579 714156 714905 715352 718353 718604 722685 730450 730958 731685 736400 737395 737478 739443 739567 739624 742591 745261 752288 754792 755373 756017 764751 766886 775396 777277 778503 782330 783225 784232 786319 788498 789305 791991 793693 799717 800158 802442 804216 807343 807608 808212 808484 808500 810499 810576 810578 816810 817761 818599 818647 819942 821997 822921 825075 827302 828407 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex big tits"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.79%) |
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.