Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.17 ms
(85.17%)
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
  47606
  50215
  229345
  274758
  313286
  314133
  318463
  326115
  358778
  383418
  384033
  384298
  384566
  386719
  386974
  387938
  388935
  390747
  392024
  392031
  392984
  393524
  393700
  393727
  395459
  395724
  397456
  397911
  398003
  398462
  399023
  399267
  401059
  402032
  405966
  407538
  407561
  407707
  408425
  409882
  411406
  411941
  413516
  416335
  417362
  418334
  420253
  423637
  423919
  424414
  424483
  424562
  425395
  425684
  425875
  426000
  428022
  431152
  432086
  443834
  444327
  447456
  451872
  452145
  454857
  455045
  455325
  459192
  459831
  461785
  462508
  462961
  465214
  466052
  467370
  469862
  470673
  473510
  474807
  477959
  477992
  482547
  483242
  483609
  484140
  484374
  489577
  489822
  492361
  493096
  496108
  502193
  502289
  508120
  509498
  510636
  516783
  546660
  552423
  558432
  559520
  563058
  570672
  571600
  571637
  573231
  603159
  607125
  727111
  743968
  757519
  761555
  768226
  772440
  773198
  775600
  777128
  781999
  786880
  826739
]
16.44 ms
(9.39%)
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
  743968
  772440
  786880
  757519
  768226
  727111
  773198
  777128
  50215
  418334
  423637
  392984
  398003
  459831
  384033
  383418
  387938
  314133
  425684
  393727
  393524
  395724
  313286
  326115
  405966
  407707
  420253
  417362
  411941
  432086
  477959
  447456
  469862
  462961
  493096
  516783
  496108
  502289
  571600
  571637
  563058
  546660
  570672
  607125
  781999
  397911
  408425
  423919
  455045
  477992
  384566
  407561
  431152
  462508
  392024
  392031
  424414
  425395
  426000
  443834
  395459
  399267
  411406
  467370
  470673
  424483
  484140
  508120
  483609
  489822
  510636
  483242
  484374
  489577
  474807
  502193
  454857
  416335
  459192
  761555
  603159
  428022
  401059
  47606
  473510
  509498
  466052
  452145
  444327
  425875
  390747
  388935
  492361
  573231
  398462
  826739
  775600
  386974
  402032
  386719
  274758
  399023
  558432
  318463
  384298
  358778
  397456
  409882
  482547
  451872
  465214
  461785
  455325
  552423
  559520
  393700
  407538
  413516
  424562
  229345
]
2.55 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
  47606
  50215
  229345
  274758
  313286
  314133
  318463
  326115
  358778
  383418
  384033
  384298
  384566
  386719
  386974
  387938
  388935
  390747
  392024
  392031
  392984
  393524
  393700
  393727
  395459
  395724
  397456
  397911
  398003
  398462
  399023
  399267
  401059
  402032
  405966
  407538
  407561
  407707
  408425
  409882
  411406
  411941
  413516
  416335
  417362
  418334
  420253
  423637
  423919
  424414
  424483
  424562
  425395
  425684
  425875
  426000
  428022
  431152
  432086
  443834
  444327
  447456
  451872
  452145
  454857
  455045
  455325
  459192
  459831
  461785
  462508
  462961
  465214
  466052
  467370
  469862
  470673
  473510
  474807
  477959
  477992
  482547
  483242
  483609
  484140
  484374
  489577
  489822
  492361
  493096
  496108
  502193
  502289
  508120
  509498
  510636
  516783
  546660
  552423
  558432
  559520
  563058
  570672
  571600
  571637
  573231
  603159
  607125
  727111
  743968
  757519
  761555
  768226
  772440
  773198
  775600
  777128
  781999
  786880
  826739
]
2.39 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "видео ролики куни"
]
1.86 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "виде ролик куннилингус оральн секс"
]
1.48 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.71%)
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.