Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.79 ms
(56.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск женскийрод"
]
135.26 ms
(36.27%)
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
  232945
  233426
  366031
  382907
  388696
  391913
  392605
  402719
  403131
  406091
  411389
  416214
  419352
  420877
  421182
  422488
  424224
  427091
  427112
  427207
  428885
  432209
  433855
  437079
  437522
  441996
  443720
  443958
  444142
  444241
  447567
  448227
  448275
  448915
  450021
  454073
  454205
  459449
  460004
  464547
  465803
  466237
  466285
  466397
  467876
  469216
  471674
  472107
  473793
  473990
  474082
  475020
  477980
  479036
  483306
  483405
  484178
  485953
  486327
  486705
  488171
  489049
  489195
  489329
  490157
  490824
  490952
  491433
  492644
  493275
  494391
  495446
  495554
  496202
  496958
  497641
  498116
  499388
  499420
  500120
  501983
  502724
  502864
  503749
  503896
  504055
  504267
  505866
  507416
  508476
  508871
  509150
  510673
  510794
  511151
  515710
  516302
  516670
  517883
  520090
  522655
  525455
  525456
  525772
  527346
  528280
  540724
  541420
  541817
  543823
  549765
  557998
  558013
  563612
  571391
  595367
  595477
  597073
  598727
  630541
]
17.23 ms
(4.62%)
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
  540724
  541420
  483306
  486327
  489195
  491433
  492644
  496202
  498116
  502864
  503749
  504267
  510794
  517883
  522655
  525455
  525772
  527346
  485953
  489049
  490157
  490824
  495446
  496958
  497641
  499388
  499420
  500120
  505866
  508476
  508871
  510673
  511151
  515710
  520090
  528280
  541817
  483405
  484178
  488171
  489329
  490952
  495554
  502724
  503896
  504055
  507416
  509150
  516302
  444241
  630541
  571391
  406091
  469216
  448227
  232945
  422488
  475020
  549765
  595477
  597073
  392605
  419352
  233426
  443720
  466237
  441996
  465803
  466397
  474082
  460004
  472107
  501983
  486705
  494391
  516670
  493275
  525456
  420877
  459449
  471674
  563612
  543823
  557998
  558013
  598727
  595367
  388696
  416214
  427207
  437079
  466285
  473990
  382907
  402719
  403131
  424224
  432209
  448915
  454073
  464547
  477980
  479036
  366031
  411389
  421182
  427091
  428885
  437522
  443958
  444142
  447567
  448275
  467876
  473793
  391913
  427112
  433855
  450021
  454205
]
3.05 ms
(0.82%)
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
  232945
  233426
  366031
  382907
  388696
  391913
  392605
  402719
  403131
  406091
  411389
  416214
  419352
  420877
  421182
  422488
  424224
  427091
  427112
  427207
  428885
  432209
  433855
  437079
  437522
  441996
  443720
  443958
  444142
  444241
  447567
  448227
  448275
  448915
  450021
  454073
  454205
  459449
  460004
  464547
  465803
  466237
  466285
  466397
  467876
  469216
  471674
  472107
  473793
  473990
  474082
  475020
  477980
  479036
  483306
  483405
  484178
  485953
  486327
  486705
  488171
  489049
  489195
  489329
  490157
  490824
  490952
  491433
  492644
  493275
  494391
  495446
  495554
  496202
  496958
  497641
  498116
  499388
  499420
  500120
  501983
  502724
  502864
  503749
  503896
  504055
  504267
  505866
  507416
  508476
  508871
  509150
  510673
  510794
  511151
  515710
  516302
  516670
  517883
  520090
  522655
  525455
  525456
  525772
  527346
  528280
  540724
  541420
  541817
  543823
  549765
  557998
  558013
  563612
  571391
  595367
  595477
  597073
  598727
  630541
]
1.92 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск женскийрод"
]
1.91 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian bitch"
]
1.75 ms
(0.47%)
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.