Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.44 ms
(85.32%)
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
  391582
  397927
  397997
  400990
  409709
  418099
  419612
  428281
  431503
  438589
  442447
  443321
  450338
  451518
  456550
  461621
  464046
  470598
  470708
  471674
  475201
  475350
  475934
  477154
  479167
  479485
  479723
  484755
  485295
  486227
  486736
  489106
  490768
  490978
  493875
  496059
  496295
  500327
  500984
  503071
  504145
  504599
  507332
  509408
  510139
  512714
  513457
  513588
  516552
  516827
  517519
  518320
  518539
  520075
  520936
  521496
  523275
  523707
  523953
  524741
  524981
  525552
  526298
  527887
  529008
  529295
  530187
  530259
  530548
  533969
  535222
  535332
  542728
  542955
  544153
  546634
  546876
  547028
  549023
  550506
  552605
  553591
  554704
  555253
  556072
  556090
  556976
  557306
  557883
  561030
  561600
  563765
  564559
  573169
  573217
  574300
  575342
  575707
  581336
  583612
  584707
  584903
  585842
  586700
  588347
  595637
  597214
  599797
  602351
  605085
  605257
  612092
  613676
  615616
  617395
  618101
  622840
  639241
  652010
  804883
]
18.08 ms
(9.27%)
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
  500984
  523275
  496059
  475201
  512714
  586700
  461621
  605085
  503071
  530187
  510139
  523953
  490768
  496295
  518539
  556072
  561600
  574300
  595637
  605257
  475350
  525552
  504599
  516827
  520936
  524741
  535332
  544153
  563765
  585842
  612092
  581336
  529008
  490978
  552605
  530548
  533969
  516552
  523707
  486227
  542728
  652010
  553591
  556976
  597214
  618101
  613676
  639241
  489106
  418099
  419612
  443321
  409709
  431503
  442447
  470598
  479723
  479167
  485295
  500327
  520075
  521496
  509408
  518320
  471674
  477154
  547028
  556090
  573217
  546634
  549023
  575707
  557883
  554704
  584707
  588347
  400990
  391582
  428281
  438589
  470708
  479485
  450338
  475934
  526298
  484755
  524981
  504145
  397927
  397997
  464046
  486736
  513457
  529295
  535222
  507332
  527887
  530259
  550506
  546876
  555253
  564559
  575342
  583612
  557306
  573169
  615616
  599797
  804883
  602351
  451518
  517519
  561030
  513588
  617395
  542955
  622840
  493875
  584903
  456550
]
3.79 ms
(1.94%)
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
  391582
  397927
  397997
  400990
  409709
  418099
  419612
  428281
  431503
  438589
  442447
  443321
  450338
  451518
  456550
  461621
  464046
  470598
  470708
  471674
  475201
  475350
  475934
  477154
  479167
  479485
  479723
  484755
  485295
  486227
  486736
  489106
  490768
  490978
  493875
  496059
  496295
  500327
  500984
  503071
  504145
  504599
  507332
  509408
  510139
  512714
  513457
  513588
  516552
  516827
  517519
  518320
  518539
  520075
  520936
  521496
  523275
  523707
  523953
  524741
  524981
  525552
  526298
  527887
  529008
  529295
  530187
  530259
  530548
  533969
  535222
  535332
  542728
  542955
  544153
  546634
  546876
  547028
  549023
  550506
  552605
  553591
  554704
  555253
  556072
  556090
  556976
  557306
  557883
  561030
  561600
  563765
  564559
  573169
  573217
  574300
  575342
  575707
  581336
  583612
  584707
  584903
  585842
  586700
  588347
  595637
  597214
  599797
  602351
  605085
  605257
  612092
  613676
  615616
  617395
  618101
  622840
  639241
  652010
  804883
]
1.97 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "реальное в одежде"
]
1.71 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск в одежд"
]
1.22 ms
(0.63%)
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.