Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.13 ms
(49.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
179.43 ms
(43.44%)
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
  382120
  390980
  410602
  413826
  419933
  420291
  420432
  420700
  422448
  424751
  424908
  428305
  430709
  434310
  435343
  436178
  443323
  447565
  448816
  452014
  454581
  455898
  464725
  465120
  465171
  471691
  475102
  483717
  484673
  484692
  488734
  491952
  495273
  495558
  496613
  499182
  502630
  509078
  511810
  511838
  514113
  514845
  516684
  517431
  518403
  519592
  522307
  524213
  529854
  530494
  531105
  531123
  532680
  536666
  537204
  537679
  539938
  543772
  544838
  545611
  565263
  565276
  582179
  585999
  590958
  596570
  597257
  597750
  599966
  602614
  613843
  621252
  628117
  628334
  628371
  630533
  631245
  631597
  632586
  632628
  633772
  633796
  634780
  639716
  639760
  639798
  640813
  644913
  647854
  647860
  647993
  648840
  649953
  663412
  663437
  663441
  666525
  677777
  678532
  679772
  680108
  687339
  695199
  696582
  702164
  719104
  720198
  720698
  721203
  747313
  747439
  758615
  758723
  765896
  770314
  770404
  779840
  785864
  806668
  817507
]
20.13 ms
(4.87%)
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
  747439
  747313
  765896
  420432
  465120
  420700
  382120
  428305
  502630
  509078
  514845
  424908
  465171
  597750
  475102
  517431
  491952
  511810
  529854
  539938
  530494
  702164
  424751
  647860
  628371
  448816
  484673
  516684
  419933
  817507
  518403
  537204
  471691
  544838
  678532
  696582
  647993
  628334
  628117
  488734
  585999
  621252
  435343
  483717
  537679
  565263
  663412
  680108
  687339
  695199
  720198
  720698
  721203
  663441
  633772
  758723
  785864
  758615
  770404
  422448
  454581
  499182
  420291
  443323
  644913
  647854
  666525
  582179
  599966
  639798
  640813
  639716
  639760
  632628
  413826
  519592
  514113
  495273
  524213
  531105
  543772
  522307
  511838
  536666
  602614
  430709
  495558
  631597
  633796
  434310
  452014
  455898
  532680
  531123
  545611
  565276
  649953
  677777
  630533
  634780
  436178
  484692
  464725
  496613
  648840
  663437
  679772
  719104
  590958
  597257
  613843
  596570
  631245
  632586
  779840
  770314
  806668
  390980
  410602
  447565
]
3.20 ms
(0.77%)
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
  382120
  390980
  410602
  413826
  419933
  420291
  420432
  420700
  422448
  424751
  424908
  428305
  430709
  434310
  435343
  436178
  443323
  447565
  448816
  452014
  454581
  455898
  464725
  465120
  465171
  471691
  475102
  483717
  484673
  484692
  488734
  491952
  495273
  495558
  496613
  499182
  502630
  509078
  511810
  511838
  514113
  514845
  516684
  517431
  518403
  519592
  522307
  524213
  529854
  530494
  531105
  531123
  532680
  536666
  537204
  537679
  539938
  543772
  544838
  545611
  565263
  565276
  582179
  585999
  590958
  596570
  597257
  597750
  599966
  602614
  613843
  621252
  628117
  628334
  628371
  630533
  631245
  631597
  632586
  632628
  633772
  633796
  634780
  639716
  639760
  639798
  640813
  644913
  647854
  647860
  647993
  648840
  649953
  663412
  663437
  663441
  666525
  677777
  678532
  679772
  680108
  687339
  695199
  696582
  702164
  719104
  720198
  720698
  721203
  747313
  747439
  758615
  758723
  765896
  770314
  770404
  779840
  785864
  806668
  817507
]
1.85 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen pussy dildo"
]
1.70 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen pussy дилд"
]
1.58 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen pussy дилд"
]

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.