Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.60 ms
(56.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking pussy compilation"
]
131.07 ms
(35.81%)
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
  387055
  421093
  421162
  421654
  425829
  425971
  430306
  430572
  432766
  434933
  436829
  442276
  447454
  449021
  450654
  454186
  454765
  455816
  455847
  455857
  456525
  457590
  461271
  463825
  463846
  465147
  465175
  466103
  466801
  468154
  468716
  470918
  471162
  474520
  474549
  475080
  476098
  476276
  476706
  477993
  482559
  483152
  483220
  484369
  485131
  488330
  490034
  491248
  491678
  494500
  495212
  497358
  502505
  503105
  504121
  509114
  511011
  511422
  512955
  513149
  514721
  517740
  519653
  520171
  522107
  522344
  522779
  525747
  526170
  527443
  528669
  535132
  536270
  539532
  539533
  540241
  554770
  556632
  556945
  557204
  558469
  563220
  569119
  576519
  581035
  586493
  594106
  606618
  640377
  649836
  650053
  650796
  656281
  683237
  690884
  694203
  697912
  715509
  717083
  721739
  743021
  759840
  768378
  771958
  774009
  777036
  795437
  803017
  803373
  804462
  805112
  808500
  808527
  813987
  814347
  814849
  815269
  817131
  817354
  827080
]
20.81 ms
(5.69%)
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
  808500
  442276
  432766
  421162
  430572
  454186
  474549
  490034
  455816
  468716
  471162
  525747
  502505
  468154
  557204
  594106
  586493
  477993
  436829
  455847
  470918
  457590
  434933
  447454
  511422
  522779
  527443
  484369
  514721
  526170
  488330
  494500
  520171
  814849
  463846
  466801
  511011
  512955
  517740
  519653
  556632
  563220
  581035
  649836
  650796
  576519
  774009
  795437
  804462
  461271
  454765
  495212
  513149
  777036
  476098
  476706
  421093
  483152
  465175
  449021
  554770
  683237
  425829
  421654
  466103
  491678
  522107
  456525
  558469
  656281
  556945
  808527
  425971
  813987
  817354
  817131
  827080
  815269
  450654
  539533
  509114
  528669
  535132
  536270
  539532
  540241
  522344
  569119
  650053
  717083
  690884
  694203
  697912
  721739
  606618
  640377
  803373
  805112
  743021
  771958
  803017
  759840
  768378
  715509
  476276
  483220
  497358
  387055
  430306
  814347
  455857
  475080
  485131
  463825
  482559
  491248
  465147
  474520
  504121
  503105
]
3.05 ms
(0.83%)
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
  387055
  421093
  421162
  421654
  425829
  425971
  430306
  430572
  432766
  434933
  436829
  442276
  447454
  449021
  450654
  454186
  454765
  455816
  455847
  455857
  456525
  457590
  461271
  463825
  463846
  465147
  465175
  466103
  466801
  468154
  468716
  470918
  471162
  474520
  474549
  475080
  476098
  476276
  476706
  477993
  482559
  483152
  483220
  484369
  485131
  488330
  490034
  491248
  491678
  494500
  495212
  497358
  502505
  503105
  504121
  509114
  511011
  511422
  512955
  513149
  514721
  517740
  519653
  520171
  522107
  522344
  522779
  525747
  526170
  527443
  528669
  535132
  536270
  539532
  539533
  540241
  554770
  556632
  556945
  557204
  558469
  563220
  569119
  576519
  581035
  586493
  594106
  606618
  640377
  649836
  650053
  650796
  656281
  683237
  690884
  694203
  697912
  715509
  717083
  721739
  743021
  759840
  768378
  771958
  774009
  777036
  795437
  803017
  803373
  804462
  805112
  808500
  808527
  813987
  814347
  814849
  815269
  817131
  817354
  827080
]
1.61 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза pussy подборк"
]
1.48 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза pussy подборк"
]
1.44 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.