Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.96 ms
(82.97%)
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
  96231
  116603
  210281
  395332
  397904
  401264
  402060
  405048
  408143
  409846
  414845
  417731
  424825
  427487
  434817
  440805
  450160
  450646
  451494
  454654
  458044
  459569
  460324
  461300
  469170
  470609
  472551
  489293
  491336
  504805
  524206
  527711
  536690
  551993
  556961
  557728
  558570
  559657
  560182
  561442
  563834
  564533
  565284
  577543
  580294
  580408
  592787
  593075
  606022
  606557
  614018
  618816
  623515
  625435
  647606
  652121
  654256
  657735
  669347
  673860
  674127
  679306
  685823
  686416
  688203
  691688
  693236
  695310
  697203
  697296
  704187
  704673
  705111
  706754
  709427
  713335
  719225
  720124
  721793
  721978
  723189
  724781
  725352
  734611
  735839
  743892
  744585
  745974
  748334
  749172
  757506
  757715
  760123
  761650
  763529
  763589
  768700
  770810
  780085
  781785
  784288
  784661
  787605
  789754
  793279
  794009
  795003
  795919
  797719
  799446
  800863
  801290
  802800
  806741
  810856
  813833
  819613
  820164
  820882
]
14.42 ms
(9.89%)
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
  810856
  819613
  459569
  454654
  686416
  688203
  743892
  760123
  408143
  524206
  210281
  551993
  556961
  409846
  414845
  489293
  763529
  647606
  536690
  580294
  577543
  704187
  679306
  625435
  793279
  802800
  458044
  424825
  561442
  654256
  691688
  558570
  593075
  745974
  763589
  806741
  504805
  674127
  395332
  401264
  673860
  781785
  780085
  440805
  461300
  713335
  697203
  606557
  770810
  720124
  820882
  697296
  784661
  761650
  735839
  405048
  427487
  813833
  559657
  563834
  669347
  723189
  695310
  693236
  560182
  592787
  606022
  614018
  618816
  799446
  749172
  787605
  724781
  768700
  706754
  794009
  797719
  800863
  417731
  469170
  527711
  491336
  652121
  734611
  744585
  721793
  795003
  757506
  96231
  402060
  460324
  565284
  450646
  397904
  820164
  564533
  557728
  721978
  704673
  705111
  719225
  657735
  709427
  580408
  623515
  795919
  801290
  789754
  725352
  772131
  784288
  748334
  757715
  116603
  450160
  685823
  470609
  451494
  434817
  472551
]
2.85 ms
(1.95%)
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
  96231
  116603
  210281
  395332
  397904
  401264
  402060
  405048
  408143
  409846
  414845
  417731
  424825
  427487
  434817
  440805
  450160
  450646
  451494
  454654
  458044
  459569
  460324
  461300
  469170
  470609
  472551
  489293
  491336
  504805
  524206
  527711
  536690
  551993
  556961
  557728
  558570
  559657
  560182
  561442
  563834
  564533
  565284
  577543
  580294
  580408
  592787
  593075
  606022
  606557
  614018
  618816
  623515
  625435
  647606
  652121
  654256
  657735
  669347
  673860
  674127
  679306
  685823
  686416
  688203
  691688
  693236
  695310
  697203
  697296
  704187
  704673
  705111
  706754
  709427
  713335
  719225
  720124
  721793
  721978
  723189
  724781
  725352
  734611
  735839
  743892
  744585
  745974
  748334
  749172
  757506
  757715
  760123
  761650
  763529
  763589
  768700
  770810
  780085
  781785
  784288
  784661
  787605
  789754
  793279
  794009
  795003
  795919
  797719
  799446
  800863
  801290
  802800
  806741
  810856
  813833
  819613
  820164
  820882
]
2.22 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real blowjob"
]
1.96 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real минет оральн секс"
]
1.59 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real минет оральн секс"
]

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.