Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.41 ms
(84.12%)
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
  41912
  110884
  117844
  118002
  391977
  392005
  392841
  393047
  401841
  402619
  402625
  410239
  414269
  415329
  420193
  420835
  428179
  428224
  429957
  435539
  439023
  439031
  439038
  441113
  441799
  444079
  445406
  447973
  449068
  452547
  454981
  456239
  460084
  462580
  471330
  478904
  483704
  486767
  487519
  497686
  502212
  505590
  506321
  506516
  506839
  507284
  508909
  509422
  511343
  512072
  512935
  514867
  514876
  515435
  517724
  519698
  521814
  530942
  531789
  531880
  534540
  534557
  534566
  540593
  547483
  547486
  547855
  549081
  550144
  550938
  559355
  559787
  571961
  575601
  576545
  576899
  576916
  576932
  576989
  581006
  581477
  586914
  587851
  590289
  600087
  610061
  615693
  618259
  618276
  630732
  641997
  658789
  660373
  660405
  660411
  660412
  666016
  668688
  669012
  669056
  669071
  671018
  671045
  672950
  680423
  686106
  689074
  713142
  717535
  736302
  744405
  745125
  745136
  752667
  770265
  782790
  786911
  799782
  800282
  825791
]
15.82 ms
(10.05%)
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
  392005
  391977
  392841
  506516
  506839
  508909
  517724
  519698
  669012
  559787
  576916
  590289
  540593
  110884
  414269
  435539
  441799
  441113
  445406
  447973
  460084
  502212
  530942
  534566
  531789
  531880
  534557
  547486
  547483
  576932
  549081
  559355
  660405
  669071
  669056
  680423
  713142
  717535
  658789
  660411
  666016
  671018
  671045
  686106
  586914
  587851
  600087
  782790
  770265
  752667
  745125
  745136
  615693
  618276
  439023
  454981
  505590
  462580
  410239
  689074
  471330
  444079
  117844
  118002
  547855
  744405
  736302
  456239
  668688
  514867
  402619
  825791
  393047
  41912
  420835
  571961
  576989
  610061
  618259
  800282
  402625
  439038
  428179
  439031
  428224
  449068
  452547
  497686
  512072
  512935
  581006
  660412
  660373
  672950
  576545
  581477
  641997
  786911
  415329
  478904
  483704
  511343
  487519
  509422
  575601
  401841
  420193
  534540
  506321
  429957
  576899
  550144
  550938
  630732
  799782
  486767
  515435
  507284
  514876
  521814
]
2.49 ms
(1.58%)
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
  41912
  110884
  117844
  118002
  391977
  392005
  392841
  393047
  401841
  402619
  402625
  410239
  414269
  415329
  420193
  420835
  428179
  428224
  429957
  435539
  439023
  439031
  439038
  441113
  441799
  444079
  445406
  447973
  449068
  452547
  454981
  456239
  460084
  462580
  471330
  478904
  483704
  486767
  487519
  497686
  502212
  505590
  506321
  506516
  506839
  507284
  508909
  509422
  511343
  512072
  512935
  514867
  514876
  515435
  517724
  519698
  521814
  530942
  531789
  531880
  534540
  534557
  534566
  540593
  547483
  547486
  547855
  549081
  550144
  550938
  559355
  559787
  571961
  575601
  576545
  576899
  576916
  576932
  576989
  581006
  581477
  586914
  587851
  590289
  600087
  610061
  615693
  618259
  618276
  630732
  641997
  658789
  660373
  660405
  660411
  660412
  666016
  668688
  669012
  669056
  669071
  671018
  671045
  672950
  680423
  686106
  689074
  713142
  717535
  736302
  744405
  745125
  745136
  752667
  770265
  782790
  786911
  799782
  800282
  825791
]
1.92 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting wife amateur"
]
1.65 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фистинг жен любительск"
]
1.64 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг жен любительск"
]
1.48 ms
(0.94%)
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.