Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.47 ms
(81.31%)
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
  9896
  104990
  203645
  229024
  233748
  325777
  365865
  365901
  366052
  381952
  385614
  385832
  386839
  388315
  389623
  390195
  391871
  391890
  391955
  393726
  395883
  395898
  397862
  397896
  397923
  400708
  410741
  411419
  417163
  422420
  422989
  423750
  424040
  424145
  424160
  425275
  426703
  428053
  444106
  444814
  447200
  456569
  459740
  460721
  462002
  462007
  465993
  467218
  467588
  468519
  468916
  471603
  472110
  475177
  475896
  476458
  476471
  477596
  479009
  479030
  481286
  482833
  487820
  490310
  491158
  491192
  492222
  495858
  498905
  504161
  509082
  510503
  511832
  520293
  527328
  533648
  555063
  555096
  555100
  557787
  569993
  570006
  571598
  576307
  577980
  579124
  589330
  598451
  600105
  620226
  620260
  652247
  658723
  673204
  675419
  677339
  681507
  682654
  686357
  693380
  700010
  715424
  737516
  744340
  746164
  758974
  762003
  764864
  766622
  768451
  769472
  774855
  778647
  778701
  782349
  788833
  790925
  805650
  810520
  827825
]
20.92 ms
(12.94%)
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
  509082
  652247
  589330
  774855
  782349
  788833
  744340
  778647
  805650
  425275
  104990
  390195
  422420
  477596
  385614
  233748
  400708
  700010
  447200
  365901
  388315
  491158
  366052
  395898
  481286
  385832
  482833
  490310
  762003
  459740
  468519
  472110
  9896
  428053
  417163
  675419
  677339
  673204
  600105
  758974
  764864
  810520
  769472
  766622
  424040
  475896
  203645
  475177
  391890
  579124
  426703
  467588
  681507
  391871
  462007
  462002
  393726
  444814
  471603
  511832
  492222
  527328
  491192
  365865
  391955
  410741
  397896
  495858
  827825
  555063
  571598
  682654
  715424
  576307
  598451
  620260
  778701
  790925
  737516
  768451
  325777
  397923
  468916
  422989
  381952
  389623
  411419
  229024
  386839
  533648
  557787
  686357
  620226
  460721
  397862
  395883
  424160
  746164
  570006
  456569
  423750
  424145
  479009
  487820
  498905
  510503
  504161
  476458
  555100
  577980
  465993
  569993
  479030
  444106
  476471
  658723
  467218
  520293
  555096
  693380
]
2.62 ms
(1.62%)
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
  9896
  104990
  203645
  229024
  233748
  325777
  365865
  365901
  366052
  381952
  385614
  385832
  386839
  388315
  389623
  390195
  391871
  391890
  391955
  393726
  395883
  395898
  397862
  397896
  397923
  400708
  410741
  411419
  417163
  422420
  422989
  423750
  424040
  424145
  424160
  425275
  426703
  428053
  444106
  444814
  447200
  456569
  459740
  460721
  462002
  462007
  465993
  467218
  467588
  468519
  468916
  471603
  472110
  475177
  475896
  476458
  476471
  477596
  479009
  479030
  481286
  482833
  487820
  490310
  491158
  491192
  492222
  495858
  498905
  504161
  509082
  510503
  511832
  520293
  527328
  533648
  555063
  555096
  555100
  557787
  569993
  570006
  571598
  576307
  577980
  579124
  589330
  598451
  600105
  620226
  620260
  652247
  658723
  673204
  675419
  677339
  681507
  682654
  686357
  693380
  700010
  715424
  737516
  744340
  746164
  758974
  762003
  764864
  766622
  768451
  769472
  774855
  778647
  778701
  782349
  788833
  790925
  805650
  810520
  827825
]
2.14 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "блондинки раком русск…"
]
1.70 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая рак русск"
]
1.35 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая рак русск"
]

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.