Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
234.02 ms
(88.88%)
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
  10035
  53477
  76074
  385790
  396626
  405151
  411182
  411813
  412474
  415511
  415871
  417720
  417735
  417737
  426386
  427555
  427967
  428996
  436304
  445804
  451755
  454960
  456098
  457291
  457671
  458929
  459864
  460479
  462915
  464212
  465158
  466602
  466603
  466611
  466612
  468498
  468688
  468778
  473009
  474604
  474657
  483708
  484449
  484457
  484461
  484789
  486509
  486883
  495367
  498456
  503220
  510205
  511898
  513280
  513773
  513989
  514747
  522004
  523923
  526896
  527753
  530128
  533747
  533783
  540483
  545153
  550403
  553090
  557180
  564306
  566057
  566903
  571212
  575711
  577334
  579370
  582766
  590413
  598672
  603004
  605301
  605323
  608386
  621421
  622025
  634543
  639305
  645810
  655296
  664105
  670412
  671392
  689582
  690761
  693295
  705365
  705465
  712520
  713083
  718283
  719897
  721455
  721457
  726833
  730094
  730570
  730655
  735995
  741885
  745411
  757950
  767301
  773533
  774154
  784961
  793753
  795488
  800558
  809174
  819677
]
17.65 ms
(6.70%)
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
  458929
  468688
  10035
  460479
  412474
  553090
  705365
  571212
  484461
  466602
  459864
  510205
  486883
  465158
  511898
  605301
  634543
  527753
  473009
  503220
  495367
  693295
  721455
  466603
  417737
  670412
  639305
  757950
  730655
  741885
  767301
  385790
  622025
  415511
  533783
  566903
  689582
  466611
  426386
  726833
  513773
  540483
  427555
  474604
  486509
  603004
  411813
  466612
  474657
  445804
  484449
  514747
  718283
  745411
  705465
  730094
  719897
  468778
  411182
  513989
  523923
  564306
  545153
  526896
  513280
  484457
  793753
  773533
  621421
  713083
  690761
  712520
  645810
  721457
  582766
  735995
  795488
  774154
  730570
  427967
  457291
  605323
  456098
  590413
  498456
  557180
  530128
  655296
  664105
  608386
  809174
  800558
  464212
  457671
  598672
  53477
  396626
  405151
  417720
  415871
  819677
  522004
  484789
  671392
  550403
  577334
  784961
  76074
  454960
  468498
  428996
  483708
  533747
  417735
  462915
  436304
  451755
  575711
  579370
  566057
]
4.08 ms
(1.55%)
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
  10035
  53477
  76074
  385790
  396626
  405151
  411182
  411813
  412474
  415511
  415871
  417720
  417735
  417737
  426386
  427555
  427967
  428996
  436304
  445804
  451755
  454960
  456098
  457291
  457671
  458929
  459864
  460479
  462915
  464212
  465158
  466602
  466603
  466611
  466612
  468498
  468688
  468778
  473009
  474604
  474657
  483708
  484449
  484457
  484461
  484789
  486509
  486883
  495367
  498456
  503220
  510205
  511898
  513280
  513773
  513989
  514747
  522004
  523923
  526896
  527753
  530128
  533747
  533783
  540483
  545153
  550403
  553090
  557180
  564306
  566057
  566903
  571212
  575711
  577334
  579370
  582766
  590413
  598672
  603004
  605301
  605323
  608386
  621421
  622025
  634543
  639305
  645810
  655296
  664105
  670412
  671392
  689582
  690761
  693295
  705365
  705465
  712520
  713083
  718283
  719897
  721455
  721457
  726833
  730094
  730570
  730655
  735995
  741885
  745411
  757950
  767301
  773533
  774154
  784961
  793753
  795488
  800558
  809174
  819677
]
2.11 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс кастинг"
]
1.98 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс кастинг"
]
1.62 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob casting"
]

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.