Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.95 ms
(84.98%)
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
  463245
  478668
  480745
  488904
  489239
  489262
  489712
  491082
  495199
  497935
  501707
  502887
  502890
  503730
  503754
  507096
  507168
  507797
  507946
  511283
  514123
  514265
  514286
  514331
  515603
  516874
  517493
  518188
  518603
  518745
  519829
  521208
  521412
  522992
  523154
  523160
  523384
  524850
  525378
  526368
  526370
  527895
  530216
  532662
  533966
  534616
  535896
  536481
  536695
  541419
  541593
  541631
  543599
  543615
  543844
  544012
  545851
  551034
  551090
  551997
  552623
  556047
  558132
  558194
  558768
  559183
  559801
  562777
  562853
  567281
  568390
  569042
  569274
  573429
  575387
  577535
  578494
  579360
  579633
  583366
  583723
  583894
  583989
  583999
  584005
  586289
  586524
  586981
  587152
  588745
  589730
  589795
  590561
  590592
  592979
  593186
  596987
  597587
  600014
  602407
  603693
  605162
  605521
  608172
  608930
  609540
  614077
  614194
  614553
  617117
  620098
  623818
  626441
  631981
  635074
  676117
  680733
  680953
  681279
  687461
]
18.64 ms
(9.72%)
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
  480745
  489262
  558194
  545851
  551090
  680953
  589730
  463245
  507946
  514123
  514265
  514286
  514331
  522992
  503754
  507797
  523384
  530216
  503730
  507096
  507168
  518745
  527895
  535896
  501707
  502887
  511283
  518188
  518603
  526368
  526370
  534616
  556047
  562853
  568390
  569274
  577535
  584005
  551034
  558768
  583894
  676117
  687461
  558132
  569042
  579633
  586981
  602407
  608172
  609540
  614194
  590592
  605162
  588745
  589795
  593186
  597587
  614553
  586289
  590561
  596987
  614077
  521208
  533966
  532662
  541419
  543844
  583723
  579360
  617117
  519829
  523154
  524850
  583989
  681279
  608930
  592979
  478668
  489239
  489712
  491082
  523160
  517493
  516874
  536481
  502890
  575387
  544012
  573429
  543615
  583999
  680733
  626441
  587152
  603693
  631981
  635074
  552623
  559183
  536695
  605521
  495199
  541593
  567281
  623818
  620098
  541631
  515603
  521412
  525378
  543599
  562777
  551997
  578494
  559801
  586524
  497935
  583366
  600014
  488904
]
2.98 ms
(1.55%)
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
  463245
  478668
  480745
  488904
  489239
  489262
  489712
  491082
  495199
  497935
  501707
  502887
  502890
  503730
  503754
  507096
  507168
  507797
  507946
  511283
  514123
  514265
  514286
  514331
  515603
  516874
  517493
  518188
  518603
  518745
  519829
  521208
  521412
  522992
  523154
  523160
  523384
  524850
  525378
  526368
  526370
  527895
  530216
  532662
  533966
  534616
  535896
  536481
  536695
  541419
  541593
  541631
  543599
  543615
  543844
  544012
  545851
  551034
  551090
  551997
  552623
  556047
  558132
  558194
  558768
  559183
  559801
  562777
  562853
  567281
  568390
  569042
  569274
  573429
  575387
  577535
  578494
  579360
  579633
  583366
  583723
  583894
  583989
  583999
  584005
  586289
  586524
  586981
  587152
  588745
  589730
  589795
  590561
  590592
  592979
  593186
  596987
  597587
  600014
  602407
  603693
  605162
  605521
  608172
  608930
  609540
  614077
  614194
  614553
  617117
  620098
  623818
  626441
  631981
  635074
  676117
  680733
  680953
  681279
  687461
]
1.93 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "много женщин я один"
]
1.86 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мног женщин"
]
1.83 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мног женщин"
]
1.56 ms
(0.81%)
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.