Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.81 ms
(83.19%)
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
  383366
  402984
  403419
  408659
  419423
  421735
  422358
  426994
  428148
  430437
  431481
  434097
  437582
  439743
  445790
  449622
  457575
  465840
  466129
  474035
  477989
  478985
  478990
  487405
  493149
  495198
  502729
  504927
  512555
  525802
  526515
  534218
  535672
  541561
  541890
  549367
  549391
  556817
  560141
  563009
  563455
  564127
  565022
  565557
  568425
  569015
  577363
  577422
  578703
  580971
  581566
  581969
  585477
  586584
  588314
  589036
  592685
  598253
  603029
  604109
  604555
  609759
  610271
  612321
  614725
  619204
  621096
  621676
  622366
  650195
  654636
  661976
  673612
  673651
  677817
  685579
  697909
  699516
  702286
  703509
  703900
  707315
  709215
  715972
  723435
  723732
  726753
  737633
  741613
  745827
  751567
  753248
  755782
  756803
  769487
  770149
  771023
  773412
  773474
  773850
  776462
  779610
  784922
  785856
  786385
  789968
  792343
  792634
  794804
  797657
  797909
  800936
  803321
  805149
  806288
  807390
  807465
  807529
  812418
  813249
]
16.05 ms
(10.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
  556817
  564127
  569015
  577363
  580971
  541561
  565022
  541890
  549367
  549391
  563009
  563455
  581566
  581969
  650195
  654636
  661976
  673651
  699516
  702286
  673612
  685579
  703509
  715972
  677817
  697909
  707315
  723435
  560141
  577422
  592685
  609759
  585477
  586584
  588314
  603029
  612321
  621676
  598253
  604109
  614725
  619204
  621096
  784922
  785856
  792343
  806288
  807390
  807529
  812418
  779610
  786385
  794804
  797909
  805149
  807465
  723732
  751567
  773850
  789968
  800936
  803321
  813249
  737633
  769487
  741613
  745827
  755782
  756803
  771023
  773474
  726753
  770149
  773412
  753248
  622366
  703900
  709215
  776462
  792634
  797657
  421735
  439743
  457575
  478985
  449622
  477989
  478990
  383366
  402984
  419423
  434097
  445790
  428148
  466129
  512555
  493149
  525802
  535672
  487405
  502729
  534218
  526515
  568425
  565557
  589036
  610271
  422358
  426994
  403419
  465840
  437582
  495198
  578703
  604555
  430437
  474035
  504927
  408659
  431481
]
2.55 ms
(1.70%)
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
  383366
  402984
  403419
  408659
  419423
  421735
  422358
  426994
  428148
  430437
  431481
  434097
  437582
  439743
  445790
  449622
  457575
  465840
  466129
  474035
  477989
  478985
  478990
  487405
  493149
  495198
  502729
  504927
  512555
  525802
  526515
  534218
  535672
  541561
  541890
  549367
  549391
  556817
  560141
  563009
  563455
  564127
  565022
  565557
  568425
  569015
  577363
  577422
  578703
  580971
  581566
  581969
  585477
  586584
  588314
  589036
  592685
  598253
  603029
  604109
  604555
  609759
  610271
  612321
  614725
  619204
  621096
  621676
  622366
  650195
  654636
  661976
  673612
  673651
  677817
  685579
  697909
  699516
  702286
  703509
  703900
  707315
  709215
  715972
  723435
  723732
  726753
  737633
  741613
  745827
  751567
  753248
  755782
  756803
  769487
  770149
  771023
  773412
  773474
  773850
  776462
  779610
  784922
  785856
  786385
  789968
  792343
  792634
  794804
  797657
  797909
  800936
  803321
  805149
  806288
  807390
  807465
  807529
  812418
  813249
]
1.98 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bathroom mom"
]
1.65 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван mom"
]
1.55 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ван mom"
]

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.