Query Metrics
7
Database Queries
7
Different statements
155.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.33 ms (87.90%) |
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 6853 69704 108555 382568 383388 386990 395291 415576 426009 442255 444321 461252 475543 512203 513483 518576 520930 521167 522827 532425 533721 536031 536706 541102 552000 554464 556965 559878 563502 564441 570875 576149 578470 585453 585498 588230 588344 588346 588367 588417 588625 589544 594871 594873 600331 600783 601264 601308 607870 608042 610573 611920 611948 611958 612018 612991 621686 624240 625760 627114 635903 646023 663811 667473 671665 674183 683284 689807 689833 689849 700586 701660 702067 703181 711346 715477 722537 723665 723693 723952 725502 730979 735901 737333 739250 741494 742104 743138 744208 744326 754537 755134 757565 758358 759037 759451 760549 760633 760860 762261 762549 769253 770100 770236 771757 771976 777843 785974 788635 794109 800825 802243 805125 810051 810062 811813 815441 818215 818652 827851 ] |
||||||||||||||||||||||||||||||
|
10.09 ms (6.51%) |
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 559878 588230 635903 601264 611958 588344 600331 805125 777843 742104 744208 788635 811813 762549 770100 754537 771976 758358 760549 715477 382568 426009 442255 415576 444321 512203 520930 475543 513483 518576 521167 532425 522827 6853 552000 576149 563502 671665 689833 663811 689849 722537 556965 611920 585453 601308 802243 741494 771757 785974 461252 646023 701660 624240 108555 386990 815441 723665 818215 818652 827851 536031 536706 554464 570875 541102 667473 674183 703181 711346 683284 689807 702067 594871 588346 610573 612991 585498 594873 611948 588367 600783 625760 627114 810051 794109 723693 723952 725502 759037 759451 760633 730979 757565 762261 769253 770236 735901 755134 760860 737333 739250 612018 700586 800825 810062 69704 383388 533721 578470 621686 744326 608042 589544 564441 588625 588417 743138 395291 607870 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.76%) |
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 6853 69704 108555 382568 383388 386990 395291 415576 426009 442255 444321 461252 475543 512203 513483 518576 520930 521167 522827 532425 533721 536031 536706 541102 552000 554464 556965 559878 563502 564441 570875 576149 578470 585453 585498 588230 588344 588346 588367 588417 588625 589544 594871 594873 600331 600783 601264 601308 607870 608042 610573 611920 611948 611958 612018 612991 621686 624240 625760 627114 635903 646023 663811 667473 671665 674183 683284 689807 689833 689849 700586 701660 702067 703181 711346 715477 722537 723665 723693 723952 725502 730979 735901 737333 739250 741494 742104 743138 744208 744326 754537 755134 757565 758358 759037 759451 760549 760633 760860 762261 762549 769253 770100 770236 771757 771976 777843 785974 788635 794109 800825 802243 805125 810051 810062 811813 815441 818215 818652 827851 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office girl"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш девушк"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.83%) |
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.