Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.72 ms
(81.78%)
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
  195513
  359918
  382813
  396088
  397184
  411885
  430508
  447853
  454195
  462369
  488017
  491862
  492246
  492339
  512340
  513743
  530060
  530752
  530792
  531082
  531448
  531899
  536423
  536557
  552989
  554978
  557266
  563927
  566164
  567729
  568033
  587183
  587445
  588694
  590512
  596675
  598768
  600543
  600614
  609877
  615964
  618343
  622123
  622177
  623516
  624497
  627533
  633120
  634831
  634868
  646022
  649367
  650226
  652540
  664548
  664621
  664820
  664967
  665315
  665374
  665471
  665477
  665853
  667574
  667845
  669239
  669452
  669786
  673719
  683121
  687206
  689660
  693214
  694894
  694917
  695113
  703651
  706250
  707356
  709131
  714169
  714216
  716318
  720235
  720434
  720915
  724284
  742224
  745984
  750071
  750078
  751722
  752876
  759483
  759776
  769329
  770949
  772119
  775892
  775951
  775982
  776273
  781301
  781981
  783514
  785341
  787792
  788194
  788255
  788858
  791961
  792265
  792625
  797608
  801419
  804314
  807894
  808535
  813774
  814538
]
16.82 ms
(11.21%)
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
  720915
  716318
  695113
  814538
  536423
  687206
  703651
  714169
  665374
  618343
  792625
  750071
  530060
  530752
  454195
  652540
  694894
  615964
  709131
  513743
  195513
  488017
  813774
  650226
  664621
  801419
  531899
  664820
  531448
  788194
  707356
  775951
  563927
  665853
  669452
  769329
  492339
  609877
  396088
  622123
  492246
  557266
  649367
  714216
  664548
  669239
  683121
  693214
  600614
  797608
  724284
  770949
  759776
  411885
  491862
  667574
  587183
  673719
  720434
  807894
  669786
  667845
  808535
  530792
  646022
  689660
  776273
  750078
  751722
  430508
  665471
  783514
  791961
  706250
  785341
  804314
  531082
  567729
  627533
  633120
  792265
  788255
  596675
  781301
  787792
  745984
  554978
  720235
  665477
  623516
  772119
  759483
  781981
  634868
  788858
  590512
  447853
  742224
  752876
  462369
  622177
  775892
  600543
  624497
  382813
  397184
  359918
  775982
  512340
  552989
  587445
  566164
  665315
  694917
  568033
  536557
  664967
  588694
  634831
  598768
]
2.89 ms
(1.93%)
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
  195513
  359918
  382813
  396088
  397184
  411885
  430508
  447853
  454195
  462369
  488017
  491862
  492246
  492339
  512340
  513743
  530060
  530752
  530792
  531082
  531448
  531899
  536423
  536557
  552989
  554978
  557266
  563927
  566164
  567729
  568033
  587183
  587445
  588694
  590512
  596675
  598768
  600543
  600614
  609877
  615964
  618343
  622123
  622177
  623516
  624497
  627533
  633120
  634831
  634868
  646022
  649367
  650226
  652540
  664548
  664621
  664820
  664967
  665315
  665374
  665471
  665477
  665853
  667574
  667845
  669239
  669452
  669786
  673719
  683121
  687206
  689660
  693214
  694894
  694917
  695113
  703651
  706250
  707356
  709131
  714169
  714216
  716318
  720235
  720434
  720915
  724284
  742224
  745984
  750071
  750078
  751722
  752876
  759483
  759776
  769329
  770949
  772119
  775892
  775951
  775982
  776273
  781301
  781981
  783514
  785341
  787792
  788194
  788255
  788858
  791961
  792265
  792625
  797608
  801419
  804314
  807894
  808535
  813774
  814538
]
2.14 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"трах огромными членаÐâ…"
]
1.99 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс огромные член"
]
1.77 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс огромные член"
]
1.72 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.