Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.19 ms
(85.06%)
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
  234200
  383660
  386568
  395625
  395895
  401362
  407208
  408413
  409252
  409640
  412378
  421695
  422925
  427187
  428424
  430342
  443581
  446937
  447483
  452063
  452068
  452446
  457387
  458462
  459248
  459803
  460954
  463726
  465186
  465856
  466027
  466831
  468011
  468379
  468594
  468945
  469574
  470703
  475585
  476228
  476931
  479197
  481323
  481684
  483571
  486027
  486301
  486883
  487198
  488877
  489623
  490448
  491271
  492592
  494397
  495678
  495719
  496715
  497766
  498852
  499823
  499849
  502736
  503887
  503901
  504352
  506737
  509434
  512785
  513139
  519241
  519386
  519928
  520172
  520660
  521092
  521230
  522472
  523573
  527869
  528884
  536647
  542241
  543114
  543442
  543708
  547900
  548230
  548297
  551249
  555341
  555790
  556841
  557022
  558841
  560086
  560088
  560958
  562714
  563212
  566385
  569666
  573311
  573406
  573763
  576703
  581380
  583835
  589775
  590355
  591288
  591795
  592660
  593405
  596234
  597094
  620108
  682537
  731371
  742280
]
18.64 ms
(9.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
  560088
  590355
  492592
  495678
  457387
  470703
  497766
  463726
  573406
  543442
  555790
  620108
  519928
  491271
  494397
  521092
  506737
  486883
  428424
  521230
  519386
  547900
  562714
  589775
  509434
  409640
  504352
  408413
  487198
  513139
  469574
  566385
  551249
  581380
  593405
  597094
  742280
  409252
  421695
  465856
  475585
  527869
  452063
  476931
  468945
  486027
  468011
  468379
  556841
  443581
  489623
  573311
  401362
  446937
  386568
  452446
  523573
  536647
  459248
  479197
  583835
  596234
  548230
  234200
  481323
  563212
  591288
  502736
  499849
  466831
  466027
  447483
  476228
  495719
  512785
  407208
  548297
  560086
  499823
  490448
  498852
  558841
  560958
  503901
  452068
  520172
  592660
  520660
  569666
  483571
  481684
  543114
  682537
  519241
  412378
  465186
  458462
  427187
  528884
  486301
  383660
  496715
  488877
  430342
  395895
  460954
  468594
  543708
  555341
  542241
  557022
  395625
  522472
  576703
  731371
  422925
  459803
  573763
  591795
  503887
]
3.46 ms
(1.81%)
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
  234200
  383660
  386568
  395625
  395895
  401362
  407208
  408413
  409252
  409640
  412378
  421695
  422925
  427187
  428424
  430342
  443581
  446937
  447483
  452063
  452068
  452446
  457387
  458462
  459248
  459803
  460954
  463726
  465186
  465856
  466027
  466831
  468011
  468379
  468594
  468945
  469574
  470703
  475585
  476228
  476931
  479197
  481323
  481684
  483571
  486027
  486301
  486883
  487198
  488877
  489623
  490448
  491271
  492592
  494397
  495678
  495719
  496715
  497766
  498852
  499823
  499849
  502736
  503887
  503901
  504352
  506737
  509434
  512785
  513139
  519241
  519386
  519928
  520172
  520660
  521092
  521230
  522472
  523573
  527869
  528884
  536647
  542241
  543114
  543442
  543708
  547900
  548230
  548297
  551249
  555341
  555790
  556841
  557022
  558841
  560086
  560088
  560958
  562714
  563212
  566385
  569666
  573311
  573406
  573763
  576703
  581380
  583835
  589775
  590355
  591288
  591795
  592660
  593405
  596234
  597094
  620108
  682537
  731371
  742280
]
1.82 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатый минет оральн секс"
]
1.52 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "волосатый минет"
]
1.47 ms
(0.77%)
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.