Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
227.13 ms
(48.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
  383823
  391219
  404722
  404738
  411477
  414124
  420609
  422673
  424518
  425503
  426167
  428481
  430142
  432491
  432886
  434202
  438367
  443797
  443821
  444937
  445550
  446754
  449125
  451100
  452186
  453140
  454089
  454295
  454609
  455153
  455358
  455375
  456138
  456717
  457652
  457843
  459879
  459910
  460059
  460574
  460783
  460803
  461603
  463006
  463869
  464606
  464918
  467231
  468447
  469915
  470407
  471190
  472526
  475172
  475549
  478081
  479817
  480058
  480919
  483332
  483515
  485642
  485926
  486422
  489663
  491539
  492391
  492434
  493467
  494392
  495613
  496302
  496662
  499782
  501630
  502560
  502832
  503675
  503742
  504552
  506909
  511778
  512652
  513335
  515935
  516689
  518325
  519288
  519344
  520135
  520887
  523182
  525191
  525836
  527099
  527626
  528164
  528963
  529204
  540268
  541676
  545514
  551248
  551800
  552078
  552110
  552246
  556840
  556842
  557955
  558858
  559021
  562237
  564056
  565045
  568600
  591922
  634095
  740594
  782396
]
204.87 ms
(44.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "размеры хуев"
]
23.40 ms
(5.03%)
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
  494392
  499782
  489663
  506909
  540268
  404738
  457652
  457843
  478081
  545514
  556842
  559021
  562237
  551248
  552246
  558858
  782396
  740594
  414124
  475549
  391219
  453140
  479817
  455358
  523182
  503675
  485642
  516689
  518325
  483515
  430142
  551800
  557955
  564056
  634095
  434202
  502560
  541676
  483332
  428481
  454295
  459910
  460574
  493467
  451100
  480058
  456138
  464918
  383823
  404722
  452186
  480919
  468447
  432491
  463006
  470407
  459879
  424518
  426167
  444937
  496302
  512652
  519288
  527626
  425503
  411477
  454089
  456717
  463869
  471190
  513335
  504552
  445550
  454609
  446754
  460059
  475172
  455375
  520887
  486422
  492391
  525191
  491539
  515935
  519344
  527099
  529204
  511778
  496662
  455153
  520135
  502832
  485926
  552110
  568600
  556840
  565045
  552078
  591922
  443821
  460803
  449125
  460783
  501630
  528164
  492434
  525836
  503742
  472526
  420609
  528963
  461603
  464606
  469915
  467231
  422673
  438367
  443797
  495613
  432886
]
4.69 ms
(1.01%)
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
  383823
  391219
  404722
  404738
  411477
  414124
  420609
  422673
  424518
  425503
  426167
  428481
  430142
  432491
  432886
  434202
  438367
  443797
  443821
  444937
  445550
  446754
  449125
  451100
  452186
  453140
  454089
  454295
  454609
  455153
  455358
  455375
  456138
  456717
  457652
  457843
  459879
  459910
  460059
  460574
  460783
  460803
  461603
  463006
  463869
  464606
  464918
  467231
  468447
  469915
  470407
  471190
  472526
  475172
  475549
  478081
  479817
  480058
  480919
  483332
  483515
  485642
  485926
  486422
  489663
  491539
  492391
  492434
  493467
  494392
  495613
  496302
  496662
  499782
  501630
  502560
  502832
  503675
  503742
  504552
  506909
  511778
  512652
  513335
  515935
  516689
  518325
  519288
  519344
  520135
  520887
  523182
  525191
  525836
  527099
  527626
  528164
  528963
  529204
  540268
  541676
  545514
  551248
  551800
  552078
  552110
  552246
  556840
  556842
  557955
  558858
  559021
  562237
  564056
  565045
  568600
  591922
  634095
  740594
  782396
]
2.22 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "размер член"
]
1.77 ms
(0.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.32%)
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.