GET https://search.jues.net/search/embeds/6?q=girl%20and%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.17 ms
(83.79%)
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
  383773
  384813
  384880
  386207
  386354
  386653
  388838
  390772
  392393
  393726
  393727
  393737
  393749
  395221
  396473
  396757
  400425
  400435
  400443
  400450
  400455
  400461
  400463
  400471
  400903
  402090
  403210
  413208
  415906
  418645
  419027
  443967
  445040
  446254
  456656
  464277
  464315
  467296
  470707
  470844
  470855
  473239
  489619
  491193
  491490
  495024
  512047
  515091
  515279
  515294
  519064
  523172
  537845
  550440
  550601
  554307
  566511
  566515
  569685
  569686
  570050
  570051
  570069
  578461
  578464
  585997
  586634
  587929
  590224
  597264
  597574
  598537
  598683
  598777
  603160
  607173
  607193
  607742
  618882
  618962
  624850
  644654
  644697
  646208
  654963
  655861
  663473
  663482
  664828
  665475
  667316
  667543
  668857
  676951
  682515
  689603
  691993
  696973
  704547
  714452
  716236
  716450
  722651
  722706
  722912
  732116
  732466
  733048
  737673
  740854
  743082
  743131
  744291
  744324
  748158
  756097
  759599
  775781
  813905
  820225
]
15.24 ms
(9.24%)
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
  644654
  722651
  445040
  386653
  400903
  392393
  395221
  396473
  396757
  523172
  569686
  654963
  603160
  470844
  570050
  820225
  464277
  598537
  740854
  400463
  515091
  515279
  519064
  495024
  393727
  388838
  443967
  813905
  665475
  682515
  689603
  716450
  667316
  716236
  664828
  704547
  618962
  624850
  732466
  733048
  743082
  759599
  744291
  732116
  744324
  748158
  737673
  756097
  775781
  400450
  393726
  393737
  515294
  383773
  400425
  400443
  400455
  403210
  491490
  512047
  569685
  578461
  676951
  663473
  668857
  714452
  566511
  587929
  597264
  598683
  597574
  618882
  743131
  644697
  446254
  473239
  418645
  393749
  470707
  491193
  384813
  537845
  646208
  386207
  386354
  384880
  390772
  400435
  400461
  400471
  402090
  415906
  419027
  413208
  489619
  456656
  464315
  467296
  470855
  554307
  570051
  578464
  550601
  570069
  550440
  655861
  667543
  663482
  691993
  696973
  722912
  722706
  566515
  598777
  607742
  585997
  586634
  607193
  590224
  607173
]
3.77 ms
(2.28%)
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
  383773
  384813
  384880
  386207
  386354
  386653
  388838
  390772
  392393
  393726
  393727
  393737
  393749
  395221
  396473
  396757
  400425
  400435
  400443
  400450
  400455
  400461
  400463
  400471
  400903
  402090
  403210
  413208
  415906
  418645
  419027
  443967
  445040
  446254
  456656
  464277
  464315
  467296
  470707
  470844
  470855
  473239
  489619
  491193
  491490
  495024
  512047
  515091
  515279
  515294
  519064
  523172
  537845
  550440
  550601
  554307
  566511
  566515
  569685
  569686
  570050
  570051
  570069
  578461
  578464
  585997
  586634
  587929
  590224
  597264
  597574
  598537
  598683
  598777
  603160
  607173
  607193
  607742
  618882
  618962
  624850
  644654
  644697
  646208
  654963
  655861
  663473
  663482
  664828
  665475
  667316
  667543
  668857
  676951
  682515
  689603
  691993
  696973
  704547
  714452
  716236
  716450
  722651
  722706
  722912
  732116
  732466
  733048
  737673
  740854
  743082
  743131
  744291
  744324
  748158
  756097
  759599
  775781
  813905
  820225
]
2.25 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl and old"
]
1.85 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк old"
]
1.64 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк old"
]

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.