Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.00 ms
(85.59%)
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
  33459
  385296
  425945
  427346
  431242
  433106
  451256
  452594
  462840
  463764
  465313
  465343
  469145
  469520
  471976
  472388
  472902
  472934
  474139
  474654
  483474
  483607
  485478
  491972
  493197
  495734
  499112
  502744
  504059
  504354
  504864
  506805
  508150
  508451
  512539
  513901
  515396
  516009
  517067
  517601
  523360
  524860
  524878
  524882
  524952
  525119
  525662
  526206
  526261
  526381
  527377
  529162
  529265
  533232
  536472
  540573
  540802
  541410
  541642
  541644
  541671
  541683
  541841
  541864
  546511
  549225
  554468
  555805
  556044
  556636
  557569
  558303
  559183
  559350
  563422
  564363
  569128
  571664
  576653
  577364
  581997
  585798
  589553
  590437
  591065
  591253
  593238
  593292
  598601
  599512
  599635
  602092
  602668
  604955
  605456
  606533
  606888
  607129
  607706
  608930
  614993
  615565
  619395
  619501
  621764
  623149
  623883
  624428
  630916
  633780
  646849
  665466
  668872
  670056
  673965
  678764
  678782
  688656
  705140
  814429
]
19.60 ms
(9.37%)
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
  517601
  554468
  557569
  564363
  668872
  591253
  619395
  527377
  606533
  581997
  524952
  608930
  425945
  556636
  602092
  576653
  646849
  593292
  614993
  465313
  385296
  533232
  541841
  563422
  474654
  508451
  525662
  512539
  605456
  451256
  623149
  607129
  524878
  524860
  599635
  493197
  529265
  526261
  506805
  472934
  541410
  559350
  607706
  630916
  491972
  624428
  483607
  541864
  523360
  465343
  485478
  558303
  670056
  619501
  621764
  33459
  814429
  536472
  502744
  504059
  504354
  665466
  678764
  585798
  598601
  433106
  462840
  452594
  431242
  540802
  516009
  526381
  540573
  559183
  471976
  524882
  483474
  474139
  541671
  571664
  615565
  705140
  541642
  541644
  599512
  472902
  513901
  525119
  469145
  556044
  577364
  589553
  593238
  602668
  590437
  623883
  606888
  504864
  495734
  515396
  517067
  549225
  499112
  508150
  469520
  673965
  688656
  678782
  633780
  472388
  526206
  569128
  604955
  427346
  541683
  555805
  591065
  529162
  463764
  546511
]
3.05 ms
(1.46%)
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
  33459
  385296
  425945
  427346
  431242
  433106
  451256
  452594
  462840
  463764
  465313
  465343
  469145
  469520
  471976
  472388
  472902
  472934
  474139
  474654
  483474
  483607
  485478
  491972
  493197
  495734
  499112
  502744
  504059
  504354
  504864
  506805
  508150
  508451
  512539
  513901
  515396
  516009
  517067
  517601
  523360
  524860
  524878
  524882
  524952
  525119
  525662
  526206
  526261
  526381
  527377
  529162
  529265
  533232
  536472
  540573
  540802
  541410
  541642
  541644
  541671
  541683
  541841
  541864
  546511
  549225
  554468
  555805
  556044
  556636
  557569
  558303
  559183
  559350
  563422
  564363
  569128
  571664
  576653
  577364
  581997
  585798
  589553
  590437
  591065
  591253
  593238
  593292
  598601
  599512
  599635
  602092
  602668
  604955
  605456
  606533
  606888
  607129
  607706
  608930
  614993
  615565
  619395
  619501
  621764
  623149
  623883
  624428
  630916
  633780
  646849
  665466
  668872
  670056
  673965
  678764
  678782
  688656
  705140
  814429
]
2.17 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ноги чулки зрелая"
]
1.93 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ног чулк нижн бел зрелая женщин"
]
1.74 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.79%)
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.