Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.70 ms
(84.72%)
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
  61536
  382541
  389536
  410267
  414138
  414157
  418135
  419619
  420674
  429518
  432936
  437718
  439117
  439243
  445212
  448257
  450088
  451317
  452936
  455902
  456230
  462138
  468153
  468165
  468237
  470092
  470191
  475416
  476000
  476082
  476707
  476847
  480662
  482768
  491083
  496240
  510001
  510280
  516807
  518183
  518256
  523882
  523884
  526159
  527761
  535275
  535622
  536579
  544812
  547467
  547746
  547858
  564201
  564961
  565653
  571222
  574136
  574388
  578834
  590145
  592384
  593289
  596799
  602241
  605820
  607799
  609644
  613637
  615918
  618256
  621742
  633731
  634556
  640530
  647322
  664594
  677854
  700257
  720206
  720720
  725631
  736493
  744050
  745485
  749070
  749248
  749254
  752644
  753960
  754903
  757905
  758669
  765092
  770169
  770226
  770253
  770804
  772584
  775116
  776400
  782140
  782450
  784234
  784975
  785961
  786906
  787342
  790143
  794007
  794190
  794205
  794216
  796767
  796868
  802914
  808319
  809076
  809488
  810606
  816669
]
17.78 ms
(10.00%)
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
  633731
  607799
  613637
  776400
  786906
  809076
  770804
  758669
  725631
  749070
  757905
  770253
  749248
  749254
  752644
  753960
  618256
  621742
  794205
  802914
  419619
  420674
  480662
  518183
  523884
  418135
  496240
  445212
  491083
  602241
  664594
  677854
  700257
  61536
  462138
  410267
  482768
  536579
  544812
  720720
  647322
  640530
  634556
  810606
  452936
  382541
  389536
  468237
  564201
  527761
  535275
  535622
  547858
  785961
  809488
  775116
  784234
  784975
  796767
  745485
  770169
  772584
  790143
  794007
  754903
  736493
  765092
  609644
  782140
  787342
  794216
  796868
  518256
  816669
  526159
  596799
  593289
  794190
  744050
  451317
  510001
  439243
  439117
  476082
  565653
  432936
  574136
  450088
  456230
  476707
  578834
  782450
  720206
  414138
  470191
  476000
  510280
  429518
  590145
  470092
  564961
  455902
  547746
  571222
  592384
  605820
  437718
  476847
  808319
  770226
  615918
  414157
  547467
  574388
  448257
  523882
  468165
  516807
  468153
  475416
]
2.98 ms
(1.68%)
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
  61536
  382541
  389536
  410267
  414138
  414157
  418135
  419619
  420674
  429518
  432936
  437718
  439117
  439243
  445212
  448257
  450088
  451317
  452936
  455902
  456230
  462138
  468153
  468165
  468237
  470092
  470191
  475416
  476000
  476082
  476707
  476847
  480662
  482768
  491083
  496240
  510001
  510280
  516807
  518183
  518256
  523882
  523884
  526159
  527761
  535275
  535622
  536579
  544812
  547467
  547746
  547858
  564201
  564961
  565653
  571222
  574136
  574388
  578834
  590145
  592384
  593289
  596799
  602241
  605820
  607799
  609644
  613637
  615918
  618256
  621742
  633731
  634556
  640530
  647322
  664594
  677854
  700257
  720206
  720720
  725631
  736493
  744050
  745485
  749070
  749248
  749254
  752644
  753960
  754903
  757905
  758669
  765092
  770169
  770226
  770253
  770804
  772584
  775116
  776400
  782140
  782450
  784234
  784975
  785961
  786906
  787342
  790143
  794007
  794190
  794205
  794216
  796767
  796868
  802914
  808319
  809076
  809488
  810606
  816669
]
2.11 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo panties"
]
1.58 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд трусик нижн бел"
]
1.57 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.17 ms
(0.66%)
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.