Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.16 ms
(86.54%)
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
  123271
  181804
  210768
  233029
  233504
  233617
  346210
  361315
  365880
  386194
  388215
  388544
  390213
  397410
  401124
  402693
  406657
  409820
  412137
  412150
  418244
  418459
  422330
  426674
  428966
  435045
  443366
  443998
  444228
  445274
  445336
  453605
  453621
  453901
  454119
  455641
  456454
  457798
  461461
  461468
  462170
  462528
  462544
  464782
  465784
  465993
  466974
  469851
  471572
  476728
  477015
  479758
  480638
  484342
  484813
  486027
  489376
  489663
  490866
  491155
  494401
  496235
  496776
  496882
  501718
  506812
  510677
  511122
  512304
  512754
  513446
  516295
  516751
  519725
  523022
  523965
  526053
  526287
  527792
  527945
  528648
  537960
  537987
  541110
  541727
  543584
  545670
  554562
  561880
  569341
  573667
  573702
  574534
  595361
  595375
  595396
  595477
  597062
  597215
  597498
  597951
  597969
  598084
  598458
  598553
  598721
  600118
  655077
  655385
  660503
  688927
  722825
  743634
  762277
  771840
  775836
  782131
  783609
  785048
]
13.64 ms
(8.13%)
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
  412150
  462544
  465784
  516751
  233617
  426674
  401124
  574534
  595375
  722825
  418459
  445274
  457798
  506812
  527945
  484342
  490866
  512304
  476728
  543584
  597062
  444228
  494401
  489376
  510677
  491155
  466974
  346210
  462170
  523965
  496776
  412137
  660503
  123271
  402693
  461461
  388215
  688927
  782131
  397410
  406657
  597215
  422330
  456454
  537987
  541727
  569341
  595477
  597951
  595361
  598084
  598553
  597969
  453621
  477015
  455641
  523022
  526287
  528648
  496882
  537960
  486027
  489663
  516295
  783609
  790453
  762277
  233029
  361315
  409820
  386194
  600118
  479758
  598458
  435045
  573667
  573702
  464782
  428966
  471572
  445336
  453605
  526053
  554562
  775836
  743634
  233504
  443998
  469851
  512754
  496235
  655077
  655385
  771840
  443366
  462528
  390213
  461468
  388544
  513446
  210768
  181804
  365880
  541110
  484813
  561880
  545670
  598721
  597498
  595396
  454119
  480638
  453901
  418244
  465993
  527792
  501718
  511122
  519725
  785048
]
2.80 ms
(1.67%)
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
  123271
  181804
  210768
  233029
  233504
  233617
  346210
  361315
  365880
  386194
  388215
  388544
  390213
  397410
  401124
  402693
  406657
  409820
  412137
  412150
  418244
  418459
  422330
  426674
  428966
  435045
  443366
  443998
  444228
  445274
  445336
  453605
  453621
  453901
  454119
  455641
  456454
  457798
  461461
  461468
  462170
  462528
  462544
  464782
  465784
  465993
  466974
  469851
  471572
  476728
  477015
  479758
  480638
  484342
  484813
  486027
  489376
  489663
  490866
  491155
  494401
  496235
  496776
  496882
  501718
  506812
  510677
  511122
  512304
  512754
  513446
  516295
  516751
  519725
  523022
  523965
  526053
  526287
  527792
  527945
  528648
  537960
  537987
  541110
  541727
  543584
  545670
  554562
  561880
  569341
  573667
  573702
  574534
  595361
  595375
  595396
  595477
  597062
  597215
  597498
  597951
  597969
  598084
  598458
  598553
  598721
  600118
  655077
  655385
  660503
  688927
  722825
  743634
  762277
  771840
  775836
  782131
  783609
  785048
]
2.00 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rus 18 sex"
]
1.45 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск 18 секс"
]
1.25 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск 18 секс"
]

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.