Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.68 ms
(86.00%)
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
  382404
  386083
  391423
  401631
  402731
  413754
  420485
  420670
  425748
  427169
  442925
  443132
  444997
  448367
  451611
  453594
  454239
  455212
  458014
  458680
  460531
  460538
  460656
  460898
  461106
  461265
  461669
  461957
  463099
  466314
  466676
  469612
  470393
  472009
  473244
  473245
  473246
  474168
  474169
  479971
  481195
  481288
  481316
  484593
  485412
  485413
  485492
  485588
  485715
  485719
  485917
  485968
  487603
  487929
  488525
  491816
  494577
  496295
  496305
  496309
  496316
  498234
  501099
  504715
  506231
  507371
  509022
  509244
  509512
  510666
  513239
  520379
  522263
  528917
  534512
  542223
  543584
  544323
  546366
  548230
  548232
  548351
  549220
  549769
  549778
  550332
  551933
  551939
  551949
  552763
  554615
  555643
  557536
  562343
  565027
  565796
  565828
  569137
  570126
  574237
  575424
  576680
  579879
  581370
  592460
  603010
  612914
  616766
  623502
  624231
  636555
  644303
  680653
  680657
  692636
  692812
  714524
  715116
  716244
  819706
]
16.49 ms
(8.67%)
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
  420485
  458680
  461265
  485492
  575424
  581370
  548351
  570126
  714524
  469612
  463099
  401631
  420670
  461957
  520379
  485968
  488525
  461669
  460656
  496305
  544323
  592460
  496309
  616766
  644303
  549778
  680657
  443132
  485719
  543584
  548230
  716244
  692812
  552763
  612914
  491816
  461106
  473244
  507371
  496295
  522263
  549220
  680653
  692636
  579879
  472009
  455212
  460538
  470393
  460531
  485412
  509512
  819706
  557536
  487603
  555643
  542223
  551939
  565828
  546366
  565027
  623502
  636555
  386083
  444997
  460898
  413754
  481288
  487929
  504715
  382404
  451611
  458014
  479971
  485715
  509244
  496316
  528917
  513239
  501099
  466314
  473246
  549769
  551933
  565796
  569137
  576680
  715116
  551949
  427169
  466676
  454239
  473245
  481195
  534512
  485917
  494577
  510666
  550332
  548232
  554615
  562343
  574237
  603010
  624231
  453594
  402731
  474168
  391423
  474169
  425748
  481316
  484593
  485413
  509022
  485588
  498234
  506231
  442925
  448367
]
2.92 ms
(1.53%)
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
  382404
  386083
  391423
  401631
  402731
  413754
  420485
  420670
  425748
  427169
  442925
  443132
  444997
  448367
  451611
  453594
  454239
  455212
  458014
  458680
  460531
  460538
  460656
  460898
  461106
  461265
  461669
  461957
  463099
  466314
  466676
  469612
  470393
  472009
  473244
  473245
  473246
  474168
  474169
  479971
  481195
  481288
  481316
  484593
  485412
  485413
  485492
  485588
  485715
  485719
  485917
  485968
  487603
  487929
  488525
  491816
  494577
  496295
  496305
  496309
  496316
  498234
  501099
  504715
  506231
  507371
  509022
  509244
  509512
  510666
  513239
  520379
  522263
  528917
  534512
  542223
  543584
  544323
  546366
  548230
  548232
  548351
  549220
  549769
  549778
  550332
  551933
  551939
  551949
  552763
  554615
  555643
  557536
  562343
  565027
  565796
  565828
  569137
  570126
  574237
  575424
  576680
  579879
  581370
  592460
  603010
  612914
  616766
  623502
  624231
  636555
  644303
  680653
  680657
  692636
  692812
  714524
  715116
  716244
  819706
]
1.90 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс farm"
]
1.90 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex farm"
]
1.54 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс farm"
]

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.