Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.56 ms
(84.53%)
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
  393043
  393968
  395249
  397099
  397474
  398132
  408047
  410811
  420050
  420231
  421360
  422523
  422529
  422993
  423062
  423080
  423139
  423202
  423261
  423398
  427299
  429276
  429569
  431664
  432317
  435759
  435975
  444938
  445233
  446355
  446481
  451981
  451999
  452532
  456637
  459819
  462573
  471355
  472952
  473752
  473768
  473771
  476149
  484374
  497420
  499035
  499041
  506139
  510578
  510622
  512216
  513802
  515279
  515844
  516816
  521242
  527997
  535992
  537201
  538657
  540183
  540187
  541840
  542692
  546862
  547284
  550138
  550638
  550738
  550752
  551972
  554885
  556379
  558391
  559174
  559865
  559885
  562849
  565468
  565471
  565992
  568852
  574467
  574468
  575276
  581362
  583267
  583280
  585390
  587243
  590924
  594960
  597499
  597502
  598478
  600596
  600599
  600626
  600830
  603481
  605430
  618483
  622644
  623542
  628916
  647297
  649640
  658208
  658223
  658226
  688606
  718309
  730867
  730875
  734995
  735558
  741109
  748631
  757130
  768123
]
16.28 ms
(9.39%)
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
  597499
  600596
  600830
  550738
  398132
  423261
  432317
  444938
  421360
  429276
  435759
  456637
  451981
  497420
  510578
  538657
  558391
  559865
  551972
  575276
  565992
  574467
  550138
  583280
  618483
  423080
  431664
  422529
  445233
  471355
  473768
  420231
  423398
  459819
  446481
  515279
  512216
  410811
  559885
  583267
  513802
  516816
  535992
  562849
  587243
  600626
  603481
  451999
  565468
  550752
  734995
  537201
  395249
  649640
  420050
  748631
  397474
  521242
  540183
  554885
  581362
  547284
  574468
  622644
  473771
  422523
  393043
  435975
  423202
  452532
  462573
  446355
  540187
  506139
  499041
  472952
  546862
  556379
  658208
  718309
  658223
  658226
  688606
  559174
  590924
  597502
  757130
  730867
  730875
  768123
  476149
  397099
  423062
  408047
  429569
  473752
  527997
  484374
  541840
  427299
  565471
  393968
  422993
  499035
  510622
  542692
  600599
  585390
  605430
  594960
  741109
  423139
  647297
  568852
  515844
  598478
  623542
  735558
  628916
  550638
]
4.07 ms
(2.35%)
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
  393043
  393968
  395249
  397099
  397474
  398132
  408047
  410811
  420050
  420231
  421360
  422523
  422529
  422993
  423062
  423080
  423139
  423202
  423261
  423398
  427299
  429276
  429569
  431664
  432317
  435759
  435975
  444938
  445233
  446355
  446481
  451981
  451999
  452532
  456637
  459819
  462573
  471355
  472952
  473752
  473768
  473771
  476149
  484374
  497420
  499035
  499041
  506139
  510578
  510622
  512216
  513802
  515279
  515844
  516816
  521242
  527997
  535992
  537201
  538657
  540183
  540187
  541840
  542692
  546862
  547284
  550138
  550638
  550738
  550752
  551972
  554885
  556379
  558391
  559174
  559865
  559885
  562849
  565468
  565471
  565992
  568852
  574467
  574468
  575276
  581362
  583267
  583280
  585390
  587243
  590924
  594960
  597499
  597502
  598478
  600596
  600599
  600626
  600830
  603481
  605430
  618483
  622644
  623542
  628916
  647297
  649640
  658208
  658223
  658226
  688606
  718309
  730867
  730875
  734995
  735558
  741109
  748631
  757130
  768123
]
1.92 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худые маленькие азиатки"
]
1.53 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые маленькая азиатк"
]
1.51 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.87%)
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.