GET https://search.jues.net/search/embeds/7?q=tits%20oil

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
568.60 ms
(96.12%)
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
  7753
  73413
  102334
  149261
  185642
  185861
  236378
  359054
  382200
  382650
  383018
  383984
  386310
  395509
  399595
  399628
  405815
  407064
  417202
  419147
  429357
  433058
  433958
  436588
  442802
  444460
  444540
  444635
  445796
  446011
  447357
  447664
  450277
  452334
  454909
  454942
  455133
  456058
  460651
  461039
  463420
  465079
  465226
  467110
  468687
  475711
  478988
  480848
  482272
  489897
  499476
  499821
  502809
  504339
  509720
  510205
  511413
  518590
  522166
  523871
  524567
  531442
  533630
  538973
  548081
  548097
  551366
  551407
  555944
  562398
  562904
  564619
  564633
  582636
  586666
  598061
  601079
  604030
  604926
  620329
  634432
  637037
  641924
  643097
  645301
  651881
  661354
  664528
  664944
  673052
  674662
  677975
  701054
  709554
  710483
  737722
  743038
  744709
  747328
  747363
  753784
  754666
  759856
  762556
  769955
  773875
  790080
  793624
  801243
  805328
  805731
  807910
  817486
  817806
  818783
  818784
  820900
  826302
  828682
  828714
]
12.69 ms
(2.15%)
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
  399595
  444460
  417202
  436588
  452334
  499821
  661354
  674662
  598061
  747328
  433958
  664944
  444635
  407064
  820900
  454942
  564633
  582636
  651881
  555944
  475711
  817806
  828682
  645301
  677975
  801243
  754666
  419147
  433058
  480848
  454909
  562398
  604030
  523871
  817486
  818783
  826302
  818784
  637037
  769955
  744709
  743038
  383984
  386310
  236378
  359054
  828714
  548097
  673052
  701054
  709554
  548081
  620329
  641924
  793624
  807910
  737722
  753784
  149261
  382650
  382200
  634432
  586666
  790080
  773875
  461039
  643097
  805328
  551407
  538973
  383018
  533630
  759856
  185642
  460651
  510205
  562904
  446011
  465079
  509720
  511413
  524567
  502809
  522166
  664528
  710483
  601079
  604926
  805731
  762556
  747363
  73413
  102334
  185861
  395509
  7753
  399628
  405815
  442802
  444540
  429357
  445796
  447357
  468687
  447664
  455133
  467110
  489897
  450277
  456058
  465226
  478988
  518590
  504339
  499476
  531442
  463420
  482272
  551366
  564619
]
3.71 ms
(0.63%)
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
  7753
  73413
  102334
  149261
  185642
  185861
  236378
  359054
  382200
  382650
  383018
  383984
  386310
  395509
  399595
  399628
  405815
  407064
  417202
  419147
  429357
  433058
  433958
  436588
  442802
  444460
  444540
  444635
  445796
  446011
  447357
  447664
  450277
  452334
  454909
  454942
  455133
  456058
  460651
  461039
  463420
  465079
  465226
  467110
  468687
  475711
  478988
  480848
  482272
  489897
  499476
  499821
  502809
  504339
  509720
  510205
  511413
  518590
  522166
  523871
  524567
  531442
  533630
  538973
  548081
  548097
  551366
  551407
  555944
  562398
  562904
  564619
  564633
  582636
  586666
  598061
  601079
  604030
  604926
  620329
  634432
  637037
  641924
  643097
  645301
  651881
  661354
  664528
  664944
  673052
  674662
  677975
  701054
  709554
  710483
  737722
  743038
  744709
  747328
  747363
  753784
  754666
  759856
  762556
  769955
  773875
  790080
  793624
  801243
  805328
  805731
  807910
  817486
  817806
  818783
  818784
  820900
  826302
  828682
  828714
]
2.16 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits oil"
]
1.70 ms
(0.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ масл"
]
1.43 ms
(0.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.26 ms
(0.21%)
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.