Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.87 ms
(87.12%)
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
  410234
  412662
  418707
  437294
  438401
  439488
  439632
  441210
  443548
  448076
  454296
  454403
  456366
  456572
  456688
  456859
  457192
  458148
  459176
  459178
  460462
  460531
  461324
  461722
  462701
  463108
  463216
  463984
  466527
  466551
  469846
  470233
  475338
  475371
  475514
  477673
  479254
  481791
  484078
  486625
  486691
  487470
  489553
  490000
  491387
  491874
  494576
  497652
  502614
  503805
  504853
  505443
  509945
  510617
  513458
  517345
  518587
  518771
  519021
  520983
  523088
  526801
  528620
  528879
  535353
  543356
  543757
  544064
  549175
  550052
  551194
  551632
  556072
  558884
  559480
  561615
  562369
  566347
  566996
  569012
  569471
  578129
  578132
  588033
  588710
  592730
  595026
  601893
  610582
  614142
  614244
  614380
  619785
  630024
  636481
  654671
  656123
  658894
  661882
  690373
  691244
  695929
  696121
  705787
  705801
  705804
  705814
  728281
  731528
  743079
  757548
  758268
  761479
  769867
  776426
  802711
  803469
  804765
  807308
  817641
]
14.47 ms
(7.84%)
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
  705787
  761479
  654671
  494576
  558884
  566996
  454296
  491387
  550052
  510617
  544064
  505443
  484078
  656123
  460462
  466551
  561615
  776426
  456688
  460531
  418707
  588033
  466527
  459178
  614244
  477673
  439488
  456859
  556072
  438401
  475371
  439632
  691244
  504853
  461324
  543356
  497652
  695929
  690373
  479254
  443548
  487470
  528879
  523088
  491874
  490000
  696121
  817641
  705804
  705814
  619785
  519021
  463108
  526801
  513458
  569471
  528620
  461722
  562369
  614380
  803469
  757548
  658894
  595026
  614142
  489553
  566347
  454403
  463216
  588710
  458148
  412662
  503805
  486691
  456572
  437294
  441210
  535353
  636481
  802711
  509945
  569012
  475514
  410234
  758268
  630024
  486625
  481791
  463984
  578132
  804765
  457192
  728281
  518587
  610582
  470233
  543757
  475338
  520983
  661882
  462701
  551632
  592730
  502614
  551194
  448076
  518771
  549175
  743079
  456366
  769867
  807308
  731528
  705801
  578129
  601893
  559480
  459176
  469846
  517345
]
2.15 ms
(1.17%)
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
  410234
  412662
  418707
  437294
  438401
  439488
  439632
  441210
  443548
  448076
  454296
  454403
  456366
  456572
  456688
  456859
  457192
  458148
  459176
  459178
  460462
  460531
  461324
  461722
  462701
  463108
  463216
  463984
  466527
  466551
  469846
  470233
  475338
  475371
  475514
  477673
  479254
  481791
  484078
  486625
  486691
  487470
  489553
  490000
  491387
  491874
  494576
  497652
  502614
  503805
  504853
  505443
  509945
  510617
  513458
  517345
  518587
  518771
  519021
  520983
  523088
  526801
  528620
  528879
  535353
  543356
  543757
  544064
  549175
  550052
  551194
  551632
  556072
  558884
  559480
  561615
  562369
  566347
  566996
  569012
  569471
  578129
  578132
  588033
  588710
  592730
  595026
  601893
  610582
  614142
  614244
  614380
  619785
  630024
  636481
  654671
  656123
  658894
  661882
  690373
  691244
  695929
  696121
  705787
  705801
  705804
  705814
  728281
  731528
  743079
  757548
  758268
  761479
  769867
  776426
  802711
  803469
  804765
  807308
  817641
]
1.95 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в лесу групповой миньет"
]
1.76 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в лес природ группов минет оральн секс"
]
1.73 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.93%)
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.