Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
226.36 ms
(62.83%)
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
  666579
  671714
  506048
  675022
  457772
  456791
  458432
  573211
  674128
  824052
  522882
  674492
  571136
  807196
  699744
  545444
  318795
  520753
  583982
  386935
  805594
  515545
  591882
  233446
  748239
  568061
  755145
  635614
  95855
  400928
  411572
  551070
  760240
  760928
  457776
  802062
  787387
  387720
  484656
  388492
  191575
  683826
  411134
  459178
  414360
  465618
  670108
  603151
  735430
  390378
  396568
  393067
  597870
  406881
  536210
  717724
  671740
  631913
  644296
  826118
  828420
  546449
  693931
  721746
  612419
  810771
  398773
  814893
  469436
  475466
  696355
  589208
  595772
  703091
  775818
  516686
  391744
  396336
  427224
  784621
  184359
  818323
  95700
  820768
  670773
  645233
  648819
  775810
  795139
  805600
  424634
  397781
  645249
  697173
  513850
  631211
  384786
  381883
  426394
  714014
  692796
  817349
  478445
  524955
  651082
  669567
  671751
  634477
  790382
  756023
  621323
  457762
  454277
  466103
  814382
  708829
  690809
  739613
  477705
  399628
]
123.48 ms
(34.27%)
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
  95700
  95855
  184359
  191575
  233446
  318795
  381883
  384786
  386935
  387720
  388492
  390378
  391744
  393067
  396336
  396568
  397781
  398773
  399628
  400928
  406881
  411134
  411572
  414360
  424634
  426394
  427224
  454277
  456791
  457762
  457772
  457776
  458432
  459178
  465618
  466103
  469436
  475466
  477705
  478445
  484656
  506048
  513850
  515545
  516686
  520753
  522882
  524955
  536210
  545444
  546449
  551070
  568061
  571136
  573211
  583982
  589208
  591882
  595772
  597870
  603151
  612419
  621323
  631211
  631913
  634477
  635614
  644296
  645233
  645249
  648819
  651082
  666579
  669567
  670108
  670773
  671714
  671740
  671751
  674128
  674492
  675022
  683826
  690809
  692796
  693931
  696355
  697173
  699744
  703091
  708829
  714014
  717724
  721746
  735430
  739613
  748239
  755145
  756023
  760240
  760928
  775810
  775818
  784621
  787387
  790382
  795139
  802062
  805594
  805600
  807196
  810771
  814382
  814893
  817349
  818323
  820768
  824052
  826118
  828420
]
3.50 ms
(0.97%)
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
  95700
  95855
  184359
  191575
  233446
  318795
  381883
  384786
  386935
  387720
  388492
  390378
  391744
  393067
  396336
  396568
  397781
  398773
  399628
  400928
  406881
  411134
  411572
  414360
  424634
  426394
  427224
  454277
  456791
  457762
  457772
  457776
  458432
  459178
  465618
  466103
  469436
  475466
  477705
  478445
  484656
  506048
  513850
  515545
  516686
  520753
  522882
  524955
  536210
  545444
  546449
  551070
  568061
  571136
  573211
  583982
  589208
  591882
  595772
  597870
  603151
  612419
  621323
  631211
  631913
  634477
  635614
  644296
  645233
  645249
  648819
  651082
  666579
  669567
  670108
  670773
  671714
  671740
  671751
  674128
  674492
  675022
  683826
  690809
  692796
  693931
  696355
  697173
  699744
  703091
  708829
  714014
  717724
  721746
  735430
  739613
  748239
  755145
  756023
  760240
  760928
  775810
  775818
  784621
  787387
  790382
  795139
  802062
  805594
  805600
  807196
  810771
  814382
  814893
  817349
  818323
  820768
  824052
  826118
  828420
]
1.97 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "групповой секс мама"
]
1.87 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "группов секс мам женщин"
]
1.46 ms
(0.40%)
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.