Query Metrics
7
Database Queries
7
Different statements
143.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.74 ms (82.06%) |
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 458584 477565 482172 494745 494750 512816 522405 542310 542825 543036 543068 543127 543139 543175 543179 543184 543185 543223 543249 543253 543260 543278 543281 543436 543451 543463 543513 543517 543776 543781 543783 543789 543801 544694 544708 547075 549146 549152 550252 550476 552044 552050 556927 556939 556948 556961 559056 562338 562339 562350 565968 566563 568336 569973 570161 570172 570740 574990 574995 575709 577074 580752 585111 585569 586490 586516 590259 591438 592297 592372 597665 598561 598929 605284 610076 616629 618752 621887 622923 623642 623645 626354 626356 628519 630822 630832 633860 641075 650370 658136 658542 669193 701811 702149 706381 706383 709589 710903 719107 727545 727554 732051 733271 747879 750227 752515 760398 770217 771251 772000 789015 799329 800084 802405 805459 810027 812266 820690 826282 ] |
||||||||||||||||||||||||||||||
|
14.36 ms (10.01%) |
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 597665 591438 549146 542310 719107 621887 810027 732051 610076 789015 585111 570172 543513 556948 565968 580752 805459 799329 650370 727545 543278 568336 543185 702149 556961 826156 544694 706381 592297 598929 630822 630832 800084 752515 747879 556927 543783 574990 820690 543801 701811 543776 550476 585569 552044 543175 543223 556939 570740 633860 543517 658136 812266 543179 543184 733271 482172 623642 547075 586490 598561 543068 543260 543436 628519 641075 458584 826282 562339 562338 543249 552050 566563 543781 574995 543127 586516 760398 709589 626356 770217 543253 543463 522405 477565 569973 570161 543789 772000 710903 559056 512816 543281 494750 658542 605284 592372 750227 727554 575709 802405 771251 494745 543139 543451 544708 706383 549152 550252 623645 622923 626354 618752 542825 669193 616629 562350 577074 590259 543036 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (2.72%) |
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 458584 477565 482172 494745 494750 512816 522405 542310 542825 543036 543068 543127 543139 543175 543179 543184 543185 543223 543249 543253 543260 543278 543281 543436 543451 543463 543513 543517 543776 543781 543783 543789 543801 544694 544708 547075 549146 549152 550252 550476 552044 552050 556927 556939 556948 556961 559056 562338 562339 562350 565968 566563 568336 569973 570161 570172 570740 574990 574995 575709 577074 580752 585111 585569 586490 586516 590259 591438 592297 592372 597665 598561 598929 605284 610076 616629 618752 621887 622923 623642 623645 626354 626356 628519 630822 630832 633860 641075 650370 658136 658542 669193 701811 702149 706381 706383 709589 710903 719107 727545 727554 732051 733271 747879 750227 752515 760398 770217 771251 772000 789015 799329 800084 802405 805459 810027 812266 820690 826282 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"arab blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"араб минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
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.