Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.73 ms
(82.45%)
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
  3417
  7051
  68246
  80370
  172514
  185753
  229361
  233692
  325253
  337061
  382545
  384025
  384514
  384801
  388127
  388464
  388546
  388888
  389146
  389314
  390888
  391567
  391684
  395381
  395643
  396087
  396801
  397366
  397388
  398405
  398934
  400941
  401139
  402239
  402729
  402929
  403257
  403870
  405114
  405556
  405749
  406362
  406981
  407856
  408798
  410254
  411125
  414736
  414924
  422434
  422487
  426090
  431603
  431724
  431735
  433981
  441530
  441804
  442164
  442997
  445002
  447335
  447940
  449144
  453689
  453895
  456918
  456945
  457352
  457897
  459843
  460397
  461463
  463133
  469654
  470101
  471402
  475048
  475237
  476278
  477258
  479243
  488070
  488950
  489881
  496399
  499636
  505048
  507018
  509020
  510634
  512302
  512320
  514196
  522535
  523699
  524415
  526483
  526651
  547306
  552161
  565430
  566122
  570028
  573953
  591677
  595405
  597516
  654722
  656789
  657352
  659554
  725914
  742138
  780806
  783155
  784852
  787195
  787351
  801141
]
15.07 ms
(10.38%)
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
  591677
  384025
  382545
  433981
  461463
  422487
  431735
  442164
  401139
  422434
  445002
  414924
  469654
  509020
  510634
  172514
  402929
  456945
  526483
  479243
  488070
  547306
  657352
  654722
  595405
  780806
  784852
  783155
  801141
  742138
  384514
  403870
  411125
  431724
  233692
  389146
  397388
  389314
  337061
  406362
  414736
  514196
  229361
  441804
  489881
  449144
  570028
  552161
  391567
  396801
  426090
  403257
  456918
  524415
  400941
  407856
  384801
  390888
  475237
  397366
  398934
  453689
  499636
  523699
  325253
  68246
  7051
  3417
  388464
  388888
  388127
  408798
  431603
  453895
  457897
  488950
  459843
  496399
  470101
  725914
  787351
  441530
  475048
  405749
  447335
  185753
  447940
  388546
  402239
  457352
  460397
  526651
  507018
  512302
  522535
  405556
  659554
  573953
  406981
  512320
  787195
  402729
  80370
  395381
  391684
  565430
  398405
  477258
  566122
  656789
  597516
  396087
  505048
  410254
  463133
  405114
  442997
  471402
  476278
  395643
]
3.24 ms
(2.23%)
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
  3417
  7051
  68246
  80370
  172514
  185753
  229361
  233692
  325253
  337061
  382545
  384025
  384514
  384801
  388127
  388464
  388546
  388888
  389146
  389314
  390888
  391567
  391684
  395381
  395643
  396087
  396801
  397366
  397388
  398405
  398934
  400941
  401139
  402239
  402729
  402929
  403257
  403870
  405114
  405556
  405749
  406362
  406981
  407856
  408798
  410254
  411125
  414736
  414924
  422434
  422487
  426090
  431603
  431724
  431735
  433981
  441530
  441804
  442164
  442997
  445002
  447335
  447940
  449144
  453689
  453895
  456918
  456945
  457352
  457897
  459843
  460397
  461463
  463133
  469654
  470101
  471402
  475048
  475237
  476278
  477258
  479243
  488070
  488950
  489881
  496399
  499636
  505048
  507018
  509020
  510634
  512302
  512320
  514196
  522535
  523699
  524415
  526483
  526651
  547306
  552161
  565430
  566122
  570028
  573953
  591677
  595405
  597516
  654722
  656789
  657352
  659554
  725914
  742138
  780806
  783155
  784852
  787195
  787351
  801141
]
1.90 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "девушка парня"
]
1.80 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк парен"
]
1.70 ms
(1.17%)
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.