Query Metrics
7
Database Queries
7
Different statements
211.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.09 ms (84.64%) |
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 414317 414783 417690 417744 418640 420478 422920 424904 427937 428801 429049 429313 429635 432766 435411 437638 443427 444652 445322 446263 447531 449085 452269 453122 453235 453817 454284 454980 457406 464211 464355 465093 465651 467179 467347 467968 468069 468323 468597 468638 468757 469670 470418 470436 471387 471784 471827 472479 474615 479846 481786 482188 483461 484278 485720 486058 486363 488537 490180 491595 492681 492717 495214 497517 498480 498698 500768 501535 510438 510672 513188 514618 516055 518032 518362 518771 522932 523320 524055 524795 524902 525107 531490 532782 536604 539233 561707 564306 566063 566071 581770 582548 588647 592299 594937 597264 597268 597269 598206 606687 623124 634135 634169 649857 667636 668537 669781 672984 680108 682916 689582 704857 714730 727799 732917 745322 770133 775911 803187 811944 ] |
||||||||||||||||||||||||||||||
|
22.22 ms (10.50%) |
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 491595 422920 453122 464355 561707 649857 745322 714730 467347 471827 474615 522932 514618 518362 524055 510672 467968 525107 536604 566063 501535 414783 420478 516055 492681 566071 443427 472479 582548 490180 689582 564306 606687 468638 427937 634135 811944 727799 775911 469670 672984 680108 682916 634169 597269 732917 770133 447531 495214 539233 471784 667636 623124 453817 497517 484278 444652 445322 452269 454980 668537 597264 598206 424904 429313 482188 468757 468323 488537 418640 428801 471387 465093 470436 498698 500768 581770 592299 486363 523320 453235 454284 457406 417690 417744 465651 464211 468069 483461 485720 513188 532782 669781 704857 594937 597268 803187 446263 481786 429049 429635 468597 524902 486058 518032 518771 492717 414317 498480 588647 449085 437638 479846 510438 524795 432766 470418 531490 435411 467179 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.39%) |
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 414317 414783 417690 417744 418640 420478 422920 424904 427937 428801 429049 429313 429635 432766 435411 437638 443427 444652 445322 446263 447531 449085 452269 453122 453235 453817 454284 454980 457406 464211 464355 465093 465651 467179 467347 467968 468069 468323 468597 468638 468757 469670 470418 470436 471387 471784 471827 472479 474615 479846 481786 482188 483461 484278 485720 486058 486363 488537 490180 491595 492681 492717 495214 497517 498480 498698 500768 501535 510438 510672 513188 514618 516055 518032 518362 518771 522932 523320 524055 524795 524902 525107 531490 532782 536604 539233 561707 564306 566063 566071 581770 582548 588647 592299 594937 597264 597268 597269 598206 606687 623124 634135 634169 649857 667636 668537 669781 672984 680108 682916 689582 704857 714730 727799 732917 745322 770133 775911 803187 811944 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex casting 2021"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.74%) |
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.