Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.05 ms
(86.60%)
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
  388858
  400015
  401996
  402217
  412733
  415890
  429145
  429174
  431515
  436478
  448219
  451459
  452980
  455714
  455775
  461887
  467915
  474376
  486833
  491857
  501746
  501799
  504594
  505183
  511080
  512147
  516373
  521202
  521240
  523695
  524602
  535205
  543457
  545023
  548720
  550396
  552132
  553276
  553989
  554213
  554628
  555806
  558496
  565069
  566785
  567184
  571381
  571497
  576090
  576096
  579263
  579421
  580609
  583542
  586757
  590837
  594048
  594076
  596224
  596263
  597899
  598814
  598991
  599410
  607798
  610498
  623429
  627249
  653763
  662011
  673704
  676444
  676448
  676927
  677006
  677028
  677042
  677048
  683380
  685940
  687913
  689442
  699487
  700735
  701012
  701967
  705789
  709228
  710170
  713919
  715247
  723373
  724285
  740910
  741935
  741958
  741966
  741973
  741998
  744504
  744511
  747153
  749468
  755854
  755975
  759541
  764875
  765663
  768812
  771591
  787943
  797767
  799289
  801889
  802275
  802841
  812155
  814455
  814657
  823707
]
15.04 ms
(7.70%)
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
  461887
  452980
  579421
  558496
  543457
  677006
  677042
  677048
  699487
  713919
  715247
  676444
  687913
  700735
  710170
  662011
  676448
  677028
  709228
  548720
  580609
  596263
  598991
  610498
  596224
  586757
  607798
  799289
  724285
  740910
  741998
  797767
  812155
  741935
  741958
  741966
  755975
  744504
  771591
  749468
  765663
  701012
  701967
  400015
  436478
  451459
  474376
  429145
  455714
  402217
  523695
  501799
  511080
  521202
  524602
  486833
  501746
  512147
  388858
  401996
  429174
  412733
  431515
  415890
  814455
  814657
  823707
  455775
  467915
  448219
  516373
  505183
  504594
  521240
  535205
  491857
  553276
  554628
  555806
  565069
  583542
  566785
  567184
  576090
  576096
  579263
  545023
  552132
  653763
  673704
  676927
  683380
  685940
  689442
  723373
  550396
  553989
  554213
  571381
  571497
  590837
  594076
  597899
  599410
  623429
  594048
  598814
  802275
  801889
  755854
  787943
  802841
  741973
  747153
  759541
  764875
  744511
  768812
  627249
  705789
]
4.13 ms
(2.12%)
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
  388858
  400015
  401996
  402217
  412733
  415890
  429145
  429174
  431515
  436478
  448219
  451459
  452980
  455714
  455775
  461887
  467915
  474376
  486833
  491857
  501746
  501799
  504594
  505183
  511080
  512147
  516373
  521202
  521240
  523695
  524602
  535205
  543457
  545023
  548720
  550396
  552132
  553276
  553989
  554213
  554628
  555806
  558496
  565069
  566785
  567184
  571381
  571497
  576090
  576096
  579263
  579421
  580609
  583542
  586757
  590837
  594048
  594076
  596224
  596263
  597899
  598814
  598991
  599410
  607798
  610498
  623429
  627249
  653763
  662011
  673704
  676444
  676448
  676927
  677006
  677028
  677042
  677048
  683380
  685940
  687913
  689442
  699487
  700735
  701012
  701967
  705789
  709228
  710170
  713919
  715247
  723373
  724285
  740910
  741935
  741958
  741966
  741973
  741998
  744504
  744511
  747153
  749468
  755854
  755975
  759541
  764875
  765663
  768812
  771591
  787943
  797767
  799289
  801889
  802275
  802841
  812155
  814455
  814657
  823707
]
1.92 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "virgin teens"
]
1.78 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "virgin teens"
]
1.77 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "virgin teens"
]

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.