Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.94 ms
(83.60%)
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
  285356
  385105
  396013
  407549
  415189
  415748
  416215
  432404
  434281
  434429
  437448
  445743
  457018
  461696
  466219
  475547
  479176
  489244
  492197
  498668
  500191
  503064
  503395
  507549
  509780
  528540
  551553
  564240
  583283
  584610
  603096
  606733
  607007
  610191
  610196
  613200
  617687
  621527
  628614
  636440
  675359
  675448
  681525
  684150
  708760
  710305
  716362
  717119
  717327
  717438
  718967
  719504
  719864
  728635
  728661
  730948
  731604
  734707
  735625
  741823
  742602
  743565
  743857
  744457
  744479
  746553
  746773
  748450
  749361
  750208
  750266
  750922
  751918
  757236
  757995
  760361
  760933
  767422
  767616
  767725
  768114
  769185
  777859
  782524
  784586
  785125
  785827
  787222
  787822
  788214
  789470
  790569
  791774
  791924
  792031
  792525
  793493
  794574
  795243
  795576
  795696
  798197
  800140
  801126
  801784
  802149
  802179
  802304
  804535
  804559
  804686
  805881
  807777
  809877
  811799
  812258
  813638
]
12.41 ms
(8.95%)
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
  792031
  437448
  802304
  528540
  434281
  434429
  479176
  461696
  466219
  498668
  503395
  500191
  509780
  714962
  716362
  610191
  811799
  804686
  744479
  768114
  621527
  489244
  813638
  445743
  710305
  564240
  790569
  792525
  795696
  743565
  750208
  767725
  746773
  734707
  735625
  757236
  787222
  787822
  812258
  746553
  785827
  407549
  603096
  432404
  475547
  717119
  804535
  385105
  675448
  584610
  628614
  415748
  492197
  503064
  606733
  457018
  681525
  675359
  718967
  636440
  789470
  777859
  800140
  802149
  804559
  728635
  728661
  741823
  767422
  769185
  769187
  795243
  749361
  767616
  731604
  610196
  717327
  717438
  791924
  801784
  684150
  802179
  396013
  415189
  285356
  551553
  507549
  719504
  708760
  719864
  617687
  613200
  785125
  791774
  798197
  805881
  795576
  742602
  744457
  750922
  760933
  730948
  743857
  757995
  759141
  748450
  750266
  751918
  760361
  782524
  784586
  788214
  793493
  807777
  809877
  794574
  801126
  416215
  583283
  607007
]
2.74 ms
(1.97%)
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
  285356
  385105
  396013
  407549
  415189
  415748
  416215
  432404
  434281
  434429
  437448
  445743
  457018
  461696
  466219
  475547
  479176
  489244
  492197
  498668
  500191
  503064
  503395
  507549
  509780
  528540
  551553
  564240
  583283
  584610
  603096
  606733
  607007
  610191
  610196
  613200
  617687
  621527
  628614
  636440
  675359
  675448
  681525
  684150
  708760
  710305
  716362
  717119
  717327
  717438
  718967
  719504
  719864
  728635
  728661
  730948
  731604
  734707
  735625
  741823
  742602
  743565
  743857
  744457
  744479
  746553
  746773
  748450
  749361
  750208
  750266
  750922
  751918
  757236
  757995
  760361
  760933
  767422
  767616
  767725
  768114
  769185
  777859
  782524
  784586
  785125
  785827
  787222
  787822
  788214
  789470
  790569
  791774
  791924
  792031
  792525
  793493
  794574
  795243
  795576
  795696
  798197
  800140
  801126
  801784
  802149
  802179
  802304
  804535
  804559
  804686
  805881
  807777
  809877
  811799
  812258
  813638
]
2.24 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage for wife"
]
2.08 ms
(1.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж жен"
]
1.69 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.14%)
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.