Query Metrics
7
Database Queries
7
Different statements
261.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
242.24 ms (92.63%) |
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 129246 392165 398436 400563 408532 410328 468914 469503 480552 487872 488848 506571 514702 516061 520472 528880 530664 541184 541565 541996 542443 547941 549951 552861 554704 554706 554709 554734 560342 564860 566737 568612 589374 592741 599763 606212 611541 621004 625597 632224 633052 633563 633664 643668 644857 647126 650692 661347 667820 669896 680612 680954 681234 690446 691231 691847 692436 694704 705736 706642 709855 710042 718717 733983 734261 735235 736031 736510 740238 740761 741582 744034 744568 747535 751377 754885 755737 760932 761069 764879 764993 768669 773275 773584 778186 778925 780742 780884 784050 785562 788141 789033 789650 791579 792990 793019 797826 798746 799010 802816 803156 804418 804881 809972 811987 812230 812238 812669 814166 817788 820475 821140 823157 825538 828046 828065 828098 828402 ] |
||||||||||||||||||||||||||||||
|
9.68 ms (3.70%) |
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 811987 468914 827995 789033 514702 480552 554734 778186 773584 764993 828402 410328 516061 520472 541996 554706 541184 681234 691231 705736 661347 647126 667820 680954 692436 632224 621004 784050 747535 773275 788141 791579 744034 754885 768669 761069 785562 803156 554704 408532 820475 469503 552861 694704 625597 589374 792990 802816 804881 812669 780742 755737 741582 764879 809972 599763 760932 690446 129246 392165 400563 822935 823157 814166 817788 821140 828065 825538 530664 542443 541565 568612 566737 718717 547941 554709 611541 592741 789650 798746 804418 734261 736031 740761 797826 812230 812238 733983 736510 740238 744568 735235 751377 633563 706642 709855 780884 799010 398436 778925 644857 680612 710042 669896 606212 633664 633052 793019 643668 828046 828098 549951 691847 564860 487872 488848 506571 528880 560342 650692 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (0.95%) |
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 129246 392165 398436 400563 408532 410328 468914 469503 480552 487872 488848 506571 514702 516061 520472 528880 530664 541184 541565 541996 542443 547941 549951 552861 554704 554706 554709 554734 560342 564860 566737 568612 589374 592741 599763 606212 611541 621004 625597 632224 633052 633563 633664 643668 644857 647126 650692 661347 667820 669896 680612 680954 681234 690446 691231 691847 692436 694704 705736 706642 709855 710042 718717 733983 734261 735235 736031 736510 740238 740761 741582 744034 744568 747535 751377 754885 755737 760932 761069 764879 764993 768669 773275 773584 778186 778925 780742 780884 784050 785562 788141 789033 789650 791579 792990 793019 797826 798746 799010 802816 803156 804418 804881 809972 811987 812230 812238 812669 814166 817788 820475 821140 823157 825538 828046 828065 828098 828402 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц пов"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц пов"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public pov"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.63%) |
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.