Query Metrics
7
Database Queries
7
Different statements
176.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.96 ms (83.68%) |
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 384745 393531 393790 394235 396313 398805 411938 413824 414021 414110 418640 418641 425117 427230 450778 458774 458777 461723 469646 471520 491067 491193 491198 492681 506213 507352 507375 511889 514593 515118 523025 524146 524185 524566 546822 549774 552076 563144 566527 570051 570074 570638 575072 576020 576292 586817 588266 592459 592512 598041 598450 601877 609866 624235 644989 696212 698610 701010 706343 710549 718716 730579 731982 732129 732445 736917 741438 741479 741990 745811 747410 747895 749135 752149 754856 758439 759663 761071 774079 774160 785019 788438 789299 789313 802632 807938 810316 810843 812160 813660 814084 815291 816258 816549 817310 817623 817660 817683 817816 817900 818083 818232 819047 819698 820079 821178 821628 821861 821928 821976 822178 822182 822718 824355 825037 825682 826097 826734 827465 ] |
||||||||||||||||||||||||||||||
|
18.04 ms (10.20%) |
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 732445 741438 741990 754856 759663 771786 736917 745811 752149 758439 761071 774160 730579 731982 732129 747410 747895 749135 741479 774079 609866 624235 698610 706343 710549 718716 785019 788438 789299 789313 802632 807938 810316 810843 812160 393531 398805 414110 396313 418640 418641 411938 450778 511889 563144 570051 575072 552076 576020 570638 549774 566527 576292 588266 592459 598041 598450 601877 586817 592512 384745 414021 427230 458774 471520 425117 394235 413824 458777 393790 469646 524146 524185 492681 514593 491067 507375 524566 491193 491198 507352 523025 506213 570074 696212 701010 461723 813660 814084 817683 817816 817900 818083 821628 824355 644989 826734 815291 819047 819698 821178 821976 816258 816549 817623 817660 818232 820079 821928 822182 825037 817310 821861 822178 822718 825682 826097 827465 515118 546822 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.72%) |
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 384745 393531 393790 394235 396313 398805 411938 413824 414021 414110 418640 418641 425117 427230 450778 458774 458777 461723 469646 471520 491067 491193 491198 492681 506213 507352 507375 511889 514593 515118 523025 524146 524185 524566 546822 549774 552076 563144 566527 570051 570074 570638 575072 576020 576292 586817 588266 592459 592512 598041 598450 601877 609866 624235 644989 696212 698610 701010 706343 710549 718716 730579 731982 732129 732445 736917 741438 741479 741990 745811 747410 747895 749135 752149 754856 758439 759663 761071 774079 774160 785019 788438 789299 789313 802632 807938 810316 810843 812160 813660 814084 815291 816258 816549 817310 817623 817660 817683 817816 817900 818083 818232 819047 819698 820079 821178 821628 821861 821928 821976 822178 822182 822718 824355 825037 825682 826097 826734 827465 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaved young"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бритая young"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бритая young"
]
|
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.