Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.81 ms
(89.76%)
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
  383315
  390212
  392989
  401398
  411445
  418268
  420427
  424038
  424528
  425962
  427142
  427344
  431077
  438934
  441109
  443778
  444845
  444848
  449255
  449312
  449384
  452255
  456981
  458698
  459136
  462612
  465477
  465957
  466261
  467220
  467963
  468885
  469424
  472173
  474020
  490905
  492779
  494702
  498240
  501179
  507533
  516633
  516839
  520005
  521372
  521409
  523873
  524179
  526148
  530378
  532419
  533468
  533539
  548596
  556636
  556808
  560651
  561755
  562604
  564369
  565167
  581501
  591647
  591755
  601393
  613819
  614745
  617107
  618708
  625524
  629347
  629673
  639752
  639982
  642407
  650313
  651148
  660692
  675055
  675062
  675071
  675084
  675110
  675145
  675726
  683054
  710869
  728096
  730396
  733259
  734363
  738813
  753223
  753544
  761247
  777128
  780193
  789779
  790698
  792230
  792245
  792339
  794581
  796448
  801584
  801670
  803963
  808518
  812313
  813353
  814765
  816001
  816168
  817610
  818445
  820041
  824814
  824905
  826770
  828449
]
14.53 ms
(6.19%)
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
  431077
  498240
  526148
  456981
  467963
  523873
  490905
  458698
  618708
  639752
  466261
  449384
  474020
  472173
  591755
  411445
  467220
  565167
  501179
  465957
  444845
  521409
  438934
  532419
  625524
  459136
  507533
  651148
  530378
  427344
  420427
  452255
  492779
  516839
  556636
  494702
  650313
  556808
  613819
  520005
  469424
  548596
  601393
  560651
  533468
  816168
  614745
  642407
  591647
  465477
  683054
  521372
  561755
  792230
  462612
  424528
  444848
  789779
  828449
  796448
  617107
  533539
  516633
  675055
  728096
  418268
  401398
  792339
  780193
  733259
  639982
  826770
  449312
  675062
  730396
  710869
  808518
  427142
  441109
  824905
  383315
  524179
  564369
  443778
  818445
  824814
  753223
  777128
  817610
  812313
  734363
  794581
  675726
  801584
  813353
  675110
  468885
  392989
  675071
  390212
  449255
  581501
  629673
  801670
  629347
  790698
  816001
  660692
  803963
  738813
  753544
  675145
  820041
  792245
  424038
  562604
  675084
  814765
  761247
  425962
]
2.64 ms
(1.12%)
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
  383315
  390212
  392989
  401398
  411445
  418268
  420427
  424038
  424528
  425962
  427142
  427344
  431077
  438934
  441109
  443778
  444845
  444848
  449255
  449312
  449384
  452255
  456981
  458698
  459136
  462612
  465477
  465957
  466261
  467220
  467963
  468885
  469424
  472173
  474020
  490905
  492779
  494702
  498240
  501179
  507533
  516633
  516839
  520005
  521372
  521409
  523873
  524179
  526148
  530378
  532419
  533468
  533539
  548596
  556636
  556808
  560651
  561755
  562604
  564369
  565167
  581501
  591647
  591755
  601393
  613819
  614745
  617107
  618708
  625524
  629347
  629673
  639752
  639982
  642407
  650313
  651148
  660692
  675055
  675062
  675071
  675084
  675110
  675145
  675726
  683054
  710869
  728096
  730396
  733259
  734363
  738813
  753223
  753544
  761247
  777128
  780193
  789779
  790698
  792230
  792245
  792339
  794581
  796448
  801584
  801670
  803963
  808518
  812313
  813353
  814765
  816001
  816168
  817610
  818445
  820041
  824814
  824905
  826770
  828449
]
1.99 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза трусик нижн бел"
]
1.88 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "lick panties"
]
1.52 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза трусик нижн бел"
]
1.48 ms
(0.63%)
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.