Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
199.77 ms
(90.39%)
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
  89021
  247330
  386630
  390288
  394552
  395998
  401214
  406896
  411920
  413223
  414736
  420375
  422345
  434239
  440771
  443793
  444255
  445089
  454055
  454089
  454164
  456842
  459421
  463319
  464484
  464556
  465822
  466244
  466893
  467960
  471895
  472864
  473488
  475051
  477574
  477794
  481317
  486798
  489995
  491639
  492633
  493220
  495253
  505739
  506411
  507798
  509320
  511117
  512993
  515347
  525266
  525496
  533991
  537483
  546763
  549670
  551949
  555987
  558724
  562444
  563021
  563450
  565261
  565649
  567344
  576676
  580862
  582404
  583572
  583573
  589587
  590928
  591376
  602018
  629849
  631683
  681539
  693072
  696316
  697182
  698158
  707361
  716794
  721748
  728119
  728352
  730163
  730315
  742560
  742566
  744179
  746604
  754158
  756321
  756878
  758225
  759759
  761234
  761469
  766669
  768406
  778055
  780687
  781758
  783977
  784240
  788073
  788544
  788559
  791548
  792678
  794442
  796272
  801090
  802312
  803746
  808049
  808434
  820586
  822121
]
11.29 ms
(5.11%)
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
  505739
  466244
  390288
  802312
  820586
  792678
  801090
  759759
  780687
  386630
  565649
  788559
  440771
  401214
  454089
  489995
  549670
  525496
  533991
  562444
  591376
  794442
  758225
  563450
  707361
  466893
  791548
  247330
  507798
  681539
  454055
  475051
  420375
  602018
  563021
  509320
  515347
  822121
  766669
  756878
  486798
  472864
  493220
  693072
  567344
  590928
  756321
  716794
  422345
  506411
  444255
  511117
  580862
  803746
  565261
  576676
  464484
  698158
  781758
  728119
  761234
  414736
  471895
  411920
  464556
  459421
  788073
  783977
  465822
  477794
  454164
  808049
  697182
  395998
  406896
  583573
  754158
  742566
  730315
  721748
  456842
  491639
  492633
  582404
  546763
  434239
  445089
  551949
  796272
  537483
  696316
  761469
  467960
  555987
  631683
  394552
  589587
  730163
  742560
  768406
  746604
  558724
  784240
  808434
  744179
  89021
  728352
  477574
  495253
  525266
  512993
  583572
  629849
  443793
  463319
  413223
  778055
  788544
  481317
  473488
]
2.44 ms
(1.11%)
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
  89021
  247330
  386630
  390288
  394552
  395998
  401214
  406896
  411920
  413223
  414736
  420375
  422345
  434239
  440771
  443793
  444255
  445089
  454055
  454089
  454164
  456842
  459421
  463319
  464484
  464556
  465822
  466244
  466893
  467960
  471895
  472864
  473488
  475051
  477574
  477794
  481317
  486798
  489995
  491639
  492633
  493220
  495253
  505739
  506411
  507798
  509320
  511117
  512993
  515347
  525266
  525496
  533991
  537483
  546763
  549670
  551949
  555987
  558724
  562444
  563021
  563450
  565261
  565649
  567344
  576676
  580862
  582404
  583572
  583573
  589587
  590928
  591376
  602018
  629849
  631683
  681539
  693072
  696316
  697182
  698158
  707361
  716794
  721748
  728119
  728352
  730163
  730315
  742560
  742566
  744179
  746604
  754158
  756321
  756878
  758225
  759759
  761234
  761469
  766669
  768406
  778055
  780687
  781758
  783977
  784240
  788073
  788544
  788559
  791548
  792678
  794442
  796272
  801090
  802312
  803746
  808049
  808434
  820586
  822121
]
2.18 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщины кончают сиськ…"
]
1.92 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин сперм сиськ"
]
1.83 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.71%)
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.