Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.71 ms
(58.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трусик нижн бел white"
]
131.73 ms
(35.18%)
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
  6690
  383285
  395541
  400005
  415105
  419214
  430495
  431471
  437294
  437309
  445874
  449206
  449231
  450587
  452183
  452563
  456556
  457633
  459539
  460872
  461710
  462258
  463581
  464246
  467690
  467805
  474789
  479253
  480607
  481573
  483021
  484153
  484226
  484723
  485391
  485510
  489964
  490185
  491347
  491904
  492551
  493277
  493968
  494013
  499330
  499969
  500069
  504117
  504270
  504823
  505877
  505933
  507012
  507329
  507771
  509391
  509819
  510219
  511955
  513725
  513923
  514151
  514203
  514417
  514422
  514873
  515651
  516786
  517978
  518041
  518174
  518548
  518824
  518956
  520222
  521082
  521664
  523130
  524684
  525565
  526060
  526396
  526600
  529096
  529549
  533188
  534484
  534615
  535258
  535636
  535893
  536153
  536367
  537102
  537166
  539613
  543077
  544172
  546428
  552522
  576863
  641488
  777304
  788706
  799717
  815236
  815496
  815519
  819188
  821100
  821156
  821410
  821991
  822180
  822551
  822933
  823083
  823528
  828250
  828569
]
16.50 ms
(4.41%)
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
  452563
  415105
  516786
  518824
  521664
  493968
  526600
  504823
  507771
  490185
  514151
  523130
  431471
  430495
  437309
  445874
  449231
  459539
  460872
  484723
  449206
  461710
  462258
  452183
  457633
  509391
  514873
  507329
  510219
  464246
  467690
  463581
  467805
  479253
  437294
  480607
  481573
  450587
  456556
  499969
  509819
  513725
  515651
  517978
  518548
  526396
  484226
  507012
  511955
  514417
  518041
  518174
  524684
  525565
  491347
  493277
  514422
  526060
  491904
  492551
  494013
  500069
  504270
  505877
  513923
  529096
  529549
  383285
  395541
  6690
  400005
  419214
  815236
  822551
  821410
  821991
  822933
  815496
  823083
  815519
  819188
  821100
  821156
  822180
  823528
  828250
  828569
  483021
  485391
  484153
  489964
  504117
  521082
  534484
  535636
  539613
  520222
  535258
  535893
  536153
  536367
  505933
  518956
  534615
  537102
  499330
  514203
  533188
  537166
  474789
  485510
  546428
  552522
  543077
  544172
  576863
  641488
  788706
  799717
  777304
]
3.20 ms
(0.86%)
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
  6690
  383285
  395541
  400005
  415105
  419214
  430495
  431471
  437294
  437309
  445874
  449206
  449231
  450587
  452183
  452563
  456556
  457633
  459539
  460872
  461710
  462258
  463581
  464246
  467690
  467805
  474789
  479253
  480607
  481573
  483021
  484153
  484226
  484723
  485391
  485510
  489964
  490185
  491347
  491904
  492551
  493277
  493968
  494013
  499330
  499969
  500069
  504117
  504270
  504823
  505877
  505933
  507012
  507329
  507771
  509391
  509819
  510219
  511955
  513725
  513923
  514151
  514203
  514417
  514422
  514873
  515651
  516786
  517978
  518041
  518174
  518548
  518824
  518956
  520222
  521082
  521664
  523130
  524684
  525565
  526060
  526396
  526600
  529096
  529549
  533188
  534484
  534615
  535258
  535636
  535893
  536153
  536367
  537102
  537166
  539613
  543077
  544172
  546428
  552522
  576863
  641488
  777304
  788706
  799717
  815236
  815496
  815519
  819188
  821100
  821156
  821410
  821991
  822180
  822551
  822933
  823083
  823528
  828250
  828569
]
2.04 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "panties white"
]
1.78 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трусик нижн бел white"
]
1.48 ms
(0.40%)
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.