Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.79 ms
(88.60%)
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
  35091
  45868
  45985
  88220
  310725
  382074
  382462
  382465
  382898
  383455
  384521
  387146
  393108
  395398
  395653
  395699
  396312
  397161
  399187
  399632
  401251
  401541
  402047
  402530
  406847
  406957
  406969
  407890
  408414
  409125
  409224
  414753
  415889
  418135
  419838
  419892
  420262
  423319
  424548
  425630
  429739
  430245
  438009
  442236
  442296
  445046
  452921
  457816
  463826
  465673
  466457
  468155
  468800
  472180
  476206
  481659
  484969
  490166
  490826
  493265
  504155
  504339
  508236
  509164
  510589
  518814
  519570
  520633
  521024
  522200
  528394
  529654
  531521
  534260
  537165
  539644
  562881
  567743
  568062
  569035
  570730
  598550
  602363
  607289
  619490
  623945
  634876
  673987
  681122
  683066
  684198
  696140
  702819
  721778
  723592
  726236
  730235
  730977
  737522
  744642
  744860
  752864
  753007
  754598
  756239
  760684
  760800
  768606
  770031
  774736
  774738
  781464
  785094
  787073
  789705
  790028
  799386
  800939
  803766
  810604
]
12.95 ms
(6.68%)
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
  810604
  726236
  752864
  754598
  768606
  730977
  753007
  760684
  770031
  619490
  634876
  774736
  774738
  789705
  790028
  799386
  800939
  803766
  382462
  382465
  387146
  310725
  397161
  383455
  396312
  401541
  406847
  415889
  463826
  490826
  522200
  465673
  569035
  570730
  681122
  702819
  673987
  683066
  684198
  696140
  721778
  562881
  598550
  607289
  623945
  781464
  787073
  737522
  756239
  760800
  730235
  744860
  744642
  602363
  785094
  35091
  88220
  382074
  382898
  399187
  401251
  402530
  407890
  419838
  429739
  468155
  481659
  45868
  45985
  402047
  408414
  409125
  452921
  384521
  395653
  406957
  409224
  457816
  476206
  406969
  414753
  424548
  442296
  472180
  520633
  490166
  518814
  521024
  420262
  568062
  567743
  508236
  509164
  510589
  393108
  395398
  395699
  399632
  425630
  438009
  418135
  430245
  442236
  445046
  419892
  423319
  723592
  466457
  468800
  484969
  493265
  519570
  528394
  529654
  539644
  504339
  531521
  534260
  537165
  504155
]
2.57 ms
(1.33%)
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
  35091
  45868
  45985
  88220
  310725
  382074
  382462
  382465
  382898
  383455
  384521
  387146
  393108
  395398
  395653
  395699
  396312
  397161
  399187
  399632
  401251
  401541
  402047
  402530
  406847
  406957
  406969
  407890
  408414
  409125
  409224
  414753
  415889
  418135
  419838
  419892
  420262
  423319
  424548
  425630
  429739
  430245
  438009
  442236
  442296
  445046
  452921
  457816
  463826
  465673
  466457
  468155
  468800
  472180
  476206
  481659
  484969
  490166
  490826
  493265
  504155
  504339
  508236
  509164
  510589
  518814
  519570
  520633
  521024
  522200
  528394
  529654
  531521
  534260
  537165
  539644
  562881
  567743
  568062
  569035
  570730
  598550
  602363
  607289
  619490
  623945
  634876
  673987
  681122
  683066
  684198
  696140
  702819
  721778
  723592
  726236
  730235
  730977
  737522
  744642
  744860
  752864
  753007
  754598
  756239
  760684
  760800
  768606
  770031
  774736
  774738
  781464
  785094
  787073
  789705
  790028
  799386
  800939
  803766
  810604
]
1.95 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красивую милфу"
]
1.63 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая милф"
]
1.56 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.74%)
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.