Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.18 ms
(81.27%)
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
  396345
  397557
  406701
  412758
  423876
  428049
  428300
  435502
  441158
  443554
  443968
  444257
  445104
  445926
  450315
  454479
  455749
  455968
  458682
  463832
  466226
  466879
  475312
  477929
  477940
  478525
  480851
  488532
  491120
  506239
  511205
  514304
  517452
  517597
  518611
  522547
  523362
  529294
  530152
  532355
  547987
  548011
  548036
  556577
  567063
  580642
  585987
  598101
  609109
  612229
  620089
  625768
  634826
  643334
  649528
  666396
  672903
  674197
  682248
  693419
  696982
  701476
  702369
  705781
  712672
  714193
  714277
  725478
  731003
  731156
  732732
  733520
  733554
  733570
  736783
  739565
  741776
  741781
  742608
  742733
  742896
  743797
  744367
  744393
  744415
  744431
  745946
  745951
  746713
  747219
  754948
  757541
  758230
  758297
  759768
  761373
  761815
  762223
  763174
  763251
  768387
  770242
  782010
  792604
  795033
  800732
  801977
  802782
  803424
  803431
  803441
  806295
  808062
  808531
  808654
  811093
  813814
  819633
  824067
  826781
]
22.67 ms
(12.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
  826781
  813814
  672903
  693419
  674197
  714277
  612229
  808062
  803431
  731003
  733570
  744431
  746713
  747219
  762223
  800732
  808531
  725478
  743797
  744393
  744415
  745946
  739565
  741781
  757541
  763251
  731156
  742733
  744367
  758297
  761815
  702369
  803441
  806295
  480851
  397557
  522547
  819633
  443554
  580642
  475312
  714193
  478525
  598101
  455968
  491120
  445104
  454479
  514304
  803424
  754948
  759768
  733554
  458682
  547987
  548011
  444257
  428049
  450315
  795033
  768387
  763174
  455749
  567063
  463832
  466226
  412758
  585987
  620089
  634826
  782010
  802782
  745951
  428300
  477929
  477940
  406701
  445926
  466879
  517452
  529294
  506239
  435502
  530152
  517597
  523362
  682248
  705781
  712672
  666396
  701476
  649528
  696982
  609109
  643334
  625768
  801977
  736783
  742608
  741776
  742896
  770242
  758230
  761373
  792604
  443968
  532355
  423876
  518611
  548036
  556577
  824067
  732732
  733520
  808654
  811093
  511205
  488532
  396345
  441158
]
2.37 ms
(1.35%)
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
  396345
  397557
  406701
  412758
  423876
  428049
  428300
  435502
  441158
  443554
  443968
  444257
  445104
  445926
  450315
  454479
  455749
  455968
  458682
  463832
  466226
  466879
  475312
  477929
  477940
  478525
  480851
  488532
  491120
  506239
  511205
  514304
  517452
  517597
  518611
  522547
  523362
  529294
  530152
  532355
  547987
  548011
  548036
  556577
  567063
  580642
  585987
  598101
  609109
  612229
  620089
  625768
  634826
  643334
  649528
  666396
  672903
  674197
  682248
  693419
  696982
  701476
  702369
  705781
  712672
  714193
  714277
  725478
  731003
  731156
  732732
  733520
  733554
  733570
  736783
  739565
  741776
  741781
  742608
  742733
  742896
  743797
  744367
  744393
  744415
  744431
  745946
  745951
  746713
  747219
  754948
  757541
  758230
  758297
  759768
  761373
  761815
  762223
  763174
  763251
  768387
  770242
  782010
  792604
  795033
  800732
  801977
  802782
  803424
  803431
  803441
  806295
  808062
  808531
  808654
  811093
  813814
  819633
  824067
  826781
]
2.20 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby webcam blowjob"
]
2.01 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby вебкамер минет оральн секс"
]
1.93 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby вебкамер минет оральн секс"
]
1.80 ms
(1.02%)
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.