Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
267.09 ms
(91.88%)
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
  108018
  406724
  418858
  422286
  423516
  427714
  428095
  428159
  435503
  435701
  436626
  440798
  442645
  447090
  450650
  451141
  451632
  452786
  454652
  455058
  455343
  457194
  457379
  459252
  459363
  461567
  468863
  469168
  470559
  473974
  475542
  478402
  478988
  478992
  481406
  484118
  486859
  486872
  487086
  487228
  489220
  491373
  492289
  492337
  495130
  501250
  501839
  504741
  504748
  510619
  512373
  514392
  514609
  515337
  515589
  516440
  523051
  524069
  526219
  527277
  527519
  529053
  534359
  535707
  546510
  551994
  553653
  555591
  562484
  573222
  576697
  578185
  578386
  582477
  584128
  584217
  591210
  591494
  602355
  602714
  603420
  605579
  631550
  634362
  647606
  651039
  660807
  665831
  676375
  693796
  693806
  709729
  709919
  709938
  716383
  718864
  719456
  719640
  721793
  725579
  728494
  731382
  732242
  734611
  737632
  743933
  744585
  745565
  747640
  771251
  774994
  787399
  790841
  796640
  801866
  805041
  807982
  810383
  816568
]
13.86 ms
(4.77%)
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
  546510
  810383
  747640
  728494
  745565
  737632
  743933
  725579
  731382
  719456
  719640
  721793
  807982
  108018
  495130
  676375
  486859
  435503
  523051
  447090
  515589
  486872
  452786
  473974
  422286
  660807
  555591
  584217
  605579
  591494
  796640
  805041
  602355
  514392
  501250
  524069
  406724
  427714
  435701
  457379
  469168
  718864
  771251
  418858
  512373
  478402
  709938
  651039
  468863
  801866
  716383
  428095
  457194
  461567
  481406
  491373
  647606
  665831
  693796
  693806
  631550
  591210
  634362
  734611
  732242
  744585
  787399
  470559
  487228
  450650
  459363
  534359
  582477
  790841
  454652
  535707
  527519
  576697
  709729
  603420
  578185
  451141
  455058
  553653
  428159
  455343
  489220
  510619
  492289
  526219
  578386
  604621
  440798
  816568
  451632
  478988
  527277
  515337
  475542
  562484
  584128
  709919
  602714
  774994
  436626
  459252
  478992
  501839
  487086
  516440
  504741
  504748
  514609
  484118
  492337
  442645
  423516
  529053
  551994
  573222
]
2.64 ms
(0.91%)
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
  108018
  406724
  418858
  422286
  423516
  427714
  428095
  428159
  435503
  435701
  436626
  440798
  442645
  447090
  450650
  451141
  451632
  452786
  454652
  455058
  455343
  457194
  457379
  459252
  459363
  461567
  468863
  469168
  470559
  473974
  475542
  478402
  478988
  478992
  481406
  484118
  486859
  486872
  487086
  487228
  489220
  491373
  492289
  492337
  495130
  501250
  501839
  504741
  504748
  510619
  512373
  514392
  514609
  515337
  515589
  516440
  523051
  524069
  526219
  527277
  527519
  529053
  534359
  535707
  546510
  551994
  553653
  555591
  562484
  573222
  576697
  578185
  578386
  582477
  584128
  584217
  591210
  591494
  602355
  602714
  603420
  605579
  631550
  634362
  647606
  651039
  660807
  665831
  676375
  693796
  693806
  709729
  709919
  709938
  716383
  718864
  719456
  719640
  721793
  725579
  728494
  731382
  732242
  734611
  737632
  743933
  744585
  745565
  747640
  771251
  774994
  787399
  790841
  796640
  801866
  805041
  807982
  810383
  816568
]
1.94 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие real сиськ"
]
1.91 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big real tits"
]
1.75 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие real сиськ"
]

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.