Query Metrics
7
Database Queries
7
Different statements
185.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.94 ms (86.85%) |
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 469503 488848 506571 514702 528880 530664 541565 542443 545798 547941 549951 552861 554709 560342 566737 568612 579127 589083 592741 599763 601948 606212 611541 614455 623710 625597 625750 633052 633563 633664 634289 634362 638947 644857 644974 650692 662480 666476 669896 669903 680612 694704 695652 695980 695997 696009 696061 697917 701604 706642 707812 708297 709517 709855 710042 718717 733983 734261 734386 734429 735235 736031 736510 740238 740761 744034 744568 746098 751377 751422 752765 754885 760932 764993 768042 768669 773584 778186 780884 785562 788141 789650 791579 797826 798746 798857 799010 800663 803156 804418 809767 812230 812238 814166 817403 817519 817788 819438 819452 820475 820504 820564 821037 821140 821143 821168 821564 823157 825538 828046 828047 828065 828098 828243 828376 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (7.94%) |
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 788141 791579 744034 754885 768669 785562 803156 514702 129246 817403 820504 820564 821143 822935 821140 740761 733983 599763 392165 400563 817519 821168 821564 819438 819452 821037 823157 814166 817788 828065 828243 825538 530664 542443 541565 568612 566737 718717 547941 554709 611541 592741 634289 789650 798746 798857 804418 734261 736031 797826 812230 812238 736510 740238 744568 735235 751377 633563 706642 709855 780884 799010 800663 398436 760932 606212 633664 625750 633052 644857 680612 710042 669896 768042 506571 528880 560342 650692 828046 828098 828376 828047 549951 488848 638947 601948 545798 662480 614455 634362 589083 734429 701604 579127 669903 778186 734386 773584 809767 764993 752765 746098 751422 707812 644974 820475 469503 552861 695652 695980 695997 696009 696061 709517 666476 694704 697917 708297 623710 625597 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.48%) |
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 469503 488848 506571 514702 528880 530664 541565 542443 545798 547941 549951 552861 554709 560342 566737 568612 579127 589083 592741 599763 601948 606212 611541 614455 623710 625597 625750 633052 633563 633664 634289 634362 638947 644857 644974 650692 662480 666476 669896 669903 680612 694704 695652 695980 695997 696009 696061 697917 701604 706642 707812 708297 709517 709855 710042 718717 733983 734261 734386 734429 735235 736031 736510 740238 740761 744034 744568 746098 751377 751422 752765 754885 760932 764993 768042 768669 773584 778186 780884 785562 788141 789650 791579 797826 798746 798857 799010 800663 803156 804418 809767 812230 812238 814166 817403 817519 817788 819438 819452 820475 820504 820564 821037 821140 821143 821168 821564 823157 825538 828046 828047 828065 828098 828243 828376 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public cock"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на cock улиц"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на cock улиц"
]
|
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.