Query Metrics
7
Database Queries
7
Different statements
198.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.91 ms (85.74%) |
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 31106 66574 385953 389936 397409 401071 401946 413542 417711 438710 443361 454791 457521 466503 469231 469632 472065 474158 475772 475849 478673 486692 491875 496571 497034 507769 511299 511984 516035 521917 522404 523282 523666 528966 528995 529045 534347 537097 538695 549101 551527 551529 551554 552254 555967 559012 560178 560763 569017 570030 570251 570332 570521 570605 571077 571598 571909 572095 572096 572117 572808 572848 573880 577381 579131 588232 594952 601679 604065 614114 620808 633480 636065 638459 640351 642926 643074 644575 650447 661572 664208 669054 673424 693166 706589 710561 712720 714374 721012 721968 725476 727033 732248 740268 741044 743136 748067 751243 756081 757207 763729 768451 770017 776082 776890 778894 788935 794019 802252 808688 809057 810987 812129 812286 814384 816025 817618 818554 818795 823496 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (8.02%) |
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 528995 693166 636065 778894 732248 740268 474158 614114 496571 555967 817618 818554 816025 823496 457521 522404 537097 569017 572848 551554 650447 643074 802252 741044 748067 751243 633480 552254 443361 497034 401946 438710 491875 571598 669054 640351 812286 727033 776082 469632 572808 507769 534347 523666 529045 528966 572095 721968 516035 511299 31106 475849 570605 601679 551529 579131 712720 644575 620808 588232 642926 794019 809057 812129 808688 768451 763729 756081 389936 66574 664208 549101 570251 572096 770017 810987 397409 413542 385953 417711 486692 475772 721012 673424 521917 466503 511984 472065 560763 571909 559012 571077 572117 573880 638459 788935 757207 706589 776890 469231 560178 814384 818795 478673 538695 551527 570521 661572 714374 604065 594952 743136 725476 710561 401071 523282 570030 454791 570332 577381 ] |
||||||||||||||||||||||||||||||
|
5.50 ms (2.78%) |
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 31106 66574 385953 389936 397409 401071 401946 413542 417711 438710 443361 454791 457521 466503 469231 469632 472065 474158 475772 475849 478673 486692 491875 496571 497034 507769 511299 511984 516035 521917 522404 523282 523666 528966 528995 529045 534347 537097 538695 549101 551527 551529 551554 552254 555967 559012 560178 560763 569017 570030 570251 570332 570521 570605 571077 571598 571909 572095 572096 572117 572808 572848 573880 577381 579131 588232 594952 601679 604065 614114 620808 633480 636065 638459 640351 642926 643074 644575 650447 661572 664208 669054 673424 693166 706589 710561 712720 714374 721012 721968 725476 727033 732248 740268 741044 743136 748067 751243 756081 757207 763729 768451 770017 776082 776890 778894 788935 794019 802252 808688 809057 810987 812129 812286 814384 816025 817618 818554 818795 823496 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy public real"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy на real улиц"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy на real улиц"
]
|
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.