Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.21 ms
(84.16%)
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
  403264
  418761
  428610
  432647
  437150
  437459
  437668
  438597
  438684
  441364
  447180
  449556
  449692
  450025
  452563
  453896
  453981
  454032
  459253
  460937
  463357
  463374
  463753
  463870
  464075
  472614
  473819
  475374
  476936
  479693
  480857
  488078
  488432
  489251
  493968
  496374
  498459
  502856
  503338
  503529
  504418
  507287
  507771
  512231
  513005
  516488
  516490
  516786
  517131
  517167
  517282
  518039
  523242
  526600
  526830
  527260
  533363
  536444
  541868
  546826
  555480
  557361
  558341
  563736
  563757
  564979
  569497
  578315
  578790
  579823
  585993
  586533
  593604
  607518
  610112
  612638
  616501
  621792
  623037
  623608
  624876
  644168
  645138
  654338
  655767
  676612
  682304
  683143
  687408
  691166
  693359
  693761
  693801
  693884
  694883
  695473
  696333
  697170
  700309
  703591
  714091
  714595
  720589
  725002
  742834
  756733
  757090
  758099
  758771
  759870
  773475
  784306
  788845
  793627
  800514
  803580
  817423
  818090
  825570
  826117
]
17.90 ms
(9.97%)
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
  644168
  788845
  793627
  725002
  757090
  784306
  800514
  803580
  756733
  758099
  759870
  742834
  773475
  463753
  403264
  460937
  498459
  607518
  450025
  452563
  516786
  493968
  526600
  507771
  517131
  533363
  475374
  463357
  504418
  593604
  463870
  459253
  463374
  536444
  517282
  586533
  610112
  437459
  449692
  496374
  428610
  432647
  454032
  507287
  513005
  523242
  517167
  563757
  557361
  578315
  555480
  578790
  654338
  612638
  624876
  758771
  480857
  437668
  476936
  438597
  438684
  441364
  502856
  512231
  516488
  488432
  503338
  526830
  453981
  564979
  418761
  473819
  447180
  453896
  464075
  449556
  516490
  437150
  826117
  817423
  818090
  825570
  472614
  489251
  503529
  518039
  527260
  479693
  488078
  558341
  579823
  563736
  541868
  694883
  697170
  703591
  714091
  720589
  655767
  676612
  682304
  683143
  691166
  693761
  693801
  695473
  700309
  714595
  645138
  687408
  693359
  693884
  696333
  546826
  569497
  623037
  585993
  616501
  621792
  623608
]
3.49 ms
(1.94%)
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
  403264
  418761
  428610
  432647
  437150
  437459
  437668
  438597
  438684
  441364
  447180
  449556
  449692
  450025
  452563
  453896
  453981
  454032
  459253
  460937
  463357
  463374
  463753
  463870
  464075
  472614
  473819
  475374
  476936
  479693
  480857
  488078
  488432
  489251
  493968
  496374
  498459
  502856
  503338
  503529
  504418
  507287
  507771
  512231
  513005
  516488
  516490
  516786
  517131
  517167
  517282
  518039
  523242
  526600
  526830
  527260
  533363
  536444
  541868
  546826
  555480
  557361
  558341
  563736
  563757
  564979
  569497
  578315
  578790
  579823
  585993
  586533
  593604
  607518
  610112
  612638
  616501
  621792
  623037
  623608
  624876
  644168
  645138
  654338
  655767
  676612
  682304
  683143
  687408
  691166
  693359
  693761
  693801
  693884
  694883
  695473
  696333
  697170
  700309
  703591
  714091
  714595
  720589
  725002
  742834
  756733
  757090
  758099
  758771
  759870
  773475
  784306
  788845
  793627
  800514
  803580
  817423
  818090
  825570
  826117
]
1.89 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie panties"
]
1.79 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie трусик нижн бел"
]
1.78 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie трусик нижн бел"
]

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.