Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.44 ms
(86.69%)
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
  382946
  393726
  407415
  416296
  421623
  422495
  425877
  428998
  436080
  438911
  443120
  443867
  444239
  444546
  447910
  454173
  454265
  455258
  456178
  457514
  458235
  458651
  459552
  459664
  460122
  460718
  461321
  461446
  461769
  461782
  461973
  463180
  466098
  467299
  469853
  471992
  474208
  475610
  476536
  479485
  480955
  483615
  484329
  485600
  487077
  487080
  489047
  491047
  492075
  493009
  493153
  498879
  501185
  501523
  505166
  505762
  506719
  508041
  508255
  509283
  510635
  510660
  511740
  512759
  521639
  521981
  524155
  524719
  525212
  526247
  528490
  528664
  530116
  546698
  548263
  549559
  549777
  550464
  550466
  551158
  551639
  552115
  552186
  552423
  552518
  552813
  554946
  558824
  558876
  561984
  562235
  570051
  570370
  571630
  571654
  573951
  573962
  576411
  579223
  584867
  595403
  597502
  598020
  598960
  599462
  614983
  674910
  674954
  689830
  746087
  762169
  767399
  771572
  779001
  780273
  782756
  786420
  787906
  790412
  809979
]
17.99 ms
(7.98%)
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
  436080
  444546
  456178
  476536
  512759
  521981
  525212
  571630
  546698
  570370
  674910
  689830
  598960
  771572
  790412
  421623
  461446
  416296
  579223
  674954
  614983
  438911
  459664
  461321
  552115
  551639
  558824
  576411
  552518
  584867
  552423
  562235
  382946
  428998
  471992
  458651
  393726
  425877
  469853
  479485
  480955
  475610
  501523
  521639
  528664
  492075
  524719
  487077
  487080
  501185
  458235
  549777
  598020
  447910
  454265
  443120
  466098
  809979
  407415
  498879
  550466
  549559
  550464
  552186
  554946
  599462
  779001
  782756
  746087
  767399
  780273
  787906
  454173
  460122
  489047
  508041
  510660
  570051
  474208
  457514
  455258
  484329
  505166
  459552
  460718
  558876
  573962
  551158
  552813
  571654
  548263
  561984
  595403
  597502
  461973
  422495
  463180
  467299
  443867
  444239
  461769
  461782
  509283
  510635
  528490
  485600
  483615
  493009
  493153
  508255
  511740
  524155
  526247
  491047
  505762
  506719
  530116
  573951
  762169
  786420
]
4.62 ms
(2.05%)
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
  382946
  393726
  407415
  416296
  421623
  422495
  425877
  428998
  436080
  438911
  443120
  443867
  444239
  444546
  447910
  454173
  454265
  455258
  456178
  457514
  458235
  458651
  459552
  459664
  460122
  460718
  461321
  461446
  461769
  461782
  461973
  463180
  466098
  467299
  469853
  471992
  474208
  475610
  476536
  479485
  480955
  483615
  484329
  485600
  487077
  487080
  489047
  491047
  492075
  493009
  493153
  498879
  501185
  501523
  505166
  505762
  506719
  508041
  508255
  509283
  510635
  510660
  511740
  512759
  521639
  521981
  524155
  524719
  525212
  526247
  528490
  528664
  530116
  546698
  548263
  549559
  549777
  550464
  550466
  551158
  551639
  552115
  552186
  552423
  552518
  552813
  554946
  558824
  558876
  561984
  562235
  570051
  570370
  571630
  571654
  573951
  573962
  576411
  579223
  584867
  595403
  597502
  598020
  598960
  599462
  614983
  674910
  674954
  689830
  746087
  762169
  767399
  771572
  779001
  780273
  782756
  786420
  787906
  790412
  809979
]
2.06 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс студентк русск"
]
1.80 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐüðÁð║Ðü ÐüÐéÐâð┤ðÁð¢Ðéð║ð© ÐÇÐâÐüÐüð║ðÔǪ"
]
1.78 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс студентк русск"
]
1.75 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.