Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.02 ms
(86.36%)
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
  17058
  398715
  399323
  409088
  413738
  415527
  416315
  416428
  420607
  423736
  423748
  427699
  430379
  431215
  438410
  447381
  448598
  449523
  451875
  462224
  463012
  465193
  466568
  472214
  472629
  473351
  474740
  477082
  479780
  480134
  480190
  483683
  483686
  485258
  487786
  496703
  498363
  499369
  499433
  512015
  517566
  523394
  523927
  525373
  529254
  533166
  544791
  545533
  546280
  546308
  553817
  571374
  572261
  575719
  578093
  584927
  585198
  585417
  586135
  588293
  589256
  589263
  601325
  601488
  607244
  620180
  622472
  625637
  629890
  636063
  638770
  638887
  640895
  641074
  645520
  649487
  676241
  676769
  684970
  689012
  693291
  693643
  707592
  712930
  714474
  718835
  724286
  730867
  730872
  731620
  735091
  741283
  745345
  752964
  762914
  770497
  770532
  778383
  780121
  780128
  784657
  784980
  786197
  787406
  789637
  792062
  793121
  796236
  796943
  797764
  805264
  807569
  807621
  809410
  809794
  811080
  811387
  811999
  815444
  823092
]
14.98 ms
(7.74%)
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
  512015
  797764
  805264
  718835
  499433
  676769
  584927
  789637
  416428
  712930
  585198
  638770
  770532
  811999
  693643
  823092
  472629
  815444
  676241
  778383
  770497
  762914
  731620
  398715
  545533
  413738
  483683
  792062
  638887
  523927
  17058
  730872
  544791
  786197
  588293
  438410
  399323
  684970
  735091
  807621
  466568
  499369
  714474
  529254
  578093
  589263
  784980
  796236
  724286
  423748
  420607
  640895
  449523
  546308
  689012
  496703
  423736
  586135
  780121
  807569
  809794
  620180
  553817
  693291
  447381
  809410
  607244
  480134
  572261
  730867
  463012
  462224
  796943
  431215
  575719
  415527
  546280
  636063
  601488
  780128
  752964
  629890
  641074
  707592
  416315
  427699
  409088
  811387
  474740
  811080
  525373
  483686
  498363
  451875
  448598
  487786
  645520
  649487
  571374
  793121
  787406
  533166
  784657
  477082
  601325
  585417
  741283
  622472
  625637
  430379
  479780
  589256
  480190
  472214
  473351
  485258
  465193
  523394
  745345
  517566
]
2.75 ms
(1.42%)
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
  17058
  398715
  399323
  409088
  413738
  415527
  416315
  416428
  420607
  423736
  423748
  427699
  430379
  431215
  438410
  447381
  448598
  449523
  451875
  462224
  463012
  465193
  466568
  472214
  472629
  473351
  474740
  477082
  479780
  480134
  480190
  483683
  483686
  485258
  487786
  496703
  498363
  499369
  499433
  512015
  517566
  523394
  523927
  525373
  529254
  533166
  544791
  545533
  546280
  546308
  553817
  571374
  572261
  575719
  578093
  584927
  585198
  585417
  586135
  588293
  589256
  589263
  601325
  601488
  607244
  620180
  622472
  625637
  629890
  636063
  638770
  638887
  640895
  641074
  645520
  649487
  676241
  676769
  684970
  689012
  693291
  693643
  707592
  712930
  714474
  718835
  724286
  730867
  730872
  731620
  735091
  741283
  745345
  752964
  762914
  770497
  770532
  778383
  780121
  780128
  784657
  784980
  786197
  787406
  789637
  792062
  793121
  796236
  796943
  797764
  805264
  807569
  807621
  809410
  809794
  811080
  811387
  811999
  815444
  823092
]
2.61 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.30 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fit big tits"
]
1.93 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fit большие сиськ"
]
1.80 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fit большие сиськ"
]

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.