Query Metrics
7
Database Queries
7
Different statements
207.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.85 ms (85.12%) |
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 385977 396339 398599 418131 419461 419633 422324 423084 429142 431702 433939 435548 438605 441363 448898 451692 452908 457383 459155 463211 464790 466863 469741 475422 475770 478988 492537 494545 497909 502202 502789 507955 508898 510904 515561 518514 529093 536062 536129 547942 550021 551845 555014 558324 568303 579587 579611 580656 586995 595524 596440 596828 597610 598503 598512 598818 602335 622297 627310 630123 632402 651218 662438 666062 668292 687285 704701 707425 709786 719573 723242 733594 735160 738098 738464 740902 740909 749134 749677 752556 752918 757730 759806 760563 762215 767830 768509 773054 777765 777982 778110 780164 780382 782044 782055 784664 785977 789236 790447 791019 791587 792232 792992 794424 795370 795921 802305 803039 804614 804699 806133 806375 809967 810372 810381 810463 811768 812193 812695 813359 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (8.73%) |
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 760563 767830 768509 735160 738098 740909 749134 749677 752556 757730 759806 762215 773054 602335 630123 632402 704701 707425 723242 777982 778110 780164 780382 782044 782055 785977 789236 790447 791019 791587 795370 795921 802305 804699 806133 806375 810372 810381 810463 811768 812193 812695 813359 508898 507955 627310 804614 784664 752918 423084 448898 510904 441363 536062 536129 464790 666062 668292 662438 709786 596440 595524 777765 792232 740902 794424 809967 733594 719573 463211 435548 459155 398599 492537 502202 803039 385977 396339 429142 431702 422324 433939 418131 419461 419633 438605 452908 469741 475422 451692 457383 478988 502789 494545 515561 529093 497909 518514 466863 475770 555014 558324 568303 579587 547942 580656 551845 651218 687285 550021 579611 598818 596828 598503 598512 622297 597610 586995 792992 738464 ] |
||||||||||||||||||||||||||||||
|
4.35 ms (2.09%) |
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 385977 396339 398599 418131 419461 419633 422324 423084 429142 431702 433939 435548 438605 441363 448898 451692 452908 457383 459155 463211 464790 466863 469741 475422 475770 478988 492537 494545 497909 502202 502789 507955 508898 510904 515561 518514 529093 536062 536129 547942 550021 551845 555014 558324 568303 579587 579611 580656 586995 595524 596440 596828 597610 598503 598512 598818 602335 622297 627310 630123 632402 651218 662438 666062 668292 687285 704701 707425 709786 719573 723242 733594 735160 738098 738464 740902 740909 749134 749677 752556 752918 757730 759806 760563 762215 767830 768509 773054 777765 777982 778110 780164 780382 782044 782055 784664 785977 789236 790447 791019 791587 792232 792992 794424 795370 795921 802305 803039 804614 804699 806133 806375 809967 810372 810381 810463 811768 812193 812695 813359 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam solo pussy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер соло pussy"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер соло pussy"
]
|
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.