Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.60 ms
(79.47%)
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
  264016
  382181
  388320
  392623
  395386
  397506
  400417
  402260
  417956
  418659
  421806
  426959
  456961
  457180
  459793
  460802
  461392
  467245
  467348
  474803
  485035
  485170
  488332
  488558
  500510
  504529
  507014
  508832
  508845
  517266
  517309
  521702
  524172
  524313
  527583
  529573
  540381
  543292
  544127
  545588
  546078
  546609
  546658
  546760
  546826
  547613
  549747
  549941
  552072
  552843
  554123
  554772
  557402
  558908
  560655
  565433
  568809
  569446
  570740
  572686
  572718
  574128
  577484
  582488
  587587
  588844
  589987
  591799
  594971
  604813
  608039
  614466
  619075
  622277
  623826
  624659
  624662
  625855
  626112
  626771
  636936
  636951
  637654
  640457
  640458
  646693
  650648
  652258
  653755
  653888
  656106
  662387
  662974
  663538
  664210
  668789
  668808
  671175
  671877
  675456
  676972
  677048
  679231
  680492
  684198
  692592
  693302
  698372
  711604
  716280
  717696
  722536
  722882
  723632
  774468
  815263
  815841
  820695
  823346
  826327
]
27.38 ms
(15.05%)
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
  392623
  397506
  467245
  418659
  461392
  417956
  474803
  507014
  508832
  488558
  395386
  264016
  382181
  388320
  400417
  402260
  421806
  426959
  723632
  774468
  815263
  820695
  815841
  823346
  826327
  456961
  485170
  457180
  460802
  459793
  467348
  485035
  504529
  508845
  517266
  500510
  517309
  529573
  521702
  524172
  524313
  527583
  540381
  488332
  546760
  549941
  572686
  545588
  546078
  549747
  552072
  554123
  557402
  574128
  582488
  543292
  544127
  546658
  547613
  554772
  558908
  568809
  572718
  652258
  653755
  653888
  668789
  671877
  677048
  692592
  662387
  662974
  663538
  664210
  716280
  722882
  646693
  650648
  656106
  668808
  671175
  675456
  676972
  679231
  680492
  684198
  693302
  698372
  711604
  717696
  722536
  546609
  546826
  552843
  560655
  565433
  569446
  570740
  577484
  587587
  591799
  619075
  622277
  624662
  625855
  626112
  589987
  594971
  636936
  636951
  637654
  640458
  588844
  604813
  608039
  614466
  623826
  624659
  626771
  640457
]
3.01 ms
(1.66%)
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
  264016
  382181
  388320
  392623
  395386
  397506
  400417
  402260
  417956
  418659
  421806
  426959
  456961
  457180
  459793
  460802
  461392
  467245
  467348
  474803
  485035
  485170
  488332
  488558
  500510
  504529
  507014
  508832
  508845
  517266
  517309
  521702
  524172
  524313
  527583
  529573
  540381
  543292
  544127
  545588
  546078
  546609
  546658
  546760
  546826
  547613
  549747
  549941
  552072
  552843
  554123
  554772
  557402
  558908
  560655
  565433
  568809
  569446
  570740
  572686
  572718
  574128
  577484
  582488
  587587
  588844
  589987
  591799
  594971
  604813
  608039
  614466
  619075
  622277
  623826
  624659
  624662
  625855
  626112
  626771
  636936
  636951
  637654
  640457
  640458
  646693
  650648
  652258
  653755
  653888
  656106
  662387
  662974
  663538
  664210
  668789
  668808
  671175
  671877
  675456
  676972
  677048
  679231
  680492
  684198
  692592
  693302
  698372
  711604
  716280
  717696
  722536
  722882
  723632
  774468
  815263
  815841
  820695
  823346
  826327
]
2.05 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx boyfriend"
]
1.73 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx boyfriend"
]
1.55 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx boyfriend"
]

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.