Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.01 ms
(86.87%)
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
  24855
  40360
  79720
  81022
  146112
  150487
  187786
  188373
  188437
  188610
  232973
  233135
  233512
  233710
  233996
  311235
  311237
  334847
  340635
  365875
  365881
  365908
  366050
  382058
  382421
  384124
  386044
  388762
  391251
  391659
  391858
  391861
  391875
  391930
  391965
  391989
  392054
  392213
  392604
  392671
  392672
  392675
  394212
  397629
  397896
  398553
  398959
  402896
  403315
  403317
  411334
  411381
  411415
  418080
  433353
  443326
  451498
  454279
  454508
  460760
  463260
  466012
  466173
  466231
  466248
  466840
  466884
  470722
  472804
  477987
  478377
  480656
  481124
  481915
  482947
  484397
  484586
  484615
  484681
  484685
  484744
  486355
  487993
  490406
  490419
  490856
  490872
  491950
  506247
  521147
  523834
  524876
  525695
  533734
  537263
  537972
  546950
  547809
  555046
  572669
  573912
  581126
  581931
  587846
  599438
  610033
  620241
  623493
  705359
  722221
  722301
  724052
  724086
  735945
  740882
  742729
  759929
  764148
  766381
  790781
]
17.67 ms
(8.04%)
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
  397896
  233710
  311235
  366050
  724052
  392213
  392054
  443326
  365908
  391251
  392671
  418080
  451498
  466173
  403317
  490856
  411334
  384124
  397629
  742729
  365881
  382421
  150487
  766381
  187786
  466840
  188373
  722221
  403315
  392675
  466012
  79720
  392672
  470722
  481915
  188610
  537263
  487993
  482947
  398959
  484615
  759929
  620241
  581126
  146112
  433353
  24855
  764148
  490419
  484586
  555046
  460760
  454508
  478377
  490406
  233512
  311237
  722301
  40360
  81022
  521147
  599438
  705359
  724086
  386044
  477987
  391875
  391858
  472804
  484397
  382058
  486355
  790781
  454279
  533734
  623493
  334847
  233135
  391659
  537972
  735945
  398553
  481124
  466231
  463260
  391965
  546950
  365875
  388762
  392604
  394212
  466248
  411381
  484685
  484744
  523834
  525695
  480656
  547809
  572669
  610033
  340635
  524876
  232973
  490872
  411415
  581931
  233996
  402896
  491950
  391861
  391930
  587846
  740882
  391989
  466884
  573912
  188437
  506247
  484681
]
3.89 ms
(1.77%)
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
  24855
  40360
  79720
  81022
  146112
  150487
  187786
  188373
  188437
  188610
  232973
  233135
  233512
  233710
  233996
  311235
  311237
  334847
  340635
  365875
  365881
  365908
  366050
  382058
  382421
  384124
  386044
  388762
  391251
  391659
  391858
  391861
  391875
  391930
  391965
  391989
  392054
  392213
  392604
  392671
  392672
  392675
  394212
  397629
  397896
  398553
  398959
  402896
  403315
  403317
  411334
  411381
  411415
  418080
  433353
  443326
  451498
  454279
  454508
  460760
  463260
  466012
  466173
  466231
  466248
  466840
  466884
  470722
  472804
  477987
  478377
  480656
  481124
  481915
  482947
  484397
  484586
  484615
  484681
  484685
  484744
  486355
  487993
  490406
  490419
  490856
  490872
  491950
  506247
  521147
  523834
  524876
  525695
  533734
  537263
  537972
  546950
  547809
  555046
  572669
  573912
  581126
  581931
  587846
  599438
  610033
  620241
  623493
  705359
  722221
  722301
  724052
  724086
  735945
  740882
  742729
  759929
  764148
  766381
  790781
]
2.13 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское тещу"
]
1.70 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск зрелая женщин"
]
1.52 ms
(0.69%)
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.