Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.85 ms
(58.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин трет вагин"
]
121.83 ms
(33.44%)
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
  423998
  442830
  452092
  452097
  452983
  461169
  463034
  464084
  466927
  468826
  469137
  470441
  472941
  478651
  478950
  489278
  493219
  496182
  498014
  498816
  500069
  500477
  500531
  505132
  507310
  508283
  510843
  513832
  514843
  516093
  516752
  516763
  516764
  519242
  520890
  521453
  521849
  523160
  524873
  527123
  528416
  528562
  528838
  530062
  530741
  531413
  531437
  531441
  531466
  532022
  533534
  533915
  534320
  534616
  536790
  537487
  540346
  541408
  542148
  543198
  548213
  550960
  554182
  556025
  558413
  559106
  565975
  567141
  569043
  570725
  578300
  578531
  578803
  582234
  583037
  583049
  586494
  587220
  588296
  590887
  591739
  595766
  602631
  602811
  603004
  603255
  603364
  603831
  604901
  605902
  607049
  609203
  610686
  612125
  614515
  614720
  618381
  619007
  622252
  623261
  625262
  626337
  626347
  645918
  664591
  680267
  685465
  688042
  717179
]
19.84 ms
(5.45%)
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
  516763
  626337
  533534
  534320
  516752
  532022
  570725
  664591
  540346
  685465
  688042
  565975
  602631
  604901
  452092
  478651
  556025
  578531
  531413
  423998
  469137
  530062
  520890
  514843
  527123
  583037
  603004
  496182
  623261
  489278
  508283
  536790
  528562
  478950
  548213
  569043
  583049
  578803
  680267
  717179
  609203
  625262
  605902
  500069
  507310
  521849
  559106
  590887
  622252
  586494
  587220
  516764
  531466
  531437
  550960
  464084
  531441
  582234
  578300
  607049
  614720
  505132
  498816
  463034
  461169
  493219
  452983
  466927
  603364
  541408
  618381
  528416
  510843
  524873
  588296
  516093
  626347
  472941
  554182
  468826
  513832
  528838
  534616
  602811
  442830
  645918
  452097
  558413
  612125
  498014
  523160
  500531
  530741
  603831
  591739
  543198
  519242
  595766
  542148
  500477
  610686
  533915
  537487
  619007
  470441
  614515
  567141
  603255
  521453
]
2.98 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
  423998
  442830
  452092
  452097
  452983
  461169
  463034
  464084
  466927
  468826
  469137
  470441
  472941
  478651
  478950
  489278
  493219
  496182
  498014
  498816
  500069
  500477
  500531
  505132
  507310
  508283
  510843
  513832
  514843
  516093
  516752
  516763
  516764
  519242
  520890
  521453
  521849
  523160
  524873
  527123
  528416
  528562
  528838
  530062
  530741
  531413
  531437
  531441
  531466
  532022
  533534
  533915
  534320
  534616
  536790
  537487
  540346
  541408
  542148
  543198
  548213
  550960
  554182
  556025
  558413
  559106
  565975
  567141
  569043
  570725
  578300
  578531
  578803
  582234
  583037
  583049
  586494
  587220
  588296
  590887
  591739
  595766
  602631
  602811
  603004
  603255
  603364
  603831
  604901
  605902
  607049
  609203
  610686
  612125
  614515
  614720
  618381
  619007
  622252
  623261
  625262
  626337
  626347
  645918
  664591
  680267
  685465
  688042
  717179
]
2.12 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мама трется пиздой"
]
2.01 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин трет вагин"
]
1.75 ms
(0.48%)
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.