Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
183.50 ms
(88.26%)
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
  7058
  154171
  281927
  325867
  382352
  383208
  384769
  390360
  390573
  392347
  393677
  396201
  397232
  397294
  402473
  402625
  403134
  403910
  413685
  415292
  423428
  427543
  453368
  469221
  476142
  477587
  478038
  493838
  497732
  510024
  510180
  512941
  513972
  514248
  517288
  526608
  530438
  530451
  530679
  531891
  533660
  534551
  537138
  537664
  544964
  547386
  547463
  547470
  550282
  550298
  561015
  564255
  605155
  609097
  614967
  615921
  619679
  630542
  634068
  642029
  648224
  648673
  649580
  651114
  660405
  664149
  664189
  664192
  665378
  665973
  668537
  669390
  670364
  671018
  671038
  672927
  672942
  674110
  686130
  694464
  696593
  698124
  708465
  711884
  713027
  713503
  713885
  716086
  716633
  717523
  719651
  720614
  722392
  725619
  738814
  738817
  738820
  738824
  738830
  741952
  742360
  742831
  742929
  744091
  748974
  748975
  750222
  752684
  752706
  770261
  777044
  786463
  788923
  790381
  791370
  796939
  805282
  814443
  817210
]
13.54 ms
(6.51%)
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
  750222
  711884
  537664
  514248
  390360
  698124
  453368
  427543
  648673
  469221
  630542
  530451
  564255
  713503
  738830
  530679
  738820
  742360
  738824
  817210
  790381
  7058
  670364
  742929
  716633
  392347
  402473
  534551
  537138
  671038
  672942
  614967
  725619
  748974
  547386
  403910
  716086
  547463
  791370
  281927
  669390
  530438
  478038
  396201
  564310
  672927
  686130
  713885
  717523
  664192
  671018
  752684
  788923
  805282
  665973
  713027
  642029
  748975
  796939
  719651
  397294
  390573
  660405
  615921
  752706
  476142
  674110
  415292
  383208
  777044
  605155
  497732
  493838
  397232
  770261
  531891
  325867
  708465
  649580
  533660
  668537
  526608
  393677
  402625
  510024
  547470
  814443
  664149
  544964
  550282
  561015
  651114
  664189
  742831
  744091
  154171
  634068
  694464
  513972
  738814
  517288
  648224
  738817
  512941
  550298
  477587
  510180
  619679
  786463
  609097
  720614
  741952
  423428
  384769
  722392
  382352
  413685
  665378
  696593
  403134
]
3.78 ms
(1.82%)
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
  7058
  154171
  281927
  325867
  382352
  383208
  384769
  390360
  390573
  392347
  393677
  396201
  397232
  397294
  402473
  402625
  403134
  403910
  413685
  415292
  423428
  427543
  453368
  469221
  476142
  477587
  478038
  493838
  497732
  510024
  510180
  512941
  513972
  514248
  517288
  526608
  530438
  530451
  530679
  531891
  533660
  534551
  537138
  537664
  544964
  547386
  547463
  547470
  550282
  550298
  561015
  564255
  605155
  609097
  614967
  615921
  619679
  630542
  634068
  642029
  648224
  648673
  649580
  651114
  660405
  664149
  664189
  664192
  665378
  665973
  668537
  669390
  670364
  671018
  671038
  672927
  672942
  674110
  686130
  694464
  696593
  698124
  708465
  711884
  713027
  713503
  713885
  716086
  716633
  717523
  719651
  720614
  722392
  725619
  738814
  738817
  738820
  738824
  738830
  741952
  742360
  742831
  742929
  744091
  748974
  748975
  750222
  752684
  752706
  770261
  777044
  786463
  788923
  790381
  791370
  796939
  805282
  814443
  817210
]
2.10 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жестко в анал большие%…"
]
1.99 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор анал большие"
]
1.35 ms
(0.65%)
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.