Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.10 ms
(81.42%)
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
  7295
  76043
  118141
  131512
  150798
  150820
  188009
  188064
  233353
  382692
  386403
  386734
  387951
  389860
  390643
  390769
  391505
  391692
  391959
  392952
  393080
  395724
  397879
  401108
  408009
  409316
  412015
  418778
  421866
  421883
  423516
  428919
  439710
  440817
  440895
  440932
  440967
  441774
  448002
  448656
  449094
  454537
  457585
  459633
  465062
  466196
  468359
  468366
  469311
  470965
  473486
  477128
  478002
  479369
  480538
  489271
  489953
  493575
  506062
  510807
  552285
  561002
  585532
  591923
  598088
  604302
  634559
  682811
  683284
  693208
  698038
  704264
  707314
  709528
  711728
  720810
  726242
  728393
  729074
  729891
  731100
  731779
  733943
  734452
  736242
  742631
  742719
  749891
  753461
  755076
  758504
  761069
  761084
  761538
  762301
  763914
  766673
  782122
  782294
  782636
  790494
  792654
  794070
  794378
  794533
  794863
  796054
  796252
  796920
  798804
  798942
  800326
  801309
  803145
  807352
  811065
  812941
  821726
  824672
  826277
]
16.02 ms
(10.86%)
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
  726242
  733943
  736242
  755076
  728393
  729074
  749891
  761069
  761538
  762301
  766673
  720810
  782294
  792654
  794070
  798804
  800326
  448656
  150820
  382692
  390769
  441774
  821726
  459633
  506062
  682811
  683284
  709528
  711728
  693208
  698038
  585532
  604302
  634559
  798942
  811065
  794533
  796054
  796252
  801309
  812941
  734452
  758504
  782122
  761084
  742631
  729891
  731100
  731779
  742719
  753461
  763914
  704264
  707314
  782636
  794863
  796920
  803145
  824672
  826277
  478002
  386403
  76043
  386734
  118141
  188064
  188009
  393080
  391692
  395724
  392952
  389860
  397879
  401108
  408009
  412015
  423516
  440967
  418778
  440817
  440932
  448002
  469311
  489953
  468359
  468366
  552285
  561002
  598088
  807352
  150798
  387951
  390643
  391959
  409316
  449094
  465062
  473486
  421866
  421883
  479369
  428919
  131512
  233353
  454537
  457585
  470965
  477128
  440895
  466196
  489271
  493575
  510807
  790494
  591923
  794378
  7295
  439710
  391505
  480538
]
2.95 ms
(2.00%)
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
  7295
  76043
  118141
  131512
  150798
  150820
  188009
  188064
  233353
  382692
  386403
  386734
  387951
  389860
  390643
  390769
  391505
  391692
  391959
  392952
  393080
  395724
  397879
  401108
  408009
  409316
  412015
  418778
  421866
  421883
  423516
  428919
  439710
  440817
  440895
  440932
  440967
  441774
  448002
  448656
  449094
  454537
  457585
  459633
  465062
  466196
  468359
  468366
  469311
  470965
  473486
  477128
  478002
  479369
  480538
  489271
  489953
  493575
  506062
  510807
  552285
  561002
  585532
  591923
  598088
  604302
  634559
  682811
  683284
  693208
  698038
  704264
  707314
  709528
  711728
  720810
  726242
  728393
  729074
  729891
  731100
  731779
  733943
  734452
  736242
  742631
  742719
  749891
  753461
  755076
  758504
  761069
  761084
  761538
  762301
  763914
  766673
  782122
  782294
  782636
  790494
  792654
  794070
  794378
  794533
  794863
  796054
  796252
  796920
  798804
  798942
  800326
  801309
  803145
  807352
  811065
  812941
  821726
  824672
  826277
]
2.16 ms
(1.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.15 ms
(1.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн женщин анал"
]
2.14 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "порн женщин анал"
]
1.99 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.