Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.22 ms
(88.67%)
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
  114730
  330414
  383656
  385895
  386839
  387009
  390220
  400492
  402659
  404185
  417696
  421444
  438650
  445010
  462334
  466704
  470906
  493094
  494630
  504175
  507451
  507631
  507769
  515626
  515734
  528054
  542671
  548425
  551394
  557781
  557910
  558694
  564662
  568652
  569017
  569847
  570454
  591544
  603282
  605087
  605581
  605719
  607180
  607263
  610199
  622416
  624390
  624751
  626354
  627168
  628747
  633483
  639801
  650447
  651066
  676769
  682924
  683330
  684531
  687616
  689989
  690625
  693701
  695432
  702992
  705136
  706442
  710581
  715152
  715754
  716534
  719156
  724605
  727890
  729370
  736822
  738919
  740848
  744242
  745445
  745552
  748285
  749929
  750454
  750996
  755838
  756081
  757829
  758561
  759074
  762568
  763729
  769382
  770815
  773026
  776651
  784673
  784677
  784678
  786635
  787078
  788430
  794421
  794899
  795205
  795612
  796283
  797046
  797182
  801094
  803176
  804303
  806444
  810021
  811435
  813467
  816062
  817371
  818582
]
11.14 ms
(6.09%)
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
  558694
  569017
  542671
  548425
  650447
  687616
  706442
  695432
  651066
  568652
  605719
  624751
  784677
  787078
  794421
  773026
  784678
  794899
  727890
  744242
  757829
  605087
  803176
  385895
  507631
  817371
  816062
  569904
  569847
  570454
  683330
  676769
  684531
  689989
  705136
  715754
  693701
  716534
  639801
  628747
  797182
  811435
  813467
  740848
  749929
  806444
  724605
  736822
  745552
  750454
  758561
  729370
  763729
  756081
  784673
  795205
  797046
  466704
  400492
  421444
  462334
  494630
  515734
  624390
  383656
  386839
  390220
  818582
  507451
  528054
  493094
  557910
  557781
  564662
  682924
  690625
  702992
  719156
  551394
  603282
  607180
  633483
  591544
  622416
  626354
  605581
  607263
  610199
  627168
  776651
  786635
  795612
  796283
  801094
  810021
  788430
  804303
  762568
  770815
  738919
  748285
  745445
  755838
  759074
  750996
  769382
  710581
  715152
  445010
  470906
  404185
  438650
  417696
  504175
  507769
  515626
  114730
  330414
  387009
  402659
]
3.09 ms
(1.69%)
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
  114730
  330414
  383656
  385895
  386839
  387009
  390220
  400492
  402659
  404185
  417696
  421444
  438650
  445010
  462334
  466704
  470906
  493094
  494630
  504175
  507451
  507631
  507769
  515626
  515734
  528054
  542671
  548425
  551394
  557781
  557910
  558694
  564662
  568652
  569017
  569847
  570454
  591544
  603282
  605087
  605581
  605719
  607180
  607263
  610199
  622416
  624390
  624751
  626354
  627168
  628747
  633483
  639801
  650447
  651066
  676769
  682924
  683330
  684531
  687616
  689989
  690625
  693701
  695432
  702992
  705136
  706442
  710581
  715152
  715754
  716534
  719156
  724605
  727890
  729370
  736822
  738919
  740848
  744242
  745445
  745552
  748285
  749929
  750454
  750996
  755838
  756081
  757829
  758561
  759074
  762568
  763729
  769382
  770815
  773026
  776651
  784673
  784677
  784678
  786635
  787078
  788430
  794421
  794899
  795205
  795612
  796283
  797046
  797182
  801094
  803176
  804303
  806444
  810021
  811435
  813467
  816062
  817371
  818582
]
1.78 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot sexy"
]
1.70 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot and sexy"
]
1.42 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot sexy"
]

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.