Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.51 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.14 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамки 30 анал"
]
3 17.45 ms
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
  487338
  445436
  382255
  819506
  476262
  667644
  705325
  798680
  810828
  803459
  784307
  419531
  408245
  386189
  411615
  500938
  469595
  607230
  395818
  466801
  474095
  488373
  424455
  465892
  480392
  408138
  521149
  424460
  424458
  466229
  454658
  439699
  439457
  474681
  421327
  815959
  452579
  682145
  441001
  439628
  796079
  400852
  470166
  466063
  466242
  531070
  816784
  826246
  482299
  554321
  801319
  789733
  737152
  421995
  484739
  466221
  400807
  472148
  474652
  470196
  465075
  428837
  801165
  724906
  392076
  825143
  469489
  486445
  476588
  665414
  412288
  439641
  439565
  535022
  422171
  478832
  486346
  187800
  720197
  490822
  387905
  466011
  416982
  413901
  639718
  758535
  401933
  404698
  483147
  470254
  439607
  449428
  474678
  493221
  484585
  484704
  486341
  497921
  407650
  428827
  425990
  412262
  517052
  717852
  712694
  784152
  405012
  398545
  409312
  476348
  466986
  718576
  563127
  591046
  728446
  472905
  405830
  526745
  388722
  479765
]
4 3.12 ms
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
  187800
  382255
  386189
  387905
  388722
  392076
  395818
  398545
  400807
  400852
  401933
  404698
  405012
  405830
  407650
  408138
  408245
  409312
  411615
  412262
  412288
  413901
  416982
  419531
  421327
  421995
  422171
  424455
  424458
  424460
  425990
  428827
  428837
  439457
  439565
  439607
  439628
  439641
  439699
  441001
  445436
  449428
  452579
  454658
  465075
  465892
  466011
  466063
  466221
  466229
  466242
  466801
  466986
  469489
  469595
  470166
  470196
  470254
  472148
  472905
  474095
  474652
  474678
  474681
  476262
  476348
  476588
  478832
  479765
  480392
  482299
  483147
  484585
  484704
  484739
  486341
  486346
  486445
  487338
  488373
  490822
  493221
  497921
  500938
  517052
  521149
  526745
  531070
  535022
  554321
  563127
  591046
  607230
  639718
  665414
  667644
  682145
  705325
  712694
  717852
  718576
  720197
  724906
  728446
  737152
  758535
  784152
  784307
  789733
  796079
  798680
  801165
  801319
  803459
  810828
  815959
  816784
  819506
  825143
  826246
]
5 175.17 ms
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
  187800
  382255
  386189
  387905
  388722
  392076
  395818
  398545
  400807
  400852
  401933
  404698
  405012
  405830
  407650
  408138
  408245
  409312
  411615
  412262
  412288
  413901
  416982
  419531
  421327
  421995
  422171
  424455
  424458
  424460
  425990
  428827
  428837
  439457
  439565
  439607
  439628
  439641
  439699
  441001
  445436
  449428
  452579
  454658
  465075
  465892
  466011
  466063
  466221
  466229
  466242
  466801
  466986
  469489
  469595
  470166
  470196
  470254
  472148
  472905
  474095
  474652
  474678
  474681
  476262
  476348
  476588
  478832
  479765
  480392
  482299
  483147
  484585
  484704
  484739
  486341
  486346
  486445
  487338
  488373
  490822
  493221
  497921
  500938
  517052
  521149
  526745
  531070
  535022
  554321
  563127
  591046
  607230
  639718
  665414
  667644
  682145
  705325
  712694
  717852
  718576
  720197
  724906
  728446
  737152
  758535
  784152
  784307
  789733
  796079
  798680
  801165
  801319
  803459
  810828
  815959
  816784
  819506
  825143
  826246
]
6 1.92 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин 30 анал"
]
7 1.60 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин 30 анал"
]

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.