Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.93 ms
(87.19%)
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
  386719
  387186
  389579
  390350
  390908
  395514
  401319
  401985
  408989
  418494
  425582
  426159
  426675
  428494
  431333
  432927
  433253
  437856
  441623
  443093
  446169
  447146
  447425
  447435
  447493
  448876
  456268
  461461
  464185
  464650
  466161
  472179
  473083
  473208
  473781
  475237
  476962
  487206
  490982
  492553
  494692
  506310
  516970
  521532
  527629
  531908
  532799
  532945
  536610
  545730
  555955
  556911
  560191
  565953
  574507
  575162
  578374
  579182
  580236
  591349
  591911
  591955
  595359
  600167
  600985
  603168
  603285
  603584
  609926
  613055
  622351
  622986
  630444
  640811
  644669
  646776
  653487
  678552
  679386
  693859
  701152
  718492
  719253
  719285
  720009
  721949
  724399
  727632
  727689
  736614
  737127
  746067
  746970
  747092
  747375
  748389
  751770
  753445
  753485
  753836
  753847
  753870
  754214
  766871
  767209
  767596
  769811
  769880
  770939
  777513
  779140
  780979
  780986
  781055
  787491
  789753
  790003
  800762
  801591
  811439
]
14.50 ms
(8.16%)
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
  678552
  679386
  720009
  591955
  622986
  591911
  630444
  777513
  781055
  779140
  780986
  789753
  800762
  811439
  727632
  747092
  753445
  753847
  753870
  754214
  767596
  770939
  787491
  766871
  769811
  769880
  736614
  751770
  724399
  727689
  747375
  753836
  753485
  718492
  719285
  780979
  387186
  390350
  401319
  386719
  437856
  447493
  560191
  613055
  622351
  603285
  389579
  693859
  701152
  801591
  790003
  746067
  767209
  746970
  719253
  390908
  408989
  395514
  536610
  646776
  600985
  603168
  737127
  748389
  425582
  428494
  521532
  506310
  640811
  721949
  401985
  426159
  433253
  441623
  443093
  432927
  532799
  532945
  531908
  556911
  565953
  578374
  555955
  575162
  580236
  653487
  603584
  591349
  600167
  595359
  609926
  456268
  473083
  475237
  426675
  446169
  476962
  418494
  447146
  447425
  447435
  448876
  473208
  464185
  527629
  490982
  492553
  487206
  472179
  545730
  574507
  579182
  644669
  466161
  461461
  464650
  473781
  431333
  516970
  494692
]
1.95 ms
(1.10%)
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
  386719
  387186
  389579
  390350
  390908
  395514
  401319
  401985
  408989
  418494
  425582
  426159
  426675
  428494
  431333
  432927
  433253
  437856
  441623
  443093
  446169
  447146
  447425
  447435
  447493
  448876
  456268
  461461
  464185
  464650
  466161
  472179
  473083
  473208
  473781
  475237
  476962
  487206
  490982
  492553
  494692
  506310
  516970
  521532
  527629
  531908
  532799
  532945
  536610
  545730
  555955
  556911
  560191
  565953
  574507
  575162
  578374
  579182
  580236
  591349
  591911
  591955
  595359
  600167
  600985
  603168
  603285
  603584
  609926
  613055
  622351
  622986
  630444
  640811
  644669
  646776
  653487
  678552
  679386
  693859
  701152
  718492
  719253
  719285
  720009
  721949
  724399
  727632
  727689
  736614
  737127
  746067
  746970
  747092
  747375
  748389
  751770
  753445
  753485
  753836
  753847
  753870
  754214
  766871
  767209
  767596
  769811
  769880
  770939
  777513
  779140
  780979
  780986
  781055
  787491
  789753
  790003
  800762
  801591
  811439
]
1.67 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen сиськ лиза"
]
1.56 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen tits licking"
]
1.51 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen сиськ лиза"
]

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.