Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.16 ms
(84.50%)
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
  205
  160126
  319102
  382938
  383042
  386147
  386786
  387436
  388208
  389249
  389877
  392658
  393323
  398199
  403999
  410561
  418545
  479724
  486143
  493182
  530165
  531737
  533506
  533880
  537538
  542283
  544402
  546165
  564791
  567314
  603746
  604627
  605142
  609097
  615813
  618376
  621502
  624603
  642212
  648742
  650246
  652268
  666089
  666375
  670391
  676482
  687123
  689279
  697149
  697945
  698100
  712566
  712659
  715173
  716309
  718229
  722372
  727381
  729681
  729907
  738513
  739859
  740334
  741150
  742128
  742734
  743966
  744342
  745215
  746116
  747582
  748175
  749469
  754256
  754380
  754982
  766116
  770089
  771468
  774783
  780146
  780478
  782991
  787741
  789492
  789675
  799167
  800281
  801055
  802424
  802446
  802888
  804561
  805245
  809642
  810486
  813847
  816704
  817186
  817304
  817873
  818296
  818707
  819240
  819254
  821034
  821221
  821343
  822440
  822442
  822473
  822865
  822916
  824559
  826504
  827227
  827718
  828725
]
12.43 ms
(8.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
  715173
  718229
  392658
  387436
  729907
  754256
  382938
  817873
  821343
  826504
  827227
  827718
  819254
  821221
  817304
  821034
  828725
  486143
  530165
  531737
  537538
  533880
  546165
  542283
  697945
  666089
  698100
  722372
  642212
  618376
  603746
  605142
  621502
  787741
  800281
  804561
  810486
  774783
  801055
  740334
  746116
  749469
  771468
  805245
  729681
  727381
  738513
  741150
  744342
  386147
  383042
  160126
  567314
  687123
  666375
  742734
  809642
  403999
  386786
  393323
  388208
  418545
  712659
  670391
  789675
  742128
  780478
  802446
  205
  609097
  604627
  389877
  813847
  818707
  824559
  816704
  818296
  822865
  479724
  533506
  564791
  544402
  689279
  716309
  652268
  676482
  697149
  648742
  650246
  624603
  615813
  780146
  789492
  802888
  747582
  782991
  799167
  748175
  745215
  755279
  770089
  739859
  766116
  743966
  754380
  754982
  765910
  712566
  802424
  398199
  410561
  493182
  319102
  389249
  817186
  819240
  822440
  822442
  822473
  822916
]
2.89 ms
(2.02%)
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
  205
  160126
  319102
  382938
  383042
  386147
  386786
  387436
  388208
  389249
  389877
  392658
  393323
  398199
  403999
  410561
  418545
  479724
  486143
  493182
  530165
  531737
  533506
  533880
  537538
  542283
  544402
  546165
  564791
  567314
  603746
  604627
  605142
  609097
  615813
  618376
  621502
  624603
  642212
  648742
  650246
  652268
  666089
  666375
  670391
  676482
  687123
  689279
  697149
  697945
  698100
  712566
  712659
  715173
  716309
  718229
  722372
  727381
  729681
  729907
  738513
  739859
  740334
  741150
  742128
  742734
  743966
  744342
  745215
  746116
  747582
  748175
  749469
  754256
  754380
  754982
  766116
  770089
  771468
  774783
  780146
  780478
  782991
  787741
  789492
  789675
  799167
  800281
  801055
  802424
  802446
  802888
  804561
  805245
  809642
  810486
  813847
  816704
  817186
  817304
  817873
  818296
  818707
  819240
  819254
  821034
  821221
  821343
  822440
  822442
  822473
  822865
  822916
  824559
  826504
  827227
  827718
  828725
]
2.25 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "toys sex"
]
1.71 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "toys секс"
]
1.45 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "toys секс"
]

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.