Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.16 ms
(81.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
  3512
  3599
  58636
  146006
  146078
  187928
  386218
  387415
  388913
  389697
  395513
  395660
  396041
  397930
  402876
  407384
  409371
  409934
  411604
  411720
  411738
  412976
  419147
  419524
  424421
  443278
  450782
  452925
  452968
  454890
  457459
  457631
  458842
  460003
  460659
  466893
  468835
  469113
  469489
  470215
  474104
  474478
  474862
  475904
  476224
  480478
  483333
  484358
  484379
  490404
  491118
  495038
  498456
  500412
  502868
  503952
  507844
  508698
  510844
  518901
  535324
  537558
  541626
  548065
  557340
  558700
  563088
  563939
  570891
  571133
  578162
  587184
  589619
  590260
  591044
  599218
  601840
  604488
  605340
  620159
  620172
  629528
  640677
  664857
  703097
  708774
  714386
  714414
  715473
  716331
  720275
  726572
  726588
  728119
  728254
  728290
  729124
  730822
  733073
  733319
  740117
  741611
  741764
  744191
  744806
  746673
  747071
  770120
  771164
  775436
  777361
  778527
  783777
  789204
  796458
  797236
  797266
  802651
  808500
  808506
]
15.71 ms
(10.98%)
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
  703097
  714386
  664857
  708774
  716331
  640677
  590260
  599218
  601840
  604488
  605340
  620159
  620172
  740117
  726588
  726572
  728254
  771164
  741611
  714414
  715473
  775436
  777361
  783777
  802651
  808500
  808506
  397930
  411720
  469113
  187928
  452925
  457631
  500412
  541626
  733073
  744191
  396041
  146006
  58636
  3512
  3599
  389697
  407384
  535324
  563088
  720275
  548065
  570891
  629528
  591044
  797236
  778527
  744806
  789204
  796458
  797266
  730822
  728119
  728290
  729124
  746673
  770120
  747071
  387415
  587184
  503952
  507844
  491118
  537558
  469489
  495038
  386218
  395513
  388913
  402876
  411604
  412976
  419147
  411738
  409934
  452968
  474862
  476224
  480478
  450782
  458842
  460003
  510844
  558700
  563939
  571133
  578162
  557340
  589619
  733319
  741764
  409371
  460659
  474104
  474478
  483333
  498456
  484358
  502868
  508698
  484379
  518901
  419524
  424421
  454890
  457459
  443278
  470215
  475904
  490404
  468835
  466893
  146078
  395660
]
2.75 ms
(1.92%)
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
  3512
  3599
  58636
  146006
  146078
  187928
  386218
  387415
  388913
  389697
  395513
  395660
  396041
  397930
  402876
  407384
  409371
  409934
  411604
  411720
  411738
  412976
  419147
  419524
  424421
  443278
  450782
  452925
  452968
  454890
  457459
  457631
  458842
  460003
  460659
  466893
  468835
  469113
  469489
  470215
  474104
  474478
  474862
  475904
  476224
  480478
  483333
  484358
  484379
  490404
  491118
  495038
  498456
  500412
  502868
  503952
  507844
  508698
  510844
  518901
  535324
  537558
  541626
  548065
  557340
  558700
  563088
  563939
  570891
  571133
  578162
  587184
  589619
  590260
  591044
  599218
  601840
  604488
  605340
  620159
  620172
  629528
  640677
  664857
  703097
  708774
  714386
  714414
  715473
  716331
  720275
  726572
  726588
  728119
  728254
  728290
  729124
  730822
  733073
  733319
  740117
  741611
  741764
  744191
  744806
  746673
  747071
  770120
  771164
  775436
  777361
  778527
  783777
  789204
  796458
  797236
  797266
  802651
  808500
  808506
]
2.10 ms
(1.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные зрелая женщин"
]
2.09 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural mature woman"
]
1.76 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(1.07%)
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.