Query Metrics
7
Database Queries
7
Different statements
400.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.17 ms (52.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs milf"
]
|
||||||||||||||||||||||||||||||
|
171.95 ms (42.98%) |
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 7456 27593 191698 384780 386430 386991 387192 396779 401692 474506 492431 492460 499231 502755 514273 527787 529871 532287 537134 539215 540554 543492 546500 550170 550174 553426 555522 556813 557525 564032 564759 565130 569392 581500 586146 588388 602741 604867 612041 613107 625435 629978 639540 641372 644906 653339 672406 673793 674102 687149 712026 728456 729649 730620 735398 742918 754504 755396 758157 761457 761956 768236 775121 775135 776798 776815 776820 781937 781966 784213 794275 796577 799046 801389 801488 802998 807143 807387 808122 808209 811335 811496 813658 815335 815575 815918 816706 816910 817089 817143 817360 817472 817489 817605 817635 817710 819234 824738 824739 824761 824962 824968 825170 826247 826402 826406 828043 828143 828219 828488 828537 828650 828710 828713 ] |
||||||||||||||||||||||||||||||
|
11.74 ms (2.94%) |
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 687149 191698 813658 824210 828713 543492 828650 672406 641372 815335 816910 815575 815918 539215 540554 565130 612041 828143 761956 492431 529871 532287 564032 557525 639540 794275 758157 384780 826247 828040 828537 629978 784213 808209 556813 625435 807387 796577 602741 817089 819234 492460 581500 811335 27593 401692 825170 824968 817143 828710 499231 527787 735398 755396 799046 808122 823717 644906 673793 801389 7456 817710 817635 613107 387192 781937 776798 729649 386991 776815 776820 555522 586146 811496 514273 502755 828080 828043 828488 816706 822666 817605 824404 826406 775121 802998 807143 550174 588388 817360 550170 781966 386430 396779 824761 817472 824962 826402 817489 824738 824739 828219 537134 474506 564759 569392 553426 546500 674102 712026 653339 604867 775135 801488 742918 761457 768236 728456 730620 754504 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (0.66%) |
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 7456 27593 191698 384780 386430 386991 387192 396779 401692 474506 492431 492460 499231 502755 514273 527787 529871 532287 537134 539215 540554 543492 546500 550170 550174 553426 555522 556813 557525 564032 564759 565130 569392 581500 586146 588388 602741 604867 612041 613107 625435 629978 639540 641372 644906 653339 672406 673793 674102 687149 712026 728456 729649 730620 735398 742918 754504 755396 758157 761457 761956 768236 775121 775135 776798 776815 776820 781937 781966 784213 794275 796577 799046 801389 801488 802998 807143 807387 808122 808209 811335 811496 813658 815335 815575 815918 816706 816910 817089 817143 817360 817472 817489 817605 817635 817710 819234 824738 824739 824761 824962 824968 825170 826247 826402 826406 828043 828143 828219 828488 828537 828650 828710 828713 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs milf"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs milf"
]
|
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.