Query Metrics
7
Database Queries
7
Different statements
189.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.28 ms (89.15%) |
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 391890 406652 415691 432786 435737 459470 469590 480067 488359 521953 521980 523983 525062 530350 530937 536157 539328 540127 540901 541795 541944 547252 549276 549900 549917 549927 551881 554209 554735 562054 566902 578391 579075 579933 581994 584355 584789 588267 589331 601404 604099 608047 614455 628358 635720 636172 641298 642789 649363 649484 649840 649913 653691 661353 662480 663711 668419 668421 669896 671411 672354 672357 672369 672421 676215 676760 679280 690441 697682 697934 698207 699655 700906 701321 702350 707278 707973 708010 711102 714602 716582 721913 725782 734224 735179 744135 751381 751390 751422 752477 759132 759241 762517 768293 772836 776610 782745 784102 784104 785454 785885 786467 788451 789341 791308 791581 795984 798710 798745 798925 801649 811761 811902 813114 817437 819083 823775 825918 ] |
||||||||||||||||||||||||||||||
|
11.51 ms (6.06%) |
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 672357 782745 521953 751381 791308 828204 785885 391890 672354 671411 672369 584355 406652 744135 525062 672421 784102 823775 701321 649840 676215 699655 668421 530937 721913 798710 759241 702350 690441 578391 791581 549900 554209 601404 540901 588267 521980 523983 772836 551881 539328 649484 669896 707973 716582 768293 825918 579075 668419 549917 734224 819083 541944 714602 628358 811761 735179 432786 480067 676760 435737 415691 459470 776610 759132 635720 547252 549276 789341 661353 608047 784104 785454 711102 813114 725782 751390 604099 786467 581994 469590 817437 530350 536157 584789 579933 697682 642789 698207 801649 488359 752477 823117 540127 554735 566902 549927 653691 663711 641298 636172 798745 788451 798925 762517 649913 700906 697934 708010 541795 649363 679280 707278 589331 811902 562054 662480 614455 751422 795984 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.35%) |
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 391890 406652 415691 432786 435737 459470 469590 480067 488359 521953 521980 523983 525062 530350 530937 536157 539328 540127 540901 541795 541944 547252 549276 549900 549917 549927 551881 554209 554735 562054 566902 578391 579075 579933 581994 584355 584789 588267 589331 601404 604099 608047 614455 628358 635720 636172 641298 642789 649363 649484 649840 649913 653691 661353 662480 663711 668419 668421 669896 671411 672354 672357 672369 672421 676215 676760 679280 690441 697682 697934 698207 699655 700906 701321 702350 707278 707973 708010 711102 714602 716582 721913 725782 734224 735179 744135 751381 751390 751422 752477 759132 759241 762517 768293 772836 776610 782745 784102 784104 785454 785885 786467 788451 789341 791308 791581 795984 798710 798745 798925 801649 811761 811902 813114 817437 819083 823775 825918 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower public woman"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower на woman улиц"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower на woman улиц"
]
|
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.