Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.68 ms
(53.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
155.51 ms
(39.66%)
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
  103649
  119798
  397591
  410739
  412572
  413255
  414155
  417945
  419583
  423463
  436642
  439870
  443502
  445440
  446259
  452897
  453857
  454689
  454742
  460056
  469427
  470530
  472749
  479973
  480329
  480853
  482929
  488791
  488793
  489881
  490649
  496400
  500570
  502678
  504069
  509517
  512576
  513161
  516743
  531032
  533858
  536105
  536146
  538238
  538781
  543187
  543743
  547109
  547195
  547247
  548095
  548752
  550466
  557988
  559462
  559474
  560095
  566867
  567411
  568019
  571311
  573493
  575357
  575700
  577160
  579236
  587376
  587856
  589113
  602113
  603015
  609601
  621183
  623440
  632920
  636218
  668739
  680583
  687841
  704969
  716433
  717035
  733650
  733659
  746367
  758563
  761631
  764047
  768920
  768931
  771347
  783167
  783807
  790493
  800167
  818111
  818193
  818337
  818350
  824209
  824385
  824474
  826049
  826258
  826457
  827056
  827248
  827374
  828148
  828362
  828510
  828568
  828707
  828732
  828852
]
16.43 ms
(4.19%)
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
  828204
  828362
  828732
  828510
  531032
  687841
  733650
  103649
  423463
  536146
  538781
  496400
  550466
  543187
  559462
  571311
  603015
  602113
  621183
  119798
  454689
  443502
  509517
  488793
  488791
  513161
  439870
  446259
  479973
  453857
  490649
  500570
  547247
  548752
  575700
  567411
  587376
  790493
  758563
  412572
  480329
  470530
  516743
  482929
  512576
  502678
  818193
  826258
  824385
  824518
  828852
  828707
  828568
  547195
  716433
  800167
  761631
  783167
  768931
  771347
  413255
  419583
  445440
  536105
  557988
  560095
  587856
  623440
  632920
  454742
  452897
  417945
  504069
  577160
  818111
  824629
  826039
  824474
  826049
  826457
  827056
  827248
  827374
  818337
  818350
  824209
  828148
  828484
  538238
  568019
  547109
  704969
  668739
  680583
  717035
  589113
  609601
  636218
  733659
  764047
  783807
  768920
  746367
  397591
  436642
  410739
  414155
  480853
  489881
  460056
  472749
  469427
  533858
  543743
  573493
  548095
  559474
  566867
  575357
  579236
]
2.92 ms
(0.74%)
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
  103649
  119798
  397591
  410739
  412572
  413255
  414155
  417945
  419583
  423463
  436642
  439870
  443502
  445440
  446259
  452897
  453857
  454689
  454742
  460056
  469427
  470530
  472749
  479973
  480329
  480853
  482929
  488791
  488793
  489881
  490649
  496400
  500570
  502678
  504069
  509517
  512576
  513161
  516743
  531032
  533858
  536105
  536146
  538238
  538781
  543187
  543743
  547109
  547195
  547247
  548095
  548752
  550466
  557988
  559462
  559474
  560095
  566867
  567411
  568019
  571311
  573493
  575357
  575700
  577160
  579236
  587376
  587856
  589113
  602113
  603015
  609601
  621183
  623440
  632920
  636218
  668739
  680583
  687841
  704969
  716433
  717035
  733650
  733659
  746367
  758563
  761631
  764047
  768920
  768931
  771347
  783167
  783807
  790493
  800167
  818111
  818193
  818337
  818350
  824209
  824385
  824474
  826049
  826258
  826457
  827056
  827248
  827374
  828148
  828362
  828510
  828568
  828707
  828732
  828852
]
2.02 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер худые"
]
1.85 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam skinny"
]
1.67 ms
(0.43%)
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.