Query Metrics

7 Database Queries
7 Different statements
432.10 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
410.87 ms
(95.09%)
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
  390713
  391735
  392225
  425540
  432804
  441541
  461870
  462849
  475332
  498642
  530394
  531285
  531286
  531564
  534044
  538899
  543768
  544809
  545185
  549121
  564296
  564549
  568013
  587984
  602034
  628619
  630096
  633552
  639037
  639355
  643513
  643612
  655241
  656631
  661967
  662171
  663738
  668099
  669294
  683316
  691402
  694831
  697456
  697600
  697801
  711328
  715761
  715877
  719968
  720067
  720688
  723197
  723630
  724057
  725156
  727280
  728321
  728735
  729362
  736208
  738103
  740248
  742713
  742852
  743934
  746492
  747095
  750125
  750126
  750129
  756089
  761077
  762273
  762982
  765064
  765066
  765334
  766604
  767044
  767061
  767212
  767243
  768760
  773312
  776956
  781334
  781564
  781587
  783197
  784622
  787714
  788170
  788435
  788782
  791092
  791624
  793668
  794859
  796117
  796131
  800380
  800392
  802056
  804868
  816597
  817336
  820521
  820946
  821265
  823041
  826263
  826572
  826731
  827275
  827317
  827428
  827492
  827531
  827609
  827967
]
11.53 ms
(2.67%)
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
  633552
  643513
  784622
  788435
  781334
  746492
  750129
  728735
  765066
  767044
  788782
  804868
  656631
  425540
  823041
  826572
  817336
  820521
  827275
  827428
  827492
  827531
  827609
  564549
  545185
  694831
  564296
  587984
  776956
  800392
  724057
  747095
  765064
  766604
  738103
  750126
  762273
  773312
  720688
  791624
  802056
  391735
  390713
  461870
  462849
  392225
  826731
  538899
  544809
  767212
  827967
  729362
  767243
  727280
  432804
  568013
  669294
  697456
  715761
  719968
  683316
  720067
  630096
  628619
  639037
  643612
  781587
  794859
  796131
  725156
  742852
  762982
  736208
  767061
  742713
  765334
  750125
  602034
  723197
  783197
  796117
  661967
  711328
  655241
  662171
  663738
  668099
  781564
  791092
  800380
  728321
  740248
  761077
  768760
  756089
  715877
  788170
  827317
  816597
  826263
  697801
  691402
  549121
  639355
  787714
  743934
  793668
  697600
  441541
  820946
  723630
  821265
  475332
  498642
  531564
  530394
  531286
  534044
  531285
  543768
]
2.92 ms
(0.68%)
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
  390713
  391735
  392225
  425540
  432804
  441541
  461870
  462849
  475332
  498642
  530394
  531285
  531286
  531564
  534044
  538899
  543768
  544809
  545185
  549121
  564296
  564549
  568013
  587984
  602034
  628619
  630096
  633552
  639037
  639355
  643513
  643612
  655241
  656631
  661967
  662171
  663738
  668099
  669294
  683316
  691402
  694831
  697456
  697600
  697801
  711328
  715761
  715877
  719968
  720067
  720688
  723197
  723630
  724057
  725156
  727280
  728321
  728735
  729362
  736208
  738103
  740248
  742713
  742852
  743934
  746492
  747095
  750125
  750126
  750129
  756089
  761077
  762273
  762982
  765064
  765066
  765334
  766604
  767044
  767061
  767212
  767243
  768760
  773312
  776956
  781334
  781564
  781587
  783197
  784622
  787714
  788170
  788435
  788782
  791092
  791624
  793668
  794859
  796117
  796131
  800380
  800392
  802056
  804868
  816597
  817336
  820521
  820946
  821265
  823041
  826263
  826572
  826731
  827275
  827317
  827428
  827492
  827531
  827609
  827967
]
1.94 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "close anal"
]
1.68 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "close анал"
]
1.49 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "close анал"
]

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.