Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.66 ms
(83.58%)
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
  47613
  123994
  308783
  365938
  382381
  386197
  389318
  390875
  391941
  396595
  398022
  399415
  400461
  402015
  409532
  411947
  416958
  417827
  422257
  422258
  424406
  427010
  430188
  430325
  430331
  444852
  448211
  448913
  450476
  454367
  456859
  457764
  460418
  465441
  470572
  470743
  470918
  471771
  471974
  474014
  476419
  478439
  482136
  484857
  495050
  498205
  501267
  504271
  506790
  510261
  510480
  527945
  533678
  540896
  543362
  543418
  543590
  544671
  544959
  548265
  548753
  548756
  548757
  548780
  551032
  551038
  551242
  552251
  557437
  557975
  557978
  558450
  562364
  562369
  578717
  581450
  585281
  589152
  591327
  595785
  603236
  603891
  605334
  614262
  622199
  623892
  625736
  631908
  640083
  648924
  651489
  661286
  667757
  668380
  670717
  676887
  677881
  686073
  687639
  690851
  692419
  703538
  707557
  710396
  718788
  720740
  722277
  723892
  731356
  742214
  752569
  766096
  766129
  768581
  775758
  775855
  806378
  809502
  810466
  827420
]
17.07 ms
(10.67%)
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
  482136
  622199
  809502
  710396
  806378
  411947
  422258
  430188
  510261
  548756
  631908
  474014
  544959
  495050
  723892
  768581
  386197
  365938
  558450
  551242
  775758
  417827
  692419
  648924
  548780
  548753
  623892
  391941
  308783
  557975
  670717
  589152
  591327
  731356
  416958
  506790
  400461
  552251
  562369
  614262
  742214
  47613
  382381
  470572
  543418
  471771
  448913
  430325
  543590
  687639
  544671
  595785
  422257
  444852
  578717
  430331
  533678
  543362
  581450
  676887
  718788
  668380
  625736
  603236
  640083
  470743
  427010
  504271
  123994
  396595
  703538
  409532
  557437
  562364
  456859
  667757
  766129
  720740
  677881
  707557
  690851
  752569
  390875
  540896
  484857
  389318
  398022
  399415
  510480
  686073
  827420
  460418
  557978
  661286
  722277
  548265
  548757
  551038
  603891
  775855
  476419
  470918
  450476
  448211
  465441
  527945
  424406
  454367
  471974
  810466
  478439
  501267
  551032
  651489
  585281
  766096
  498205
  402015
  457764
  605334
]
2.76 ms
(1.73%)
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
  47613
  123994
  308783
  365938
  382381
  386197
  389318
  390875
  391941
  396595
  398022
  399415
  400461
  402015
  409532
  411947
  416958
  417827
  422257
  422258
  424406
  427010
  430188
  430325
  430331
  444852
  448211
  448913
  450476
  454367
  456859
  457764
  460418
  465441
  470572
  470743
  470918
  471771
  471974
  474014
  476419
  478439
  482136
  484857
  495050
  498205
  501267
  504271
  506790
  510261
  510480
  527945
  533678
  540896
  543362
  543418
  543590
  544671
  544959
  548265
  548753
  548756
  548757
  548780
  551032
  551038
  551242
  552251
  557437
  557975
  557978
  558450
  562364
  562369
  578717
  581450
  585281
  589152
  591327
  595785
  603236
  603891
  605334
  614262
  622199
  623892
  625736
  631908
  640083
  648924
  651489
  661286
  667757
  668380
  670717
  676887
  677881
  686073
  687639
  690851
  692419
  703538
  707557
  710396
  718788
  720740
  722277
  723892
  731356
  742214
  752569
  766096
  766129
  768581
  775758
  775855
  806378
  809502
  810466
  827420
]
1.97 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебут толпой частное"
]
1.63 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс группов секс любительск"
]
1.48 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.85%)
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.