Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.56 ms
(82.82%)
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
  390382
  401957
  401981
  402145
  405978
  407414
  409080
  411591
  415567
  421843
  421853
  421862
  422155
  424032
  424274
  425976
  430313
  430495
  431481
  433375
  434044
  439457
  439616
  439699
  439726
  439743
  439809
  443692
  443747
  444468
  446968
  449717
  450158
  451826
  454432
  454964
  455337
  457194
  457465
  458378
  458724
  458725
  460135
  460191
  461019
  464329
  464332
  464416
  466133
  470774
  471046
  471609
  472299
  473492
  474784
  474785
  474800
  475266
  475632
  477726
  478931
  482251
  485462
  489330
  489379
  492138
  493167
  493173
  494315
  494329
  495224
  500797
  502814
  502816
  507884
  509042
  512516
  512541
  515018
  516481
  517003
  518267
  518847
  518858
  518859
  520861
  520878
  521127
  521134
  521758
  523840
  524272
  526454
  526455
  526520
  526524
  526729
  526742
  527155
  528084
  528343
  535450
  549236
  549829
  551923
  555158
  557924
  559173
  563450
  563455
  589628
  601175
  605484
  608350
  633540
  699596
  706294
  748241
  800190
  801235
]
17.35 ms
(11.18%)
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
  527155
  524272
  526742
  464332
  473492
  492138
  549236
  557924
  551923
  563455
  699596
  706294
  555158
  589628
  605484
  601175
  801235
  748241
  608350
  633540
  800190
  401957
  402145
  409080
  421843
  424032
  439743
  443747
  464416
  478931
  482251
  421862
  439809
  450158
  460191
  424274
  458724
  461019
  471609
  401981
  411591
  443692
  477726
  421853
  518267
  517003
  518859
  485462
  563450
  390382
  422155
  466133
  471046
  528084
  458725
  472299
  433375
  439726
  430313
  449717
  451826
  474785
  507884
  502816
  512541
  526729
  515018
  520878
  489330
  559173
  549829
  407414
  457465
  475266
  439699
  474800
  439457
  439616
  464329
  455337
  475632
  509042
  512516
  526520
  489379
  495224
  502814
  521758
  526455
  493167
  493173
  494315
  500797
  516481
  520861
  523840
  526524
  494329
  521127
  521134
  526454
  528343
  535450
  518858
  470774
  474784
  405978
  415567
  431481
  444468
  425976
  430495
  434044
  446968
  454432
  454964
  457194
  458378
  460135
  518847
]
2.69 ms
(1.73%)
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
  390382
  401957
  401981
  402145
  405978
  407414
  409080
  411591
  415567
  421843
  421853
  421862
  422155
  424032
  424274
  425976
  430313
  430495
  431481
  433375
  434044
  439457
  439616
  439699
  439726
  439743
  439809
  443692
  443747
  444468
  446968
  449717
  450158
  451826
  454432
  454964
  455337
  457194
  457465
  458378
  458724
  458725
  460135
  460191
  461019
  464329
  464332
  464416
  466133
  470774
  471046
  471609
  472299
  473492
  474784
  474785
  474800
  475266
  475632
  477726
  478931
  482251
  485462
  489330
  489379
  492138
  493167
  493173
  494315
  494329
  495224
  500797
  502814
  502816
  507884
  509042
  512516
  512541
  515018
  516481
  517003
  518267
  518847
  518858
  518859
  520861
  520878
  521127
  521134
  521758
  523840
  524272
  526454
  526455
  526520
  526524
  526729
  526742
  527155
  528084
  528343
  535450
  549236
  549829
  551923
  555158
  557924
  559173
  563450
  563455
  589628
  601175
  605484
  608350
  633540
  699596
  706294
  748241
  800190
  801235
]
1.95 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom son mature"
]
1.93 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom son mature"
]
1.46 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom son mature"
]

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.