Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.79 ms
(82.56%)
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
  12900
  358592
  390351
  391588
  397892
  398969
  409938
  411349
  411353
  411354
  411409
  411419
  439715
  443334
  443756
  443771
  443772
  443782
  443788
  454080
  454156
  454179
  454222
  454244
  454555
  454563
  460887
  460925
  462305
  465338
  465399
  466001
  466025
  466026
  466111
  466133
  466147
  466215
  466318
  467008
  469427
  470018
  470254
  473249
  474481
  474629
  474648
  476285
  477717
  477730
  477927
  477983
  479028
  479032
  479047
  479073
  479078
  479080
  479099
  482322
  484564
  484586
  484625
  484735
  484746
  485392
  486345
  491153
  491950
  506042
  506210
  509488
  509995
  510775
  513399
  515726
  520860
  520899
  526002
  526738
  526745
  526747
  526837
  533609
  546950
  549799
  557993
  558020
  559061
  561991
  563144
  567420
  579613
  580640
  582583
  601869
  609268
  609274
  614701
  619522
  624821
  625036
  721467
  731137
  758118
  762669
  781648
  781679
  781734
  781743
  781761
  782154
  794679
  794698
  794830
  796459
  803522
  808541
  823847
  824584
]
17.94 ms
(10.30%)
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
  398969
  443772
  520899
  491153
  479032
  454555
  479080
  477983
  466025
  506210
  476285
  454156
  474629
  454563
  466001
  796459
  485392
  469427
  409938
  439715
  559061
  823847
  411353
  390351
  479073
  482322
  411354
  443782
  484564
  484586
  509995
  466026
  474648
  443756
  465338
  526002
  782154
  794679
  808541
  762669
  466318
  549799
  443334
  477730
  824584
  721467
  609274
  609268
  794830
  781761
  803522
  625036
  460925
  477717
  567420
  619522
  443788
  467008
  473249
  454244
  479099
  454179
  474481
  526738
  484735
  397892
  358592
  513399
  460887
  466215
  454080
  462305
  466111
  470254
  466133
  506042
  515726
  477927
  526837
  601869
  781743
  781648
  533609
  781734
  479028
  491950
  794698
  731137
  781679
  443771
  484746
  758118
  466147
  579613
  614701
  624821
  391588
  470018
  12900
  465399
  479047
  479078
  484625
  526745
  486345
  580640
  526747
  411419
  510775
  520860
  509488
  563144
  582583
  558020
  557993
  546950
  561991
  411409
  411349
  454222
]
4.28 ms
(2.46%)
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
  12900
  358592
  390351
  391588
  397892
  398969
  409938
  411349
  411353
  411354
  411409
  411419
  439715
  443334
  443756
  443771
  443772
  443782
  443788
  454080
  454156
  454179
  454222
  454244
  454555
  454563
  460887
  460925
  462305
  465338
  465399
  466001
  466025
  466026
  466111
  466133
  466147
  466215
  466318
  467008
  469427
  470018
  470254
  473249
  474481
  474629
  474648
  476285
  477717
  477730
  477927
  477983
  479028
  479032
  479047
  479073
  479078
  479080
  479099
  482322
  484564
  484586
  484625
  484735
  484746
  485392
  486345
  491153
  491950
  506042
  506210
  509488
  509995
  510775
  513399
  515726
  520860
  520899
  526002
  526738
  526745
  526747
  526837
  533609
  546950
  549799
  557993
  558020
  559061
  561991
  563144
  567420
  579613
  580640
  582583
  601869
  609268
  609274
  614701
  619522
  624821
  625036
  721467
  731137
  758118
  762669
  781648
  781679
  781734
  781743
  781761
  782154
  794679
  794698
  794830
  796459
  803522
  808541
  823847
  824584
]
2.45 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mature сиськ"
]
2.07 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mature tits"
]
1.87 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск mature сиськ"
]

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.