Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.31 ms
(83.32%)
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
  185855
  187595
  187636
  189743
  233029
  359102
  361315
  365910
  385638
  388365
  397362
  404306
  405546
  411326
  411604
  411615
  413303
  424985
  428829
  439524
  439651
  439686
  439735
  443758
  451931
  451991
  452145
  454887
  460760
  460761
  462290
  465592
  465955
  466235
  467550
  469509
  470959
  474824
  474877
  479073
  479082
  479145
  480392
  483147
  484443
  487347
  490267
  490918
  491989
  502749
  508746
  517013
  518846
  521147
  523579
  535264
  546962
  550380
  555098
  557148
  560394
  560430
  563209
  563227
  563436
  577965
  589707
  603151
  617016
  697180
  710502
  712311
  712553
  712812
  713635
  714171
  714646
  715450
  718553
  722088
  724476
  726767
  726902
  728442
  734102
  736402
  740158
  741906
  742812
  743724
  744904
  745196
  745382
  748163
  748240
  758436
  758446
  769429
  772100
  774176
  781759
  781980
  797220
  799016
  801319
  804006
  807539
  807627
  808021
  808496
  808541
  814909
  816784
  816785
  816792
  818643
  818824
  818851
  819001
  823444
]
18.22 ms
(10.59%)
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
  397362
  734102
  769429
  742812
  521147
  523579
  479082
  388365
  428829
  404306
  560394
  563209
  546962
  781759
  724476
  736402
  748163
  748240
  470959
  818851
  560430
  712311
  726902
  460760
  411326
  411615
  385638
  814909
  818643
  490267
  722088
  577965
  617016
  808541
  758446
  726767
  744904
  439735
  187636
  361315
  603151
  808021
  479145
  797220
  451931
  451991
  535264
  465955
  411604
  465592
  462290
  479073
  466235
  491989
  469509
  517013
  405546
  550380
  807627
  563436
  563227
  189743
  365910
  483147
  480392
  439651
  439686
  474877
  439524
  502749
  508746
  823444
  710502
  740158
  745196
  743724
  233029
  818824
  555098
  712553
  799016
  443758
  819001
  816792
  557148
  712812
  714646
  589707
  413303
  474824
  490918
  484443
  518846
  424985
  816784
  816785
  454887
  697180
  714171
  718553
  715450
  801319
  807539
  758436
  804006
  808496
  741906
  772100
  745382
  774176
  728442
  781980
  187595
  467550
  359102
  460761
  185855
  452145
  713635
  487347
]
2.47 ms
(1.44%)
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
  185855
  187595
  187636
  189743
  233029
  359102
  361315
  365910
  385638
  388365
  397362
  404306
  405546
  411326
  411604
  411615
  413303
  424985
  428829
  439524
  439651
  439686
  439735
  443758
  451931
  451991
  452145
  454887
  460760
  460761
  462290
  465592
  465955
  466235
  467550
  469509
  470959
  474824
  474877
  479073
  479082
  479145
  480392
  483147
  484443
  487347
  490267
  490918
  491989
  502749
  508746
  517013
  518846
  521147
  523579
  535264
  546962
  550380
  555098
  557148
  560394
  560430
  563209
  563227
  563436
  577965
  589707
  603151
  617016
  697180
  710502
  712311
  712553
  712812
  713635
  714171
  714646
  715450
  718553
  722088
  724476
  726767
  726902
  728442
  734102
  736402
  740158
  741906
  742812
  743724
  744904
  745196
  745382
  748163
  748240
  758436
  758446
  769429
  772100
  774176
  781759
  781980
  797220
  799016
  801319
  804006
  807539
  807627
  808021
  808496
  808541
  814909
  816784
  816785
  816792
  818643
  818824
  818851
  819001
  823444
]
2.21 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс mature"
]
2.09 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob mature"
]
2.09 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс mature"
]

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.