Query Metrics
7
Database Queries
7
Different statements
186.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.44 ms (82.82%) |
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 388401 389980 398307 418808 443120 446873 447686 451741 459437 460770 473914 473931 477734 478489 484434 488700 491736 496087 511739 512295 526463 527630 535465 539278 543548 545711 552145 552176 552228 556911 561730 561813 563647 565162 565274 565953 566031 573577 573839 574502 574585 574841 575131 575162 575484 576407 576412 580236 587858 590821 591349 591841 594381 595359 596459 596583 597233 597566 597828 598554 598796 600167 603584 623203 629029 635742 640806 644674 649166 652591 652605 652882 655096 656684 659412 659836 660562 661270 662833 672677 675037 678897 699026 699587 700176 702432 703280 712731 714449 715652 718934 721264 723487 724727 727824 730678 731893 735957 742144 743157 743221 747576 751750 753031 753307 753339 753395 753418 753854 754182 760919 785772 793893 798784 810280 810841 819198 827324 828324 828626 ] |
||||||||||||||||||||||||||||||
|
22.46 ms (12.05%) |
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 699026 731893 512295 623203 828324 702432 828626 659836 721264 723487 649166 652591 655096 656684 660562 661270 675037 678897 712731 573839 594381 597828 629029 810280 810841 724727 730678 751750 743157 715652 798784 662833 819198 652605 652882 718934 700176 703280 699587 591841 598796 793893 785772 747576 753031 753307 735957 742144 753854 754182 760919 753339 753395 753418 727824 388401 539278 556911 561813 565953 566031 574841 561730 565274 575131 575162 580236 659412 587858 603584 597566 590821 591349 596583 597233 600167 595359 640806 644674 714449 576412 565162 398307 451741 446873 460770 535465 543548 576407 545711 563647 574502 574585 596459 598554 473914 459437 477734 478489 473931 418808 447686 443120 511739 484434 527630 488700 496087 526463 491736 672677 827324 635742 743221 575484 389980 552228 552176 573577 552145 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.81%) |
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 388401 389980 398307 418808 443120 446873 447686 451741 459437 460770 473914 473931 477734 478489 484434 488700 491736 496087 511739 512295 526463 527630 535465 539278 543548 545711 552145 552176 552228 556911 561730 561813 563647 565162 565274 565953 566031 573577 573839 574502 574585 574841 575131 575162 575484 576407 576412 580236 587858 590821 591349 591841 594381 595359 596459 596583 597233 597566 597828 598554 598796 600167 603584 623203 629029 635742 640806 644674 649166 652591 652605 652882 655096 656684 659412 659836 660562 661270 662833 672677 675037 678897 699026 699587 700176 702432 703280 712731 714449 715652 718934 721264 723487 724727 727824 730678 731893 735957 742144 743157 743221 747576 751750 753031 753307 753339 753395 753418 753854 754182 760919 785772 793893 798784 810280 810841 819198 827324 828324 828626 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen small"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen маленькая"
]
|
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.