Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.87 ms
(84.38%)
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
  162043
  170215
  188028
  233733
  276441
  370715
  381752
  382003
  383377
  385147
  386142
  387359
  387556
  388761
  389147
  389355
  389611
  390644
  390728
  390761
  391875
  395134
  395137
  395861
  395914
  395955
  396034
  397366
  399639
  401532
  401921
  402095
  402137
  402960
  407339
  408947
  409077
  409317
  409904
  409929
  411419
  411629
  411864
  413068
  416886
  419629
  420151
  421006
  430240
  443725
  452376
  456128
  460151
  465338
  467497
  468467
  470214
  470639
  472628
  476180
  476280
  476319
  476327
  477077
  480305
  482665
  484635
  488377
  489388
  505252
  513728
  519141
  522614
  523367
  546255
  546455
  555092
  555123
  557171
  558914
  573726
  584214
  599909
  620246
  620255
  644661
  655153
  664495
  664954
  665317
  665379
  665448
  667195
  667474
  667555
  667878
  668161
  668174
  670471
  714175
  721463
  724084
  730072
  734699
  748479
  754436
  756223
  758417
  759980
  766777
  773346
  775989
  784297
  787298
  796920
  801093
  801173
  813578
  817799
  819018
]
17.11 ms
(10.32%)
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
  396034
  385147
  668161
  387556
  420151
  419629
  730072
  775989
  387359
  443725
  465338
  519141
  381752
  546255
  411864
  452376
  555092
  724084
  748479
  162043
  409077
  664495
  476327
  276441
  599909
  734699
  773346
  402960
  756223
  480305
  413068
  819018
  817799
  664954
  170215
  395955
  401921
  644661
  714175
  399639
  476319
  402095
  395134
  477077
  787298
  233733
  796920
  430240
  555123
  467497
  389611
  468467
  409929
  470214
  620255
  395914
  411629
  382003
  665379
  411419
  546455
  408947
  409317
  522614
  505252
  421006
  409904
  370715
  476180
  766777
  386142
  395137
  472628
  620246
  407339
  557171
  584214
  188028
  665317
  665448
  667474
  667878
  390644
  484635
  395861
  668174
  513728
  489388
  655153
  758417
  784297
  416886
  523367
  558914
  667555
  401532
  391875
  456128
  573726
  402137
  754436
  389355
  670471
  397366
  383377
  813578
  460151
  801093
  488377
  667195
  759980
  801173
  470639
  721463
  390728
  390761
  388761
  476280
  389147
  482665
]
2.51 ms
(1.51%)
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
  162043
  170215
  188028
  233733
  276441
  370715
  381752
  382003
  383377
  385147
  386142
  387359
  387556
  388761
  389147
  389355
  389611
  390644
  390728
  390761
  391875
  395134
  395137
  395861
  395914
  395955
  396034
  397366
  399639
  401532
  401921
  402095
  402137
  402960
  407339
  408947
  409077
  409317
  409904
  409929
  411419
  411629
  411864
  413068
  416886
  419629
  420151
  421006
  430240
  443725
  452376
  456128
  460151
  465338
  467497
  468467
  470214
  470639
  472628
  476180
  476280
  476319
  476327
  477077
  480305
  482665
  484635
  488377
  489388
  505252
  513728
  519141
  522614
  523367
  546255
  546455
  555092
  555123
  557171
  558914
  573726
  584214
  599909
  620246
  620255
  644661
  655153
  664495
  664954
  665317
  665379
  665448
  667195
  667474
  667555
  667878
  668161
  668174
  670471
  714175
  721463
  724084
  730072
  734699
  748479
  754436
  756223
  758417
  759980
  766777
  773346
  775989
  784297
  787298
  796920
  801093
  801173
  813578
  817799
  819018
]
1.76 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая mature минет оральн секс"
]
1.71 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde mature blowjob"
]
1.42 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая mature минет оральн секс"
]

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.