Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.47 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.74 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature housewife"
]
3 15.64 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
  409330
  417015
  817293
  820211
  819235
  464927
  515904
  518762
  529573
  534240
  582581
  566662
  563160
  567434
  570972
  666128
  705455
  721471
  715414
  591064
  610172
  785879
  788287
  807385
  746122
  771968
  781683
  782159
  808226
  732580
  726473
  733338
  731305
  744653
  764144
  710895
  715528
  717663
  721280
  782155
  782246
  451470
  388261
  477227
  155306
  25650
  819190
  823565
  823739
  818393
  820373
  827141
  827421
  819966
  825418
  527773
  555308
  542472
  584397
  660025
  714112
  716736
  719384
  671379
  721751
  561522
  596797
  593415
  643329
  799748
  803008
  804430
  811122
  796015
  804423
  725201
  727047
  781674
  785196
  791561
  796306
  805706
  725481
  730930
  766684
  770201
  761473
  697211
  776725
  788982
  790984
  407780
  412983
  814933
  476224
  473829
  475842
  476262
  484399
  512608
  522589
  523164
  536444
  496873
  557244
  563173
  569943
  559071
  549842
  549846
  609999
  733319
  726587
  470967
  12900
  466109
  467279
  474482
  482323
  443761
]
4 2.55 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
  12900
  25650
  155306
  388261
  407780
  409330
  412983
  417015
  443761
  451470
  464927
  466109
  467279
  470967
  473829
  474482
  475842
  476224
  476262
  477227
  482323
  484399
  496873
  512608
  515904
  518762
  522589
  523164
  527773
  529573
  534240
  536444
  542472
  549842
  549846
  555308
  557244
  559071
  561522
  563160
  563173
  566662
  567434
  569943
  570972
  582581
  584397
  591064
  593415
  596797
  609999
  610172
  643329
  660025
  666128
  671379
  697211
  705455
  710895
  714112
  715414
  715528
  716736
  717663
  719384
  721280
  721471
  721751
  725201
  725481
  726473
  726587
  727047
  730930
  731305
  732580
  733319
  733338
  744653
  746122
  761473
  764144
  766684
  770201
  771968
  776725
  781674
  781683
  782155
  782159
  782246
  785196
  785879
  788287
  788982
  790984
  791561
  796015
  796306
  799748
  803008
  804423
  804430
  805706
  807385
  808226
  811122
  814933
  817293
  818393
  819190
  819235
  819966
  820211
  820373
  823565
  823739
  825418
  827141
  827421
]
5 168.62 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
  12900
  25650
  155306
  388261
  407780
  409330
  412983
  417015
  443761
  451470
  464927
  466109
  467279
  470967
  473829
  474482
  475842
  476224
  476262
  477227
  482323
  484399
  496873
  512608
  515904
  518762
  522589
  523164
  527773
  529573
  534240
  536444
  542472
  549842
  549846
  555308
  557244
  559071
  561522
  563160
  563173
  566662
  567434
  569943
  570972
  582581
  584397
  591064
  593415
  596797
  609999
  610172
  643329
  660025
  666128
  671379
  697211
  705455
  710895
  714112
  715414
  715528
  716736
  717663
  719384
  721280
  721471
  721751
  725201
  725481
  726473
  726587
  727047
  730930
  731305
  732580
  733319
  733338
  744653
  746122
  761473
  764144
  766684
  770201
  771968
  776725
  781674
  781683
  782155
  782159
  782246
  785196
  785879
  788287
  788982
  790984
  791561
  796015
  796306
  799748
  803008
  804423
  804430
  805706
  807385
  808226
  811122
  814933
  817293
  818393
  819190
  819235
  819966
  820211
  820373
  823565
  823739
  825418
  827141
  827421
]
6 1.88 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature housewife"
]
7 1.40 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature housewife"
]

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.