Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.05 ms
(56.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bdsm girl"
]
137.03 ms
(36.93%)
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
  246261
  384058
  384302
  385119
  414212
  421448
  422847
  427388
  428532
  428726
  429278
  441838
  456215
  463915
  467684
  470141
  470580
  471935
  472350
  477036
  479345
  488337
  489977
  491814
  493194
  493275
  494999
  495066
  500122
  500146
  500311
  502240
  502464
  505575
  511600
  516618
  518628
  521214
  522412
  523498
  525957
  527909
  531247
  532508
  532965
  533984
  537577
  544358
  544939
  546833
  546843
  548253
  550051
  550068
  550768
  551049
  551147
  554002
  555248
  558620
  559667
  559856
  561085
  563853
  565304
  569722
  569727
  574863
  575115
  575343
  575451
  575791
  576901
  579547
  579981
  580664
  585617
  588359
  593108
  598524
  600111
  603999
  605523
  606636
  610726
  627730
  630801
  649996
  665900
  683897
  701389
  704979
  707439
  713983
  715421
  726503
  728540
  740656
  746472
  752545
  754423
  754805
  755512
  758125
  763297
  764155
  765796
  769067
  775414
  780533
  789970
  790112
  797110
  802927
  817015
  817092
  817195
  818964
  821845
]
16.22 ms
(4.37%)
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
  548253
  576901
  546833
  546843
  551049
  606636
  626851
  600111
  588359
  775414
  427388
  428532
  477036
  471935
  470580
  500122
  500146
  493275
  441838
  429278
  488337
  500311
  550068
  569722
  579547
  554002
  603999
  630801
  726503
  728540
  479345
  532508
  522412
  531247
  384058
  817092
  817195
  533984
  537577
  565304
  559667
  575343
  585617
  593108
  790112
  780533
  763297
  764155
  758125
  384302
  817015
  818964
  502240
  544939
  544358
  561085
  715421
  649996
  683897
  769067
  754805
  746472
  752545
  754423
  789970
  414212
  422847
  456215
  575451
  558620
  574863
  550768
  516618
  511600
  489977
  755512
  550051
  385119
  246261
  821845
  555248
  563853
  569727
  713983
  701389
  704979
  707439
  740656
  765796
  610726
  802927
  428726
  463915
  495066
  502464
  518628
  532965
  579981
  551147
  559856
  797110
  470141
  421448
  467684
  472350
  505575
  525957
  494999
  523498
  527909
  575115
  575791
  493194
  598524
  627730
  521214
  491814
  580664
  665900
  605523
]
3.76 ms
(1.01%)
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
  246261
  384058
  384302
  385119
  414212
  421448
  422847
  427388
  428532
  428726
  429278
  441838
  456215
  463915
  467684
  470141
  470580
  471935
  472350
  477036
  479345
  488337
  489977
  491814
  493194
  493275
  494999
  495066
  500122
  500146
  500311
  502240
  502464
  505575
  511600
  516618
  518628
  521214
  522412
  523498
  525957
  527909
  531247
  532508
  532965
  533984
  537577
  544358
  544939
  546833
  546843
  548253
  550051
  550068
  550768
  551049
  551147
  554002
  555248
  558620
  559667
  559856
  561085
  563853
  565304
  569722
  569727
  574863
  575115
  575343
  575451
  575791
  576901
  579547
  579981
  580664
  585617
  588359
  593108
  598524
  600111
  603999
  605523
  606636
  610726
  627730
  630801
  649996
  665900
  683897
  701389
  704979
  707439
  713983
  715421
  726503
  728540
  740656
  746472
  752545
  754423
  754805
  755512
  758125
  763297
  764155
  765796
  769067
  775414
  780533
  789970
  790112
  797110
  802927
  817015
  817092
  817195
  818964
  821845
]
1.75 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм девушк"
]
1.53 ms
(0.41%)
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.