Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.15 ms
(90.26%)
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
  391527
  391945
  391959
  392023
  404028
  417580
  418077
  418122
  419584
  423819
  424001
  434327
  435567
  435572
  435887
  436047
  438615
  439353
  439382
  442921
  445212
  448414
  448570
  448588
  449626
  450920
  451073
  452548
  452922
  452923
  454155
  456928
  458772
  459046
  459731
  460351
  460540
  463689
  463693
  465553
  469120
  470068
  473515
  475597
  477145
  477146
  479990
  481226
  493398
  493553
  495800
  500335
  504781
  508541
  509446
  510516
  512143
  513630
  517304
  518611
  518614
  519700
  520491
  520953
  521677
  523355
  523503
  523640
  525315
  526612
  528318
  532442
  534046
  534114
  536800
  546381
  546762
  547235
  548158
  551607
  554989
  555119
  556202
  556476
  558261
  561919
  562786
  567676
  568075
  569233
  571765
  572339
  573734
  577513
  590377
  595871
  597107
  597450
  597482
  600936
  602136
  669583
  678701
  683299
  719461
  722384
  739089
  741504
  742359
  751285
  757883
  761608
  770387
  776035
  787434
  792741
  801639
  805146
  825432
  827692
]
14.05 ms
(5.84%)
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
  434327
  520953
  495800
  523503
  448414
  493553
  442921
  477146
  418122
  391959
  741504
  404028
  595871
  504781
  463689
  518614
  534046
  448588
  456928
  449626
  475597
  509446
  512143
  597450
  493398
  805146
  436047
  435567
  391527
  518611
  536800
  562786
  551607
  597107
  481226
  477145
  827692
  825432
  571765
  567676
  438615
  419584
  450920
  435887
  445212
  452922
  454155
  452548
  418077
  452923
  500335
  561919
  479990
  448570
  520491
  523355
  439382
  546381
  569233
  556202
  460351
  463693
  526612
  521677
  590377
  678701
  459731
  435572
  508541
  683299
  669583
  751285
  787434
  459046
  469120
  391945
  460540
  528318
  525315
  572339
  577513
  417580
  458772
  470068
  510516
  532442
  547235
  556476
  568075
  722384
  548158
  602136
  770387
  439353
  451073
  473515
  423819
  534114
  519700
  719461
  554989
  597482
  600936
  801639
  757883
  761608
  739089
  742359
  776035
  792741
  513630
  523640
  517304
  558261
  573734
  546762
  555119
  392023
  424001
  465553
]
2.77 ms
(1.15%)
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
  391527
  391945
  391959
  392023
  404028
  417580
  418077
  418122
  419584
  423819
  424001
  434327
  435567
  435572
  435887
  436047
  438615
  439353
  439382
  442921
  445212
  448414
  448570
  448588
  449626
  450920
  451073
  452548
  452922
  452923
  454155
  456928
  458772
  459046
  459731
  460351
  460540
  463689
  463693
  465553
  469120
  470068
  473515
  475597
  477145
  477146
  479990
  481226
  493398
  493553
  495800
  500335
  504781
  508541
  509446
  510516
  512143
  513630
  517304
  518611
  518614
  519700
  520491
  520953
  521677
  523355
  523503
  523640
  525315
  526612
  528318
  532442
  534046
  534114
  536800
  546381
  546762
  547235
  548158
  551607
  554989
  555119
  556202
  556476
  558261
  561919
  562786
  567676
  568075
  569233
  571765
  572339
  573734
  577513
  590377
  595871
  597107
  597450
  597482
  600936
  602136
  669583
  678701
  683299
  719461
  722384
  739089
  741504
  742359
  751285
  757883
  761608
  770387
  776035
  787434
  792741
  801639
  805146
  825432
  827692
]
1.97 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"девушки украины дилдÐâ…"
]
1.84 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк русск дилд"
]
1.44 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.57%)
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.