Query Metrics
7
Database Queries
7
Different statements
215.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.42 ms (87.54%) |
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 382236 397424 398733 400696 410905 460395 486044 493314 505591 527602 529841 530092 530308 530638 530651 532286 532402 533700 533712 534862 535371 536082 545798 547070 547120 547445 547763 563408 574656 579127 579523 589083 589329 595029 614455 616276 618967 623710 626831 634362 634369 634712 638947 641479 644974 660115 661004 662480 666476 669903 682956 683766 690410 690424 695652 695980 695997 696009 696061 697079 697917 701604 707812 708297 709517 721064 724318 726049 728188 734386 734429 736507 736924 740148 746098 747634 750686 751242 751408 751422 752145 752765 754644 758155 758942 761483 765878 767495 771990 780509 780649 782745 783750 790433 793940 798989 804877 809767 813612 813734 813802 818742 819455 820515 821438 821571 822274 823343 824239 825147 828036 828050 828125 828149 828338 828377 828414 828425 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (7.39%) |
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 638947 818742 823343 819455 820515 821438 821571 822274 828425 690424 682956 589329 782835 798989 780509 771990 765878 828338 579127 545798 669903 662480 614455 634362 589083 734386 734429 809767 752765 746098 751422 701604 707812 547120 828050 828036 397424 644974 813612 813802 486044 530638 579523 547763 547070 574656 695652 695980 695997 696009 696061 709517 666476 697917 708297 563408 623710 641479 780649 736924 783750 728188 747634 751408 758155 724318 752145 736507 754644 761483 726049 634712 697079 721064 793940 410905 790433 400696 616276 661004 595029 825147 828377 493314 532286 460395 660115 618967 804877 505591 534862 750686 530092 626831 740148 527602 767495 824239 828125 828149 828414 828624 530308 690410 683766 634369 782745 751242 758942 382236 398733 813734 529841 533712 536082 530651 533700 535371 532402 547445 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.61%) |
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 382236 397424 398733 400696 410905 460395 486044 493314 505591 527602 529841 530092 530308 530638 530651 532286 532402 533700 533712 534862 535371 536082 545798 547070 547120 547445 547763 563408 574656 579127 579523 589083 589329 595029 614455 616276 618967 623710 626831 634362 634369 634712 638947 641479 644974 660115 661004 662480 666476 669903 682956 683766 690410 690424 695652 695980 695997 696009 696061 697079 697917 701604 707812 708297 709517 721064 724318 726049 728188 734386 734429 736507 736924 740148 746098 747634 750686 751242 751408 751422 752145 752765 754644 758155 758942 761483 765878 767495 771990 780509 780649 782745 783750 790433 793940 798989 804877 809767 813612 813734 813802 818742 819455 820515 821438 821571 822274 823343 824239 825147 828036 828050 828125 828149 828338 828377 828414 828425 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц пов"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public pov"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц пов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.