Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.04 ms
(82.89%)
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
  81869
  89021
  131474
  192551
  391102
  396029
  400470
  401047
  410008
  416873
  419281
  420109
  420580
  428623
  432370
  432392
  432393
  432481
  432497
  432886
  433366
  433452
  433729
  433953
  434093
  434768
  437779
  438023
  441231
  441334
  442802
  443173
  443852
  446086
  447797
  448198
  449397
  453022
  454020
  455383
  455448
  456447
  456916
  458295
  458821
  459574
  462954
  465002
  470706
  473206
  473629
  478296
  484490
  490732
  493296
  494195
  499266
  499414
  501348
  502220
  503483
  505261
  505705
  512702
  513579
  515317
  517174
  517377
  521348
  521646
  527675
  530210
  530244
  532301
  538060
  545745
  546580
  548555
  552366
  553260
  554046
  556726
  557405
  563670
  564068
  567701
  568961
  574014
  576556
  577413
  582934
  586741
  591080
  596441
  601435
  613882
  699189
  744780
  754145
  766931
  768208
  777232
  778606
  779827
  780230
  782486
  787971
  788462
  789085
  792351
  795127
  795361
  796693
  801505
  802092
  802093
  806263
  813045
  813444
]
13.88 ms
(9.58%)
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
  778606
  795361
  796693
  769187
  576556
  777232
  787971
  574014
  556726
  433729
  499266
  813045
  442802
  441334
  448198
  449397
  458295
  470706
  478296
  548555
  567701
  553260
  401047
  416873
  432497
  458821
  456447
  447797
  459574
  473206
  517174
  501348
  502220
  437779
  517377
  596441
  515317
  432481
  432393
  699189
  462954
  419281
  131474
  438023
  802093
  443173
  538060
  554046
  813444
  768208
  433366
  802092
  766931
  801505
  582934
  391102
  789085
  806263
  782486
  192551
  513579
  410008
  532301
  754145
  795127
  432370
  432886
  545745
  744780
  779827
  396029
  456916
  473629
  613882
  788462
  420109
  792351
  432392
  441231
  490732
  446086
  453022
  552366
  546580
  557405
  563670
  577413
  586741
  591080
  433452
  420580
  434093
  530244
  484490
  521646
  527675
  512702
  521348
  400470
  499414
  81869
  530210
  564068
  505261
  465002
  455448
  568961
  455383
  443852
  433953
  89021
  503483
  780230
  434768
  428623
  494195
  601435
  454020
  493296
  505705
]
3.13 ms
(2.16%)
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
  81869
  89021
  131474
  192551
  391102
  396029
  400470
  401047
  410008
  416873
  419281
  420109
  420580
  428623
  432370
  432392
  432393
  432481
  432497
  432886
  433366
  433452
  433729
  433953
  434093
  434768
  437779
  438023
  441231
  441334
  442802
  443173
  443852
  446086
  447797
  448198
  449397
  453022
  454020
  455383
  455448
  456447
  456916
  458295
  458821
  459574
  462954
  465002
  470706
  473206
  473629
  478296
  484490
  490732
  493296
  494195
  499266
  499414
  501348
  502220
  503483
  505261
  505705
  512702
  513579
  515317
  517174
  517377
  521348
  521646
  527675
  530210
  530244
  532301
  538060
  545745
  546580
  548555
  552366
  553260
  554046
  556726
  557405
  563670
  564068
  567701
  568961
  574014
  576556
  577413
  582934
  586741
  591080
  596441
  601435
  613882
  699189
  744780
  754145
  766931
  768208
  777232
  778606
  779827
  780230
  782486
  787971
  788462
  789085
  792351
  795127
  795361
  796693
  801505
  802092
  802093
  806263
  813045
  813444
]
2.26 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "парень дрочит частное…"
]
1.87 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен дрочк любительск"
]
1.86 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.