Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.72 ms
(80.22%)
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
  187819
  188028
  233187
  381903
  386218
  387510
  388722
  395819
  401935
  404596
  405859
  411203
  411717
  412315
  415147
  419220
  424407
  424421
  428706
  429879
  430002
  442991
  450187
  451473
  456618
  461318
  466007
  466015
  466986
  467121
  471995
  472316
  476348
  477587
  478445
  479765
  486542
  491436
  495737
  497007
  499906
  500467
  505394
  505496
  511391
  517007
  517834
  518576
  519089
  522868
  523562
  524389
  524955
  526401
  529524
  530429
  535534
  541398
  545245
  547426
  554526
  555204
  555233
  555264
  555318
  555360
  555376
  571441
  583540
  586917
  590948
  592573
  592975
  598344
  600233
  604489
  604575
  606583
  622679
  622980
  628326
  665975
  670773
  671739
  690803
  690810
  699607
  700975
  703902
  710054
  715016
  718496
  720442
  724260
  731888
  737145
  758097
  761061
  761530
  777063
  788631
  794632
  796718
  800606
  805602
  806323
  810823
  812314
  814893
  815227
  815396
  816266
  816388
  816441
  816937
  817269
  817349
  817781
  818426
  823174
]
19.23 ms
(12.37%)
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
  814893
  815227
  816388
  816441
  816937
  817269
  817349
  817781
  815396
  478445
  524955
  517007
  535534
  670773
  699607
  690810
  628326
  604575
  810823
  800606
  805602
  731888
  777063
  419220
  428706
  758097
  405859
  806323
  486542
  703902
  401935
  430002
  477587
  555318
  188028
  600233
  788631
  812314
  761061
  622679
  796718
  500467
  461318
  187819
  404596
  466015
  524389
  411717
  499906
  555233
  518576
  466007
  529524
  545245
  592573
  491436
  424407
  429879
  233187
  495737
  386218
  530429
  592975
  794632
  583540
  737145
  442991
  818426
  467121
  497007
  519089
  526401
  511391
  555264
  547426
  555360
  571441
  700975
  671739
  555204
  604489
  590948
  395819
  387510
  718496
  412315
  505496
  554526
  476348
  466986
  665975
  415147
  505394
  522868
  456618
  555376
  598344
  606583
  586917
  388722
  479765
  381903
  451473
  472316
  690803
  450187
  471995
  411203
  523562
  424421
  541398
  816266
  823174
  517834
  715016
  720442
  710054
  622980
  724260
  761530
]
3.54 ms
(2.28%)
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
  187819
  188028
  233187
  381903
  386218
  387510
  388722
  395819
  401935
  404596
  405859
  411203
  411717
  412315
  415147
  419220
  424407
  424421
  428706
  429879
  430002
  442991
  450187
  451473
  456618
  461318
  466007
  466015
  466986
  467121
  471995
  472316
  476348
  477587
  478445
  479765
  486542
  491436
  495737
  497007
  499906
  500467
  505394
  505496
  511391
  517007
  517834
  518576
  519089
  522868
  523562
  524389
  524955
  526401
  529524
  530429
  535534
  541398
  545245
  547426
  554526
  555204
  555233
  555264
  555318
  555360
  555376
  571441
  583540
  586917
  590948
  592573
  592975
  598344
  600233
  604489
  604575
  606583
  622679
  622980
  628326
  665975
  670773
  671739
  690803
  690810
  699607
  700975
  703902
  710054
  715016
  718496
  720442
  724260
  731888
  737145
  758097
  761061
  761530
  777063
  788631
  794632
  796718
  800606
  805602
  806323
  810823
  812314
  814893
  815227
  815396
  816266
  816388
  816441
  816937
  817269
  817349
  817781
  818426
  823174
]
2.26 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал волосатые зрелки…"
]
2.02 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал волосатая зрелая женщин"
]
1.87 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал волосатая зрелая женщин"
]
1.82 ms
(1.17%)
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.