Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.07 ms
(82.43%)
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
  287436
  383208
  398094
  406935
  414064
  418112
  421052
  431960
  434352
  439322
  441095
  442454
  443092
  447150
  448263
  450020
  455365
  457217
  459563
  460540
  467195
  467623
  471105
  475296
  475508
  481952
  485297
  487008
  491299
  492000
  493122
  494484
  498294
  503924
  508566
  511372
  511413
  518614
  525399
  527884
  531103
  533461
  540032
  541484
  546987
  552595
  555056
  556483
  567604
  569309
  579519
  580139
  580190
  584806
  595016
  596240
  596864
  599187
  604351
  619230
  635224
  635993
  642032
  647307
  651737
  654686
  661424
  665207
  692728
  692743
  697594
  699627
  700682
  702616
  709128
  710875
  721103
  723618
  724330
  726315
  734274
  735132
  737052
  740255
  744027
  746777
  747468
  750390
  750907
  752990
  753785
  755693
  756840
  758030
  758787
  760601
  773921
  774884
  777791
  782051
  783568
  784662
  791020
  791520
  796863
  802899
  803557
  804081
  809712
  811252
  812195
  818301
  820688
  821075
  821634
  824475
  824863
  824892
  827619
]
19.03 ms
(11.36%)
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
  459563
  450020
  455365
  398094
  820688
  821075
  821634
  824863
  824475
  827619
  818301
  654686
  651737
  692728
  702616
  710875
  774884
  782051
  777791
  783568
  744027
  750390
  752990
  755693
  791520
  740255
  760601
  734274
  746777
  773921
  796863
  811252
  812195
  556483
  635224
  406935
  457217
  467623
  447150
  467195
  546987
  569309
  580139
  665207
  580190
  596240
  604351
  475508
  511372
  533461
  518614
  647307
  642032
  493122
  418112
  441095
  414064
  439322
  723618
  448263
  471105
  475296
  527884
  531103
  540032
  508566
  487008
  492000
  555056
  552595
  541484
  579519
  699627
  721103
  692743
  661424
  567604
  584806
  595016
  635993
  599187
  596864
  796642
  803557
  737052
  802899
  747468
  750907
  726315
  724330
  735132
  756840
  758787
  709128
  784662
  791020
  421052
  434352
  443092
  460540
  431960
  481952
  442454
  491299
  498294
  511413
  485297
  494484
  525399
  824892
  503924
  697594
  700682
  619230
  809712
  804081
  758030
  753785
  383208
  287436
]
2.49 ms
(1.49%)
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
  287436
  383208
  398094
  406935
  414064
  418112
  421052
  431960
  434352
  439322
  441095
  442454
  443092
  447150
  448263
  450020
  455365
  457217
  459563
  460540
  467195
  467623
  471105
  475296
  475508
  481952
  485297
  487008
  491299
  492000
  493122
  494484
  498294
  503924
  508566
  511372
  511413
  518614
  525399
  527884
  531103
  533461
  540032
  541484
  546987
  552595
  555056
  556483
  567604
  569309
  579519
  580139
  580190
  584806
  595016
  596240
  596864
  599187
  604351
  619230
  635224
  635993
  642032
  647307
  651737
  654686
  661424
  665207
  692728
  692743
  697594
  699627
  700682
  702616
  709128
  710875
  721103
  723618
  724330
  726315
  734274
  735132
  737052
  740255
  744027
  746777
  747468
  750390
  750907
  752990
  753785
  755693
  756840
  758030
  758787
  760601
  773921
  774884
  777791
  782051
  783568
  784662
  791020
  791520
  796863
  802899
  803557
  804081
  809712
  811252
  812195
  818301
  820688
  821075
  821634
  824475
  824863
  824892
  827619
]
2.25 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд pussy"
]
2.03 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo pussy"
]
1.98 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд pussy"
]
1.66 ms
(0.99%)
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.