Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.97 ms
(85.80%)
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
  17058
  61726
  100642
  150798
  187928
  310679
  382885
  383237
  384540
  386403
  386630
  386665
  386717
  391659
  393108
  395278
  395724
  397095
  397353
  397882
  397977
  399632
  401480
  404185
  406361
  409942
  411813
  413112
  416258
  417389
  427203
  435054
  437256
  439214
  440932
  443901
  453833
  454278
  456156
  465392
  467955
  468102
  468697
  476180
  477070
  486253
  514814
  530452
  535053
  541568
  553757
  561002
  565347
  583882
  584068
  593606
  597898
  600283
  607254
  612419
  624409
  630399
  634563
  637010
  639293
  643329
  644315
  644974
  649105
  663510
  671579
  693356
  694062
  706331
  708817
  719022
  719025
  726922
  728443
  731360
  731772
  731834
  733071
  739460
  740773
  742452
  744593
  744632
  746682
  746819
  755341
  761502
  764351
  766668
  766690
  767257
  767279
  769904
  776204
  778889
  782428
  788131
  788650
  789540
  792656
  797863
  800852
  803673
  803919
  804995
  805784
  810839
  811474
  812965
  815137
  815804
  817054
  823408
  826127
  828535
]
16.19 ms
(8.47%)
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
  409942
  817054
  823408
  719022
  639293
  812965
  746819
  788131
  767279
  630399
  395278
  397882
  435054
  612419
  742452
  404185
  427203
  477070
  693356
  397095
  553757
  624409
  800852
  761502
  767257
  731834
  746682
  792656
  565347
  634563
  637010
  382885
  61726
  535053
  584068
  776204
  386717
  100642
  393108
  395724
  401480
  406361
  416258
  413112
  443901
  465392
  671579
  804995
  744632
  150798
  454278
  391659
  411813
  644974
  815137
  456156
  649105
  719025
  708817
  600283
  644315
  797863
  789540
  803673
  731360
  766668
  726922
  744593
  755341
  769904
  739460
  728443
  766690
  782428
  788650
  397353
  187928
  514814
  439214
  486253
  803919
  733071
  810839
  384540
  815804
  826127
  828535
  597898
  731772
  386665
  386630
  805784
  740773
  764351
  811474
  467955
  468697
  530452
  437256
  694062
  643329
  397977
  17058
  476180
  663510
  706331
  593606
  778889
  383237
  310679
  386403
  399632
  417389
  440932
  468102
  453833
  583882
  561002
  541568
  607254
]
3.27 ms
(1.71%)
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
  17058
  61726
  100642
  150798
  187928
  310679
  382885
  383237
  384540
  386403
  386630
  386665
  386717
  391659
  393108
  395278
  395724
  397095
  397353
  397882
  397977
  399632
  401480
  404185
  406361
  409942
  411813
  413112
  416258
  417389
  427203
  435054
  437256
  439214
  440932
  443901
  453833
  454278
  456156
  465392
  467955
  468102
  468697
  476180
  477070
  486253
  514814
  530452
  535053
  541568
  553757
  561002
  565347
  583882
  584068
  593606
  597898
  600283
  607254
  612419
  624409
  630399
  634563
  637010
  639293
  643329
  644315
  644974
  649105
  663510
  671579
  693356
  694062
  706331
  708817
  719022
  719025
  726922
  728443
  731360
  731772
  731834
  733071
  739460
  740773
  742452
  744593
  744632
  746682
  746819
  755341
  761502
  764351
  766668
  766690
  767257
  767279
  769904
  776204
  778889
  782428
  788131
  788650
  789540
  792656
  797863
  800852
  803673
  803919
  804995
  805784
  810839
  811474
  812965
  815137
  815804
  817054
  823408
  826127
  828535
]
2.24 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex boobs anal"
]
1.91 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс boobs анал"
]
1.79 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс boobs анал"
]

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.