Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.95 ms
(85.98%)
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
  155175
  187443
  388750
  390802
  401058
  424847
  425379
  426297
  439307
  452253
  454283
  454382
  457631
  461658
  462138
  462712
  476320
  479838
  501992
  502765
  516626
  521139
  526096
  528966
  529583
  531850
  535331
  540234
  540816
  547228
  548010
  554037
  557606
  557650
  562603
  572774
  573347
  573386
  578752
  578770
  583390
  584280
  593227
  595161
  596919
  597051
  599829
  604806
  606400
  607263
  614114
  620047
  629575
  630254
  636666
  648503
  662049
  662061
  662842
  663151
  663158
  666988
  672825
  689775
  697242
  700468
  716568
  717520
  726154
  729366
  732223
  736047
  736887
  738481
  745128
  757483
  766511
  769158
  772709
  776007
  776031
  776041
  776776
  781825
  782825
  784110
  784792
  785857
  786662
  791014
  791025
  791507
  795413
  795979
  796793
  798429
  800473
  800697
  801825
  802222
  803835
  804417
  806527
  806822
  807206
  807579
  808725
  808796
  809005
  810076
  810781
  811097
  811234
  811679
  813215
  814168
  814403
  819237
  824303
]
14.29 ms
(7.73%)
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
  155175
  187443
  390802
  425379
  814403
  814168
  819237
  824303
  462712
  521139
  529583
  540234
  502765
  531850
  461658
  562603
  548010
  573347
  554037
  557650
  578752
  584280
  648503
  662049
  672825
  662061
  662842
  689775
  717520
  557606
  604806
  595161
  620047
  599829
  614114
  629575
  784792
  786662
  795979
  807579
  809005
  776041
  791507
  795413
  798429
  800697
  726154
  785857
  791014
  800473
  807147
  810076
  811679
  729366
  736887
  766511
  732223
  738481
  745128
  736047
  757483
  776007
  776776
  791025
  803835
  804417
  806527
  806822
  808725
  811234
  388750
  454283
  439307
  457631
  516626
  535331
  501992
  572774
  401058
  426297
  424847
  540816
  454382
  479838
  462138
  452253
  526096
  528966
  476320
  583390
  663158
  666988
  700468
  716568
  663151
  697242
  547228
  573386
  578770
  593227
  596919
  597051
  606400
  607263
  630254
  636666
  776031
  782825
  796793
  810781
  781825
  801825
  802222
  769158
  772709
  784110
  807206
  808796
  811097
  813215
]
4.09 ms
(2.22%)
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
  155175
  187443
  388750
  390802
  401058
  424847
  425379
  426297
  439307
  452253
  454283
  454382
  457631
  461658
  462138
  462712
  476320
  479838
  501992
  502765
  516626
  521139
  526096
  528966
  529583
  531850
  535331
  540234
  540816
  547228
  548010
  554037
  557606
  557650
  562603
  572774
  573347
  573386
  578752
  578770
  583390
  584280
  593227
  595161
  596919
  597051
  599829
  604806
  606400
  607263
  614114
  620047
  629575
  630254
  636666
  648503
  662049
  662061
  662842
  663151
  663158
  666988
  672825
  689775
  697242
  700468
  716568
  717520
  726154
  729366
  732223
  736047
  736887
  738481
  745128
  757483
  766511
  769158
  772709
  776007
  776031
  776041
  776776
  781825
  782825
  784110
  784792
  785857
  786662
  791014
  791025
  791507
  795413
  795979
  796793
  798429
  800473
  800697
  801825
  802222
  803835
  804417
  806527
  806822
  807206
  807579
  808725
  808796
  809005
  810076
  810781
  811097
  811234
  811679
  813215
  814168
  814403
  819237
  824303
]
2.12 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "колготк соло"
]
1.90 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tights solo"
]
1.86 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.