Query Metrics
7
Database Queries
7
Different statements
212.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.43 ms (80.27%) |
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 81065 96530 386226 404036 406390 411893 415134 415635 417395 418640 418998 422513 422593 422643 422893 422958 422961 422987 423020 423042 425143 426431 429365 429764 429793 432779 435665 438283 443312 445048 445322 445563 446740 447904 448353 448826 448828 448926 451210 452154 452519 453439 453812 454882 456092 458624 461543 462779 464156 465118 465194 465618 465843 467339 467347 468031 468069 468586 468671 468772 469195 470418 471409 471863 471864 472165 472441 472764 473062 473733 474615 474865 475704 476075 479816 479865 480433 481920 486805 487721 491595 491762 495660 496997 497021 497879 498119 501891 503127 503406 512872 513340 513576 514710 520775 521455 522125 522949 523873 523919 523984 526120 527867 529070 529263 545698 554287 558614 568579 571847 586573 591077 595787 597028 598042 613819 631597 722812 811008 ] |
||||||||||||||||||||||||||||||
|
29.57 ms (13.93%) |
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 722812 811008 432779 467339 467347 473062 81065 426431 448353 465843 481920 404036 417395 454882 461543 465118 472165 474615 479865 480433 411893 415635 422961 451210 462779 429365 471409 514710 521455 512872 526120 497021 497879 523984 527557 491595 501891 513340 523919 529263 429764 447904 448828 453812 496997 554287 595787 438283 468671 448926 495660 523873 491762 503406 422958 429793 446740 527867 558614 571847 568579 597028 598042 591077 631597 472764 472441 422513 425143 468586 498119 513576 522125 613819 529070 452519 503127 471863 445563 479816 487721 415134 475704 545698 586573 473733 520775 522949 386226 96530 406390 418640 422643 422893 423020 445048 418998 422987 422593 443312 423042 435665 445322 453439 464156 465194 465618 468069 469195 470418 474865 486805 448826 452154 456092 458624 468031 468772 471864 476075 ] |
||||||||||||||||||||||||||||||
|
5.03 ms (2.37%) |
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 81065 96530 386226 404036 406390 411893 415134 415635 417395 418640 418998 422513 422593 422643 422893 422958 422961 422987 423020 423042 425143 426431 429365 429764 429793 432779 435665 438283 443312 445048 445322 445563 446740 447904 448353 448826 448828 448926 451210 452154 452519 453439 453812 454882 456092 458624 461543 462779 464156 465118 465194 465618 465843 467339 467347 468031 468069 468586 468671 468772 469195 470418 471409 471863 471864 472165 472441 472764 473062 473733 474615 474865 475704 476075 479816 479865 480433 481920 486805 487721 491595 491762 495660 496997 497021 497879 498119 501891 503127 503406 512872 513340 513576 514710 520775 521455 522125 522949 523873 523919 523984 526120 527867 529070 529263 545698 554287 558614 568579 571847 586573 591077 595787 597028 598042 613819 631597 722812 811008 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man casting"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.63%) |
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.