Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.34 ms
(54.92%)
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
  33443
  39478
  50265
  118165
  195676
  198191
  214602
  223442
  381844
  383208
  384543
  384562
  386344
  386707
  389475
  389611
  392817
  396746
  396941
  396947
  397739
  398097
  402084
  402626
  403134
  404112
  407796
  414043
  414711
  415896
  416100
  416607
  429300
  443125
  447124
  454800
  457478
  460338
  466477
  473743
  474126
  476184
  481952
  501239
  502795
  503843
  507824
  529321
  533644
  544850
  578323
  583191
  588748
  594208
  600304
  610029
  610075
  622588
  627225
  634734
  634745
  640528
  648649
  653028
  670460
  671056
  685814
  694195
  694556
  705507
  709593
  712882
  716254
  718987
  728142
  736164
  738487
  739948
  741737
  744795
  744921
  746191
  749248
  752649
  758332
  770117
  771588
  772104
  783446
  788109
  790381
  790625
  792600
  793007
  794218
  794225
  794228
  794244
  794256
  794257
  796880
  800409
  801639
  801814
  802902
  803009
  804137
  807917
  811926
  812409
  817126
  818923
  821964
  822910
  825120
  825771
  826692
  827653
  827828
  827969
]
151.91 ms
(39.29%)
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
  33443
  39478
  50265
  118165
  195676
  198191
  214602
  223442
  381844
  383208
  384543
  384562
  386344
  386707
  389475
  389611
  392817
  396746
  396941
  396947
  397739
  398097
  402084
  402626
  403134
  404112
  407796
  414043
  414711
  415896
  416100
  416607
  429300
  443125
  447124
  454800
  457478
  460338
  466477
  473743
  474126
  476184
  481952
  501239
  502795
  503843
  507824
  529321
  533644
  544850
  578323
  583191
  588748
  594208
  600304
  610029
  610075
  622588
  627225
  634734
  634745
  640528
  648649
  653028
  670460
  671056
  685814
  694195
  694556
  705507
  709593
  712882
  716254
  718987
  728142
  736164
  738487
  739948
  741737
  744795
  744921
  746191
  749248
  752649
  758332
  770117
  771588
  772104
  783446
  788109
  790381
  790625
  792600
  793007
  794218
  794225
  794228
  794244
  794256
  794257
  796880
  800409
  801639
  801814
  802902
  803009
  804137
  807917
  811926
  812409
  817126
  818923
  821964
  822910
  825120
  825771
  826692
  827653
  827828
  827969
]
14.26 ms
(3.69%)
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
  33443
  826692
  792600
  804137
  811926
  794244
  803009
  794256
  802902
  770117
  403134
  685814
  416607
  416100
  454800
  443125
  507824
  800409
  389611
  827969
  671056
  634734
  384543
  749248
  198191
  386707
  827828
  414043
  214602
  783446
  812409
  118165
  223442
  817126
  634745
  600304
  588748
  752649
  705507
  796880
  384562
  392817
  397739
  402626
  396746
  481952
  788109
  396941
  473743
  594208
  627225
  709593
  807917
  407796
  610075
  610029
  736164
  640528
  712882
  716254
  389475
  533644
  195676
  825771
  827653
  648649
  653028
  718987
  794218
  794257
  741737
  801814
  758332
  794225
  794228
  39478
  466477
  501239
  578323
  583191
  728142
  381844
  402084
  818923
  821964
  822910
  825120
  670460
  694556
  746191
  396947
  801639
  771588
  429300
  474126
  476184
  460338
  447124
  415896
  502795
  622588
  793007
  738487
  772104
  744795
  383208
  457478
  790381
  694195
  386344
  398097
  414711
  529321
  404112
  503843
  544850
  790625
  739948
  744921
  50265
]
2.34 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор натуральные сиськ без силикон"
]
1.97 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жёсткое натуральные сиськи"
]
1.95 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(0.49%)
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.