Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.36 ms
(80.91%)
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
  33488
  150495
  388036
  391874
  393761
  395756
  395833
  399367
  400002
  401340
  408959
  410080
  413174
  413186
  416082
  417295
  418750
  418846
  418994
  420400
  421287
  422241
  429248
  430801
  432907
  433536
  436030
  442952
  444209
  445824
  446033
  446480
  447531
  448651
  452567
  452755
  453228
  453447
  453481
  453773
  454159
  458299
  459122
  460359
  460681
  461325
  467325
  469216
  469577
  470310
  470837
  471189
  472401
  474006
  475110
  475113
  479886
  480210
  480797
  481333
  482699
  482805
  482887
  484312
  484745
  487803
  488713
  493263
  498164
  498699
  504131
  505607
  507795
  508587
  509478
  509699
  512594
  514593
  515471
  518015
  521291
  521373
  522371
  522443
  523233
  524120
  524835
  524981
  525289
  526135
  526864
  528437
  528506
  534109
  542379
  547686
  548732
  556726
  556845
  557363
  560461
  560767
  562251
  570143
  570197
  574540
  579887
  588231
  596604
  598470
  609627
  623759
  676536
  676968
  702523
  709637
  722912
  759726
  766744
  788007
]
23.97 ms
(12.56%)
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
  534109
  560767
  482887
  493263
  676968
  526135
  393761
  482805
  452567
  515471
  570197
  574540
  388036
  413174
  33488
  420400
  408959
  470837
  484745
  391874
  410080
  481333
  504131
  709637
  759726
  444209
  475110
  570143
  418846
  518015
  556726
  418750
  480210
  702523
  433536
  469216
  470310
  471189
  525289
  522443
  524120
  579887
  432907
  467325
  514593
  509478
  722912
  399367
  436030
  521373
  395756
  482699
  453773
  469577
  460359
  488713
  418994
  429248
  475113
  547686
  522371
  528506
  446480
  487803
  453447
  459122
  509699
  524981
  150495
  417295
  447531
  454159
  395833
  421287
  623759
  556845
  512594
  446033
  676536
  588231
  528437
  453481
  526864
  460681
  788007
  458299
  413186
  445824
  479886
  484312
  523233
  524835
  560461
  609627
  452755
  442952
  461325
  416082
  480797
  505607
  508587
  498164
  498699
  401340
  542379
  548732
  448651
  766744
  474006
  596604
  400002
  507795
  521291
  422241
  557363
  472401
  453228
  430801
  598470
  562251
]
4.48 ms
(2.35%)
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
  33488
  150495
  388036
  391874
  393761
  395756
  395833
  399367
  400002
  401340
  408959
  410080
  413174
  413186
  416082
  417295
  418750
  418846
  418994
  420400
  421287
  422241
  429248
  430801
  432907
  433536
  436030
  442952
  444209
  445824
  446033
  446480
  447531
  448651
  452567
  452755
  453228
  453447
  453481
  453773
  454159
  458299
  459122
  460359
  460681
  461325
  467325
  469216
  469577
  470310
  470837
  471189
  472401
  474006
  475110
  475113
  479886
  480210
  480797
  481333
  482699
  482805
  482887
  484312
  484745
  487803
  488713
  493263
  498164
  498699
  504131
  505607
  507795
  508587
  509478
  509699
  512594
  514593
  515471
  518015
  521291
  521373
  522371
  522443
  523233
  524120
  524835
  524981
  525289
  526135
  526864
  528437
  528506
  534109
  542379
  547686
  548732
  556726
  556845
  557363
  560461
  560767
  562251
  570143
  570197
  574540
  579887
  588231
  596604
  598470
  609627
  623759
  676536
  676968
  702523
  709637
  722912
  759726
  766744
  788007
]
2.36 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс молодая девушк"
]
1.97 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс молодая девушк"
]
1.85 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐüðÁð║Ðü Ðü ð╝ð¥ð╗ð¥ð┤ðÁð¢Ðîð║ð¥ð╣ Ðüð¥ÐÔǪ"
]

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.