Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.57 ms
(84.39%)
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
  95991
  411313
  425745
  426145
  426150
  427108
  427469
  435434
  438769
  444691
  444900
  446118
  446449
  446604
  456196
  457280
  457340
  458066
  458286
  458810
  460548
  461415
  461562
  462038
  462089
  463161
  463654
  464503
  468412
  468959
  471935
  472296
  473523
  476567
  476609
  478890
  480140
  483238
  485588
  485663
  486978
  487380
  489702
  491307
  491705
  491723
  492505
  493387
  494371
  494822
  495622
  497573
  499441
  500397
  501303
  501747
  501912
  501923
  504271
  504834
  505105
  507007
  507877
  508513
  509180
  516914
  518722
  522118
  524428
  524691
  524708
  525759
  526239
  527713
  527969
  534126
  546377
  549769
  553974
  556715
  557940
  558846
  558850
  558999
  560977
  561988
  564803
  566554
  568845
  573817
  573959
  574585
  574838
  575059
  580678
  584781
  586057
  590375
  597215
  609641
  614487
  673415
  676951
  693246
  709994
  713928
  729442
  740157
  758365
  764806
  773399
  779247
  781061
  782350
  804817
  807504
  810783
  811611
  814562
  825555
]
15.08 ms
(9.39%)
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
  492505
  524708
  807504
  758365
  476609
  468412
  463654
  458810
  573959
  461562
  462089
  500397
  491307
  709994
  810783
  458066
  464503
  446118
  480140
  825555
  693246
  558999
  444900
  476567
  461415
  493387
  501303
  509180
  501747
  501923
  524691
  713928
  673415
  804817
  740157
  609641
  411313
  553974
  764806
  773399
  782350
  458286
  549769
  568845
  456196
  457280
  501912
  507007
  526239
  485663
  486978
  516914
  556715
  426145
  95991
  597215
  491705
  590375
  471935
  472296
  527713
  489702
  427108
  426150
  504834
  525759
  507877
  508513
  446449
  483238
  487380
  504271
  584781
  779247
  729442
  781061
  522118
  425745
  444691
  446604
  485588
  527969
  546377
  811611
  457340
  814562
  574838
  573817
  499441
  473523
  575059
  557940
  561988
  574585
  586057
  505105
  558846
  676951
  494822
  558850
  524428
  494371
  478890
  468959
  460548
  614487
  427469
  497573
  566554
  438769
  518722
  495622
  560977
  564803
  463161
  435434
  491723
  534126
  580678
  462038
]
3.10 ms
(1.93%)
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
  95991
  411313
  425745
  426145
  426150
  427108
  427469
  435434
  438769
  444691
  444900
  446118
  446449
  446604
  456196
  457280
  457340
  458066
  458286
  458810
  460548
  461415
  461562
  462038
  462089
  463161
  463654
  464503
  468412
  468959
  471935
  472296
  473523
  476567
  476609
  478890
  480140
  483238
  485588
  485663
  486978
  487380
  489702
  491307
  491705
  491723
  492505
  493387
  494371
  494822
  495622
  497573
  499441
  500397
  501303
  501747
  501912
  501923
  504271
  504834
  505105
  507007
  507877
  508513
  509180
  516914
  518722
  522118
  524428
  524691
  524708
  525759
  526239
  527713
  527969
  534126
  546377
  549769
  553974
  556715
  557940
  558846
  558850
  558999
  560977
  561988
  564803
  566554
  568845
  573817
  573959
  574585
  574838
  575059
  580678
  584781
  586057
  590375
  597215
  609641
  614487
  673415
  676951
  693246
  709994
  713928
  729442
  740157
  758365
  764806
  773399
  779247
  781061
  782350
  804817
  807504
  810783
  811611
  814562
  825555
]
1.89 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс с русской девушк…"
]
1.81 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс русск девушк"
]
1.67 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.96%)
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.