Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
258.20 ms
(90.66%)
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
  7295
  53670
  387941
  414675
  416448
  421827
  423662
  427521
  441162
  446562
  450518
  453209
  458942
  459185
  468128
  473745
  475508
  476317
  476668
  476692
  477506
  478720
  479867
  480019
  486240
  489451
  489729
  490380
  497675
  509996
  517662
  522143
  522159
  535959
  545369
  545376
  558223
  560872
  563939
  564040
  577105
  584968
  589333
  590377
  591331
  591333
  595189
  598388
  604351
  607520
  607560
  607569
  613304
  613679
  617604
  620648
  622982
  624079
  632121
  642001
  655010
  656891
  660598
  663158
  670757
  673035
  680484
  688617
  689508
  692740
  692752
  716568
  718014
  735132
  738827
  744022
  744350
  745328
  747322
  747725
  747955
  750895
  752298
  752474
  758777
  760169
  761632
  765168
  770544
  772235
  772579
  781299
  782143
  783051
  784671
  787434
  790689
  791212
  797025
  801628
  802571
  802898
  802925
  803484
  806529
  806580
  806815
  807173
  808796
  812189
  812273
  812553
  813199
  813380
  814192
  816722
  818667
  824475
  826951
]
16.66 ms
(5.85%)
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
  476692
  613304
  591333
  475508
  589333
  414675
  423662
  459185
  563939
  797025
  752298
  747955
  744350
  416448
  7295
  560872
  477506
  453209
  509996
  790689
  558223
  604351
  421827
  489451
  522159
  564040
  427521
  458942
  692752
  468128
  688617
  489729
  816722
  473745
  545369
  673035
  620648
  760169
  738827
  735132
  632121
  818667
  670757
  692740
  783051
  802571
  752474
  781299
  747725
  53670
  814192
  480019
  522143
  663158
  716568
  718014
  655010
  656891
  689508
  617604
  595189
  607569
  624079
  607520
  613679
  806815
  807173
  812189
  791212
  806529
  812273
  772235
  772579
  784671
  801628
  803484
  808796
  812553
  813199
  744022
  745328
  750895
  761632
  765168
  758777
  770544
  747322
  642001
  802898
  802925
  441162
  535959
  479867
  787434
  545376
  680484
  590377
  806580
  486240
  450518
  607560
  824475
  826951
  823328
  660598
  622982
  813380
  782143
  478720
  490380
  387941
  446562
  591331
  497675
  517662
  476668
  598388
  476317
  577105
  584968
]
3.60 ms
(1.26%)
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
  7295
  53670
  387941
  414675
  416448
  421827
  423662
  427521
  441162
  446562
  450518
  453209
  458942
  459185
  468128
  473745
  475508
  476317
  476668
  476692
  477506
  478720
  479867
  480019
  486240
  489451
  489729
  490380
  497675
  509996
  517662
  522143
  522159
  535959
  545369
  545376
  558223
  560872
  563939
  564040
  577105
  584968
  589333
  590377
  591331
  591333
  595189
  598388
  604351
  607520
  607560
  607569
  613304
  613679
  617604
  620648
  622982
  624079
  632121
  642001
  655010
  656891
  660598
  663158
  670757
  673035
  680484
  688617
  689508
  692740
  692752
  716568
  718014
  735132
  738827
  744022
  744350
  745328
  747322
  747725
  747955
  750895
  752298
  752474
  758777
  760169
  761632
  765168
  770544
  772235
  772579
  781299
  782143
  783051
  784671
  787434
  790689
  791212
  797025
  801628
  802571
  802898
  802925
  803484
  806529
  806580
  806815
  807173
  808796
  812189
  812273
  812553
  813199
  813380
  814192
  816722
  818667
  824475
  826951
]
1.82 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo panties"
]
1.55 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд трусик нижн бел"
]
1.54 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.51%)
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.