Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.12 ms
(86.06%)
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
  56632
  383388
  387409
  390176
  395506
  396447
  397564
  398947
  407995
  423940
  423943
  424404
  425505
  426715
  434091
  448314
  452211
  462763
  469214
  476438
  483589
  503546
  507241
  509516
  512566
  518003
  525507
  528452
  531150
  531570
  533657
  534255
  535550
  542764
  547698
  554321
  556450
  560070
  560699
  562542
  563076
  574833
  577048
  579886
  581760
  587103
  595588
  598049
  601438
  602960
  602964
  608177
  615516
  629387
  635977
  642048
  654230
  662436
  663293
  664658
  672369
  685916
  688997
  689565
  693935
  695820
  699534
  700028
  702966
  706000
  710389
  714323
  716192
  722360
  724086
  724740
  727399
  729612
  733022
  741035
  744261
  745305
  754434
  754843
  756958
  764028
  764190
  766180
  768548
  772991
  779330
  779435
  781907
  781928
  782305
  784520
  787064
  787360
  788586
  788882
  790171
  790319
  801760
  805163
  806291
  807649
  812679
  813198
  814704
  817889
  818368
  818661
  819362
  819614
  821193
  821395
  823630
  824870
  826028
  827648
]
13.74 ms
(8.44%)
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
  664658
  722360
  608177
  788586
  801760
  745305
  754434
  744261
  56632
  387409
  397564
  426715
  476438
  574833
  563076
  423940
  503546
  507241
  518003
  396447
  819362
  821395
  535550
  531150
  714323
  663293
  685916
  706000
  702966
  560070
  779330
  779435
  812679
  729612
  764028
  782305
  784520
  790171
  813198
  724086
  741035
  766180
  642048
  781907
  398947
  448314
  602964
  383388
  407995
  826028
  817889
  818661
  827648
  531570
  579886
  556450
  562542
  547698
  695820
  577048
  581760
  807649
  727399
  733022
  772991
  787360
  806291
  768548
  710389
  788882
  452211
  424404
  509516
  512566
  602960
  819614
  823630
  483589
  688997
  693935
  699534
  672369
  689565
  700028
  560699
  587103
  598049
  601438
  635977
  629387
  790319
  805163
  724740
  787064
  754843
  756958
  764190
  615516
  716192
  781928
  425505
  462763
  423943
  595588
  528452
  395506
  390176
  434091
  824870
  818368
  814704
  821193
  469214
  533657
  525507
  534255
  542764
  554321
  654230
  662436
]
2.66 ms
(1.63%)
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
  56632
  383388
  387409
  390176
  395506
  396447
  397564
  398947
  407995
  423940
  423943
  424404
  425505
  426715
  434091
  448314
  452211
  462763
  469214
  476438
  483589
  503546
  507241
  509516
  512566
  518003
  525507
  528452
  531150
  531570
  533657
  534255
  535550
  542764
  547698
  554321
  556450
  560070
  560699
  562542
  563076
  574833
  577048
  579886
  581760
  587103
  595588
  598049
  601438
  602960
  602964
  608177
  615516
  629387
  635977
  642048
  654230
  662436
  663293
  664658
  672369
  685916
  688997
  689565
  693935
  695820
  699534
  700028
  702966
  706000
  710389
  714323
  716192
  722360
  724086
  724740
  727399
  729612
  733022
  741035
  744261
  745305
  754434
  754843
  756958
  764028
  764190
  766180
  768548
  772991
  779330
  779435
  781907
  781928
  782305
  784520
  787064
  787360
  788586
  788882
  790171
  790319
  801760
  805163
  806291
  807649
  812679
  813198
  814704
  817889
  818368
  818661
  819362
  819614
  821193
  821395
  823630
  824870
  826028
  827648
]
1.76 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "рыжеволосая в туалете…"
]
1.59 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рыжая туалет"
]
1.42 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.