Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.59 ms
(87.99%)
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
  6609
  357750
  382906
  383005
  385105
  389487
  395625
  405203
  405224
  409291
  419218
  421105
  434429
  440928
  447882
  450656
  451983
  453220
  454323
  456579
  457767
  459241
  461364
  463636
  465687
  466219
  469825
  476309
  479029
  490706
  496720
  500191
  501568
  503064
  503395
  506629
  506844
  508745
  512593
  516039
  520726
  522775
  525239
  526669
  526704
  532110
  533193
  544430
  545814
  548081
  550425
  560136
  561595
  562967
  564240
  578478
  583280
  584200
  591778
  591968
  600581
  602725
  610185
  612574
  616856
  618658
  619604
  624436
  627777
  641052
  667675
  667894
  668549
  668765
  669220
  675359
  682304
  695292
  709372
  720943
  727717
  738432
  740138
  743789
  743810
  744472
  746207
  746553
  746678
  756460
  761422
  761607
  768163
  768164
  778853
  782408
  782420
  788214
  788215
  789745
  790784
  792775
  793495
  793591
  793624
  794562
  796200
  796865
  800257
  801126
  802149
  802367
  803966
  806220
  806415
  811781
  813264
  815544
  824788
  828714
]
13.20 ms
(6.81%)
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
  782408
  828714
  803966
  496720
  789745
  421105
  668549
  520726
  506844
  675359
  746553
  793495
  405224
  459241
  382906
  743789
  782420
  793591
  560136
  584200
  508745
  447882
  790784
  479029
  383005
  409291
  669220
  796865
  500191
  357750
  456579
  544430
  610185
  788214
  461364
  522775
  578478
  667894
  667675
  744472
  465687
  591968
  405203
  503064
  618658
  743810
  768164
  788215
  824788
  794562
  545814
  600581
  727717
  454323
  532110
  813264
  440928
  512593
  548081
  463636
  792775
  526669
  619604
  682304
  815544
  564240
  516039
  778853
  802367
  738432
  761607
  801126
  451983
  562967
  501568
  476309
  506629
  385105
  550425
  695292
  668765
  602725
  761422
  756460
  806220
  6609
  533193
  561595
  641052
  591778
  526704
  616856
  796200
  811781
  806415
  793624
  802149
  800257
  746678
  612574
  768163
  746207
  627777
  709372
  419218
  525239
  624436
  740138
  720943
  434429
  466219
  503395
  389487
  457767
  490706
  583280
  395625
  453220
  450656
  469825
]
2.36 ms
(1.22%)
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
  6609
  357750
  382906
  383005
  385105
  389487
  395625
  405203
  405224
  409291
  419218
  421105
  434429
  440928
  447882
  450656
  451983
  453220
  454323
  456579
  457767
  459241
  461364
  463636
  465687
  466219
  469825
  476309
  479029
  490706
  496720
  500191
  501568
  503064
  503395
  506629
  506844
  508745
  512593
  516039
  520726
  522775
  525239
  526669
  526704
  532110
  533193
  544430
  545814
  548081
  550425
  560136
  561595
  562967
  564240
  578478
  583280
  584200
  591778
  591968
  600581
  602725
  610185
  612574
  616856
  618658
  619604
  624436
  627777
  641052
  667675
  667894
  668549
  668765
  669220
  675359
  682304
  695292
  709372
  720943
  727717
  738432
  740138
  743789
  743810
  744472
  746207
  746553
  746678
  756460
  761422
  761607
  768163
  768164
  778853
  782408
  782420
  788214
  788215
  789745
  790784
  792775
  793495
  793591
  793624
  794562
  796200
  796865
  800257
  801126
  802149
  802367
  803966
  806220
  806415
  811781
  813264
  815544
  824788
  828714
]
2.04 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage mother"
]
1.99 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж мам женщин"
]
1.71 ms
(0.88%)
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.