Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.26 ms
(83.03%)
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
  96231
  97098
  390538
  414337
  414360
  430088
  506538
  514722
  521249
  531179
  542860
  542877
  543590
  545387
  550200
  551992
  565418
  566573
  574294
  579193
  580697
  583904
  583933
  587711
  595729
  595758
  597243
  599851
  599971
  600175
  603238
  603398
  604844
  606590
  606802
  608932
  609856
  613859
  614186
  616338
  620316
  625682
  625736
  628410
  629560
  630536
  630678
  632607
  632638
  632658
  632660
  634154
  634786
  635225
  636316
  637089
  637120
  639335
  640616
  644971
  645973
  647636
  647968
  648238
  649935
  650114
  650827
  651489
  660422
  664305
  666585
  666912
  671334
  671354
  671712
  672984
  674128
  676326
  677730
  679025
  679761
  683582
  710396
  712049
  714552
  716577
  718513
  718968
  720127
  725598
  727900
  737521
  743782
  748216
  748231
  748234
  748238
  748239
  748968
  752989
  760807
  775858
  784111
  784908
  789764
  794259
  795593
  798948
  801958
  803344
  805587
  807390
  810760
  811459
  815354
  815737
  817841
  818160
  819511
  821532
]
16.77 ms
(10.85%)
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
  97098
  96231
  414360
  430088
  815354
  818160
  815737
  819511
  817841
  821532
  506538
  521249
  543590
  583904
  551992
  566573
  580697
  647636
  647968
  649935
  664305
  672984
  650114
  650827
  671354
  671712
  676326
  716577
  718513
  720127
  671334
  674128
  677730
  718968
  640616
  595729
  604844
  606802
  608932
  628410
  599971
  603398
  614186
  625682
  629560
  587711
  613859
  620316
  784111
  784908
  789764
  795593
  798948
  807390
  775858
  803344
  748216
  748234
  748238
  794259
  727900
  737521
  748231
  748239
  752989
  760807
  743782
  748968
  609856
  632607
  710396
  714552
  805587
  810760
  811459
  390538
  514722
  414337
  644971
  542860
  630536
  542877
  579193
  550200
  565418
  645973
  666585
  666912
  679025
  648238
  660422
  679761
  545387
  583933
  616338
  630678
  632638
  634154
  635225
  639335
  597243
  606590
  632658
  637089
  637120
  600175
  632660
  636316
  599851
  801958
  725598
  634786
  531179
  574294
  683582
  712049
  651489
  625736
  595758
  603238
]
2.52 ms
(1.63%)
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
  96231
  97098
  390538
  414337
  414360
  430088
  506538
  514722
  521249
  531179
  542860
  542877
  543590
  545387
  550200
  551992
  565418
  566573
  574294
  579193
  580697
  583904
  583933
  587711
  595729
  595758
  597243
  599851
  599971
  600175
  603238
  603398
  604844
  606590
  606802
  608932
  609856
  613859
  614186
  616338
  620316
  625682
  625736
  628410
  629560
  630536
  630678
  632607
  632638
  632658
  632660
  634154
  634786
  635225
  636316
  637089
  637120
  639335
  640616
  644971
  645973
  647636
  647968
  648238
  649935
  650114
  650827
  651489
  660422
  664305
  666585
  666912
  671334
  671354
  671712
  672984
  674128
  676326
  677730
  679025
  679761
  683582
  710396
  712049
  714552
  716577
  718513
  718968
  720127
  725598
  727900
  737521
  743782
  748216
  748231
  748234
  748238
  748239
  748968
  752989
  760807
  775858
  784111
  784908
  789764
  794259
  795593
  798948
  801958
  803344
  805587
  807390
  810760
  811459
  815354
  815737
  817841
  818160
  819511
  821532
]
1.86 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп gangbang"
]
1.73 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп gangbang"
]
1.65 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass gangbang"
]

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.