Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.69 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.06 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur wife anal"
]
3 10.54 ms
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
  762287
  790288
  803848
  784266
  738639
  754034
  828555
  529337
  797183
  727927
  736237
  744446
  769790
  729291
  742637
  765723
  766985
  756677
  781364
  786550
  781579
  761110
  769849
  767077
  782573
  766602
  542512
  767973
  711802
  793597
  734662
  578807
  712574
  422107
  649244
  655241
  662171
  663738
  674866
  590812
  680346
  619203
  760906
  714429
  656294
  733796
  790141
  685317
  685394
  748825
  764245
  791215
  800576
  609343
  535725
  496245
  516019
  531291
  560980
  544428
  549009
  577902
  656295
  656492
  656599
  657134
  670024
  671250
  680236
  703297
  707133
  646092
  650066
  656290
  657178
  671255
  675842
  680268
  688927
  691971
  710083
  646655
  648620
  651752
  656532
  656622
  674848
  685548
  686570
  549123
  552636
  599281
  613523
  628448
  629341
  638193
  643605
  593611
  607265
  633640
  643461
  597132
  602706
  602886
  629735
  643664
  593595
  604169
  630392
  643589
  781008
  736580
  747751
  757043
  731198
  602400
  629172
  708867
  710909
  778875
]
4 3.03 ms
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
  422107
  496245
  516019
  529337
  531291
  535725
  542512
  544428
  549009
  549123
  552636
  560980
  577902
  578807
  590812
  593595
  593611
  597132
  599281
  602400
  602706
  602886
  604169
  607265
  609343
  613523
  619203
  628448
  629172
  629341
  629735
  630392
  633640
  638193
  643461
  643589
  643605
  643664
  646092
  646655
  648620
  649244
  650066
  651752
  655241
  656290
  656294
  656295
  656492
  656532
  656599
  656622
  657134
  657178
  662171
  663738
  670024
  671250
  671255
  674848
  674866
  675842
  680236
  680268
  680346
  685317
  685394
  685548
  686570
  688927
  691971
  703297
  707133
  708867
  710083
  710909
  711802
  712574
  714429
  727927
  729291
  731198
  733796
  734662
  736237
  736580
  738639
  742637
  744446
  747751
  748825
  754034
  756677
  757043
  760906
  761110
  762287
  764245
  765723
  766602
  766985
  767077
  767973
  769849
  778875
  781008
  781364
  781579
  782573
  784266
  786550
  790141
  790288
  791215
  793597
  797183
  800576
  803848
  828555
]
5 137.06 ms
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
  422107
  496245
  516019
  529337
  531291
  535725
  542512
  544428
  549009
  549123
  552636
  560980
  577902
  578807
  590812
  593595
  593611
  597132
  599281
  602400
  602706
  602886
  604169
  607265
  609343
  613523
  619203
  628448
  629172
  629341
  629735
  630392
  633640
  638193
  643461
  643589
  643605
  643664
  646092
  646655
  648620
  649244
  650066
  651752
  655241
  656290
  656294
  656295
  656492
  656532
  656599
  656622
  657134
  657178
  662171
  663738
  670024
  671250
  671255
  674848
  674866
  675842
  680236
  680268
  680346
  685317
  685394
  685548
  686570
  688927
  691971
  703297
  707133
  708867
  710083
  710909
  711802
  712574
  714429
  727927
  729291
  731198
  733796
  734662
  736237
  736580
  738639
  742637
  744446
  747751
  748825
  754034
  756677
  757043
  760906
  761110
  762287
  764245
  765723
  766602
  766985
  767077
  767973
  769849
  778875
  781008
  781364
  781579
  782573
  784266
  786550
  790141
  790288
  791215
  793597
  797183
  800576
  803848
  828555
]
6 1.79 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск жен анал"
]
7 1.57 ms
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.