Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.99 ms
(82.03%)
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
  7092
  152544
  162000
  187704
  187843
  238125
  265654
  266061
  282038
  289778
  302771
  310672
  340567
  365908
  389623
  390629
  391519
  393855
  396941
  396957
  401000
  403806
  423433
  424124
  424436
  424441
  425999
  426567
  427086
  428102
  433888
  437988
  440569
  441644
  443135
  443784
  443808
  448580
  449296
  451500
  451528
  451787
  452081
  452240
  454175
  454223
  454237
  454478
  457010
  461025
  463825
  466042
  466226
  466904
  470201
  470207
  470296
  470309
  472889
  475080
  476961
  481188
  481957
  482534
  483607
  486015
  489169
  491771
  491964
  491975
  498019
  502029
  506047
  507487
  508246
  512347
  515262
  517687
  519582
  522616
  524177
  526213
  528507
  528528
  533741
  549246
  550232
  551111
  563020
  563165
  564363
  564791
  593418
  603264
  605296
  646105
  663443
  665270
  667209
  669742
  709623
  715573
  716078
  741143
  745806
  748227
  748244
  748463
  769494
  781796
  789215
  794828
  797271
  797275
  797685
  803008
  810606
  826278
  826480
  828449
]
14.89 ms
(10.18%)
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
  466904
  665270
  781796
  794828
  507487
  187843
  266061
  472889
  391519
  441644
  289778
  481957
  741143
  491975
  826480
  396957
  549246
  152544
  826278
  457010
  748463
  476961
  454223
  427086
  498019
  470309
  433888
  667209
  593418
  466042
  483607
  451500
  491771
  563020
  451787
  426567
  451528
  443808
  486015
  466226
  443784
  454478
  515262
  238125
  797275
  424124
  810606
  389623
  491964
  828449
  423433
  463825
  470201
  424441
  425999
  470207
  502029
  7092
  522616
  443135
  396941
  519582
  424436
  481188
  506047
  470296
  508246
  365908
  340567
  646105
  461025
  265654
  437988
  564791
  390629
  428102
  452240
  709623
  715573
  789215
  769494
  663443
  669742
  187704
  440569
  162000
  716078
  393855
  401000
  449296
  454175
  403806
  452081
  797685
  454237
  282038
  482534
  489169
  533741
  517687
  564363
  512347
  448580
  524177
  605296
  551111
  748227
  528507
  528528
  310672
  745806
  302771
  803008
  797271
  475080
  526213
  563165
  550232
  603264
  748244
]
2.80 ms
(1.91%)
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
  7092
  152544
  162000
  187704
  187843
  238125
  265654
  266061
  282038
  289778
  302771
  310672
  340567
  365908
  389623
  390629
  391519
  393855
  396941
  396957
  401000
  403806
  423433
  424124
  424436
  424441
  425999
  426567
  427086
  428102
  433888
  437988
  440569
  441644
  443135
  443784
  443808
  448580
  449296
  451500
  451528
  451787
  452081
  452240
  454175
  454223
  454237
  454478
  457010
  461025
  463825
  466042
  466226
  466904
  470201
  470207
  470296
  470309
  472889
  475080
  476961
  481188
  481957
  482534
  483607
  486015
  489169
  491771
  491964
  491975
  498019
  502029
  506047
  507487
  508246
  512347
  515262
  517687
  519582
  522616
  524177
  526213
  528507
  528528
  533741
  549246
  550232
  551111
  563020
  563165
  564363
  564791
  593418
  603264
  605296
  646105
  663443
  665270
  667209
  669742
  709623
  715573
  716078
  741143
  745806
  748227
  748244
  748463
  769494
  781796
  789215
  794828
  797271
  797275
  797685
  803008
  810606
  826278
  826480
  828449
]
2.30 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная чулк нижн бел куннилингус оральн секс"
]
2.30 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "полные в чулках кунилингус"
]
2.08 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.32%)
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.