Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.83 ms
(80.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
  39167
  396869
  398138
  400569
  401935
  404052
  425935
  429252
  438046
  456288
  456565
  461634
  469418
  470230
  470360
  472095
  473562
  475574
  476765
  491698
  493933
  511047
  523044
  535008
  541946
  543851
  549401
  551221
  551263
  553398
  554642
  560493
  560911
  564083
  567688
  567861
  572825
  576391
  581028
  585290
  589771
  599439
  599763
  606212
  613415
  613579
  618189
  622022
  625750
  627032
  629650
  635569
  646325
  647126
  649905
  650020
  650228
  660270
  666476
  670467
  671242
  681699
  682956
  691112
  695074
  696053
  696062
  696675
  696687
  696698
  696716
  698195
  699108
  700171
  701611
  702347
  707332
  712835
  715874
  716121
  716786
  720470
  722993
  724331
  739688
  758949
  761483
  765802
  768013
  771514
  772836
  773498
  775815
  779811
  784104
  786588
  791579
  792351
  798746
  798940
  798989
  817403
  817519
  817520
  817853
  818697
  819221
  819452
  819454
  819524
  820564
  820978
  821004
  821143
  821168
  821475
  821507
  821564
  826158
]
17.46 ms
(12.30%)
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
  819221
  819524
  646325
  712835
  765802
  798940
  739688
  650020
  551263
  541946
  666476
  396869
  535008
  613415
  768013
  429252
  470230
  564083
  425935
  491698
  817403
  817519
  820564
  821143
  821168
  821564
  819452
  822935
  715874
  647126
  622022
  798746
  791579
  404052
  543851
  554642
  716121
  599439
  476765
  560911
  456565
  456288
  551221
  560493
  696062
  635569
  618189
  786588
  758949
  784104
  771514
  773498
  775815
  817853
  553398
  576391
  39167
  670467
  779811
  682956
  691112
  798989
  398138
  511047
  701611
  472095
  696053
  696698
  696716
  722993
  696675
  702347
  720470
  599763
  606212
  589771
  625750
  772836
  696687
  401935
  681699
  761483
  572825
  613579
  567688
  627032
  461634
  650228
  707332
  493933
  523044
  649905
  400569
  826158
  469418
  473562
  792351
  438046
  470360
  475574
  581028
  724331
  818697
  819454
  821507
  817520
  820978
  821004
  821475
  567861
  699108
  671242
  695074
  698195
  716786
  660270
  700171
  549401
  629650
  585290
]
2.51 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
  39167
  396869
  398138
  400569
  401935
  404052
  425935
  429252
  438046
  456288
  456565
  461634
  469418
  470230
  470360
  472095
  473562
  475574
  476765
  491698
  493933
  511047
  523044
  535008
  541946
  543851
  549401
  551221
  551263
  553398
  554642
  560493
  560911
  564083
  567688
  567861
  572825
  576391
  581028
  585290
  589771
  599439
  599763
  606212
  613415
  613579
  618189
  622022
  625750
  627032
  629650
  635569
  646325
  647126
  649905
  650020
  650228
  660270
  666476
  670467
  671242
  681699
  682956
  691112
  695074
  696053
  696062
  696675
  696687
  696698
  696716
  698195
  699108
  700171
  701611
  702347
  707332
  712835
  715874
  716121
  716786
  720470
  722993
  724331
  739688
  758949
  761483
  765802
  768013
  771514
  772836
  773498
  775815
  779811
  784104
  786588
  791579
  792351
  798746
  798940
  798989
  817403
  817519
  817520
  817853
  818697
  819221
  819452
  819454
  819524
  820564
  820978
  821004
  821143
  821168
  821475
  821507
  821564
  826158
]
2.13 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет улица"
]
1.79 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс улиц"
]
1.57 ms
(1.10%)
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.