Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.81 ms
(54.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
154.97 ms
(40.10%)
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
  397811
  409227
  417337
  428809
  437258
  455614
  457698
  459525
  460699
  462297
  464231
  464508
  469212
  469332
  473074
  478569
  478885
  479241
  480111
  481455
  482772
  483902
  484044
  484753
  487028
  487464
  490952
  492593
  493550
  496003
  496427
  497687
  500055
  500897
  501669
  502260
  504033
  505109
  505201
  505618
  506179
  506604
  509916
  514179
  515838
  523776
  526740
  532215
  535247
  536840
  536967
  539994
  541121
  542345
  545058
  545104
  545821
  549178
  551478
  554516
  558108
  558519
  558556
  558652
  558668
  560000
  560952
  562385
  565004
  566296
  568228
  568342
  568955
  575286
  576981
  577541
  577884
  583064
  589212
  589989
  592725
  597634
  597786
  598412
  599710
  600941
  601721
  604943
  606894
  615427
  616674
  618046
  618249
  621163
  623063
  626345
  628525
  630116
  630726
  631719
  632780
  637959
  638000
  639951
  644901
  650875
  655294
  660080
  660441
  668771
  680254
  701253
  714629
  716841
  731239
  757971
  761553
  781246
  781291
  810382
]
13.77 ms
(3.56%)
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
  810382
  757971
  761553
  601721
  606894
  714629
  437258
  504033
  523776
  487464
  509916
  397811
  409227
  464231
  464508
  484044
  487028
  484753
  496003
  500897
  514179
  532215
  505618
  536840
  505201
  526740
  473074
  551478
  554516
  562385
  541121
  545821
  560952
  568342
  575286
  576981
  583064
  542345
  545058
  566296
  568955
  577884
  650875
  660441
  660080
  549178
  558519
  558556
  558668
  568228
  598412
  599710
  615427
  589989
  639951
  626345
  631719
  589212
  597634
  597786
  616674
  618249
  621163
  623063
  637959
  781291
  781246
  731239
  618046
  632780
  638000
  701253
  462297
  469332
  469212
  460699
  478885
  417337
  479241
  481455
  455614
  505109
  501669
  502260
  500055
  515838
  457698
  459525
  478569
  536967
  506179
  535247
  558108
  565004
  577541
  558652
  560000
  655294
  668771
  680254
  592725
  604943
  600941
  628525
  630116
  630726
  716841
  490952
  496427
  428809
  644901
  545104
  539994
  483902
  482772
  480111
  492593
  493550
  497687
  506604
]
3.06 ms
(0.79%)
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
  397811
  409227
  417337
  428809
  437258
  455614
  457698
  459525
  460699
  462297
  464231
  464508
  469212
  469332
  473074
  478569
  478885
  479241
  480111
  481455
  482772
  483902
  484044
  484753
  487028
  487464
  490952
  492593
  493550
  496003
  496427
  497687
  500055
  500897
  501669
  502260
  504033
  505109
  505201
  505618
  506179
  506604
  509916
  514179
  515838
  523776
  526740
  532215
  535247
  536840
  536967
  539994
  541121
  542345
  545058
  545104
  545821
  549178
  551478
  554516
  558108
  558519
  558556
  558652
  558668
  560000
  560952
  562385
  565004
  566296
  568228
  568342
  568955
  575286
  576981
  577541
  577884
  583064
  589212
  589989
  592725
  597634
  597786
  598412
  599710
  600941
  601721
  604943
  606894
  615427
  616674
  618046
  618249
  621163
  623063
  626345
  628525
  630116
  630726
  631719
  632780
  637959
  638000
  639951
  644901
  650875
  655294
  660080
  660441
  668771
  680254
  701253
  714629
  716841
  731239
  757971
  761553
  781246
  781291
  810382
]
1.78 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "телефон секс"
]
1.57 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "telephone sex"
]
1.50 ms
(0.39%)
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.