Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.57 ms
(85.00%)
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
  411515
  434834
  438878
  440696
  452551
  456388
  456486
  459208
  460459
  463698
  465747
  466548
  469626
  474299
  475011
  478728
  478744
  483586
  485008
  486493
  489813
  492081
  495499
  496959
  498512
  499361
  500377
  502337
  513162
  513563
  513950
  514729
  515665
  518962
  519119
  520940
  522683
  525284
  525454
  526144
  526463
  526802
  529488
  534446
  546335
  547639
  552571
  553428
  553608
  554947
  556391
  557433
  558691
  560961
  566344
  571072
  572674
  574280
  580024
  581246
  586245
  586285
  589811
  591724
  592218
  594570
  595601
  595899
  599360
  610680
  613625
  613630
  617614
  625456
  625578
  626972
  627774
  630955
  641334
  641539
  644139
  650725
  655466
  661896
  666496
  671650
  677189
  678205
  678704
  682417
  695501
  696916
  697416
  699583
  701910
  716572
  718556
  719461
  721867
  722341
  727970
  737882
  738653
  740157
  753050
  757909
  760456
  761699
  766469
  779344
  786346
  796363
  797496
  799575
  802005
  804213
  809864
  811052
  814230
  820306
]
18.39 ms
(9.27%)
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
  580024
  581246
  557433
  571072
  666496
  661896
  678704
  718556
  722341
  671650
  697416
  719461
  721867
  560961
  586245
  586285
  589811
  595601
  595899
  641539
  599360
  644139
  591724
  613630
  625578
  779344
  760456
  766469
  740157
  761699
  626972
  630955
  716572
  811052
  459208
  474299
  465747
  478744
  411515
  456486
  502337
  485008
  489813
  514729
  519119
  522683
  486493
  500377
  529488
  820306
  814230
  513162
  499361
  534446
  526144
  483586
  547639
  546335
  553428
  678205
  695501
  701910
  650725
  677189
  655466
  682417
  696916
  558691
  574280
  592218
  617614
  625456
  594570
  610680
  613625
  627774
  641334
  797496
  799575
  804213
  753050
  786346
  796363
  802005
  809864
  737882
  757909
  727970
  738653
  456388
  434834
  469626
  518962
  492081
  495499
  460459
  513950
  525454
  515665
  556391
  553608
  452551
  496959
  498512
  438878
  520940
  572674
  552571
  554947
  699583
  566344
  475011
  513563
  525284
  526802
  526463
  440696
  463698
  478728
  466548
]
3.43 ms
(1.73%)
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
  411515
  434834
  438878
  440696
  452551
  456388
  456486
  459208
  460459
  463698
  465747
  466548
  469626
  474299
  475011
  478728
  478744
  483586
  485008
  486493
  489813
  492081
  495499
  496959
  498512
  499361
  500377
  502337
  513162
  513563
  513950
  514729
  515665
  518962
  519119
  520940
  522683
  525284
  525454
  526144
  526463
  526802
  529488
  534446
  546335
  547639
  552571
  553428
  553608
  554947
  556391
  557433
  558691
  560961
  566344
  571072
  572674
  574280
  580024
  581246
  586245
  586285
  589811
  591724
  592218
  594570
  595601
  595899
  599360
  610680
  613625
  613630
  617614
  625456
  625578
  626972
  627774
  630955
  641334
  641539
  644139
  650725
  655466
  661896
  666496
  671650
  677189
  678205
  678704
  682417
  695501
  696916
  697416
  699583
  701910
  716572
  718556
  719461
  721867
  722341
  727970
  737882
  738653
  740157
  753050
  757909
  760456
  761699
  766469
  779344
  786346
  796363
  797496
  799575
  802005
  804213
  809864
  811052
  814230
  820306
]
2.25 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "neighbor girl"
]
1.99 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "neighbor девушк"
]
1.76 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "neighbor девушк"
]

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.