Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.26 ms
(86.29%)
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
  386589
  391455
  391949
  392077
  392493
  400698
  401992
  403027
  408429
  413053
  414277
  414646
  417940
  418868
  418998
  419245
  423314
  438613
  439488
  439526
  439650
  443762
  450515
  452847
  456610
  458025
  462523
  463169
  464307
  465237
  465786
  465794
  470633
  470716
  473038
  474626
  486821
  491748
  503870
  503955
  504303
  511836
  516401
  516618
  519319
  519322
  520170
  520748
  521377
  523903
  526139
  527765
  537026
  539317
  542941
  544206
  546654
  550505
  550507
  554017
  566267
  566599
  569453
  584295
  603838
  604732
  614330
  617259
  618645
  623874
  630395
  648093
  660787
  666416
  675182
  679262
  692913
  693023
  696218
  701000
  701206
  701344
  712955
  714840
  717289
  723927
  728675
  733138
  741268
  744171
  747171
  747501
  747687
  751680
  751708
  757278
  761161
  763522
  771903
  777489
  779561
  780363
  781259
  784500
  786671
  787309
  787875
  790349
  797462
  800373
  806680
  807301
  810816
  813314
  817076
  823367
  823575
  825133
  826713
]
15.58 ms
(8.19%)
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
  787875
  723927
  747687
  733138
  763522
  439650
  463169
  474626
  470633
  464307
  519322
  526139
  503955
  520748
  817076
  401992
  648093
  465794
  537026
  516401
  391455
  418998
  807301
  418868
  439488
  414646
  386589
  391949
  423314
  554017
  566267
  679262
  666416
  692913
  712955
  660787
  675182
  584295
  603838
  630395
  741268
  744171
  617259
  400698
  823575
  790349
  784500
  810816
  728675
  786671
  408429
  452847
  473038
  566599
  413053
  414277
  456610
  539317
  757278
  701000
  419245
  458025
  450515
  491748
  521377
  527765
  511836
  542941
  544206
  546654
  550505
  550507
  569453
  696218
  693023
  714840
  701206
  618645
  623874
  604732
  787309
  797462
  800373
  417940
  465237
  462523
  465786
  439526
  443762
  470716
  503870
  516618
  486821
  504303
  519319
  520170
  523903
  392077
  392493
  826713
  823367
  825133
  532226
  701344
  717289
  614330
  780363
  781259
  806680
  747171
  751680
  751708
  761161
  747501
  771903
  777489
  779561
  813314
  403027
  438613
]
3.66 ms
(1.92%)
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
  386589
  391455
  391949
  392077
  392493
  400698
  401992
  403027
  408429
  413053
  414277
  414646
  417940
  418868
  418998
  419245
  423314
  438613
  439488
  439526
  439650
  443762
  450515
  452847
  456610
  458025
  462523
  463169
  464307
  465237
  465786
  465794
  470633
  470716
  473038
  474626
  486821
  491748
  503870
  503955
  504303
  511836
  516401
  516618
  519319
  519322
  520170
  520748
  521377
  523903
  526139
  527765
  537026
  539317
  542941
  544206
  546654
  550505
  550507
  554017
  566267
  566599
  569453
  584295
  603838
  604732
  614330
  617259
  618645
  623874
  630395
  648093
  660787
  666416
  675182
  679262
  692913
  693023
  696218
  701000
  701206
  701344
  712955
  714840
  717289
  723927
  728675
  733138
  741268
  744171
  747171
  747501
  747687
  751680
  751708
  757278
  761161
  763522
  771903
  777489
  779561
  780363
  781259
  784500
  786671
  787309
  787875
  790349
  797462
  800373
  806680
  807301
  810816
  813314
  817076
  823367
  823575
  825133
  826713
]
1.89 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young webcam amateur"
]
1.70 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young вебкамер любительск"
]
1.48 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young вебкамер любительск"
]

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.