Query Metrics
7
Database Queries
7
Different statements
188.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.79 ms (85.95%) |
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 352211 413234 415961 416214 416230 421290 422961 423326 423770 430396 430943 431740 433983 435671 436675 439318 441046 443569 444727 445889 446259 447099 447353 447778 448573 449274 449957 449985 451075 452864 453503 453604 453707 458872 459583 461299 461459 461483 466745 470269 473330 474626 475322 475422 475635 475902 478788 480438 482636 484261 488730 489593 490111 496200 498639 500873 502447 502747 503787 506063 507175 507979 510399 510628 512644 514112 516743 518505 522113 523978 524366 525940 528773 530622 536118 543032 548766 548776 550175 551770 556013 559803 561716 563697 571901 572920 573416 582780 583102 603976 607152 610300 611204 613778 645951 651885 660399 663287 665957 714524 735518 738814 751432 760105 760550 762082 779706 781426 783191 783370 786074 786435 804140 805164 805712 805975 806529 807987 818571 823326 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (8.19%) |
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 506063 507175 760105 413234 421290 423326 484261 449985 475322 530622 536118 543032 582780 663287 603976 805164 806529 452864 436675 461483 447778 445889 523978 525940 502447 352211 571901 563697 804140 781426 760550 762082 779706 807987 430943 448573 475635 461459 433983 453604 510628 510399 474626 415961 818571 475902 583102 783191 805712 783370 786074 423770 447353 512644 502747 660399 665957 738814 435671 441046 430396 444727 823326 482636 446259 475422 449957 451075 453503 447099 449274 503787 524366 528773 496200 466745 478788 550175 551770 548776 559803 573416 548766 561716 645951 651885 714524 556013 572920 613778 607152 610300 611204 805975 751432 416214 431740 453707 461299 458872 470269 480438 439318 459583 422961 473330 443569 507979 514112 516743 488730 518505 522113 498639 500873 489593 490111 786435 735518 416230 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.56%) |
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 352211 413234 415961 416214 416230 421290 422961 423326 423770 430396 430943 431740 433983 435671 436675 439318 441046 443569 444727 445889 446259 447099 447353 447778 448573 449274 449957 449985 451075 452864 453503 453604 453707 458872 459583 461299 461459 461483 466745 470269 473330 474626 475322 475422 475635 475902 478788 480438 482636 484261 488730 489593 490111 496200 498639 500873 502447 502747 503787 506063 507175 507979 510399 510628 512644 514112 516743 518505 522113 523978 524366 525940 528773 530622 536118 543032 548766 548776 550175 551770 556013 559803 561716 563697 571901 572920 573416 582780 583102 603976 607152 610300 611204 613778 645951 651885 660399 663287 665957 714524 735518 738814 751432 760105 760550 762082 779706 781426 783191 783370 786074 786435 804140 805164 805712 805975 806529 807987 818571 823326 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long girls"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные девушк"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
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.