GET https://search.jues.net/search/embeds/3?q=clit%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.28 ms
(85.73%)
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
  393798
  416162
  445716
  504625
  506626
  529831
  535281
  544029
  544882
  544904
  545155
  546163
  546181
  546232
  546243
  548343
  550426
  550548
  550923
  551774
  552532
  553218
  553220
  553222
  553226
  554675
  554679
  554698
  554708
  556114
  559418
  561792
  562584
  572636
  572723
  572728
  575922
  576584
  576610
  577033
  577247
  577278
  577952
  588022
  602287
  617163
  617535
  627563
  630961
  631899
  650609
  651797
  666389
  669257
  685305
  706117
  706643
  707724
  710150
  711695
  720570
  726138
  726172
  728888
  732936
  733899
  734203
  734841
  736724
  740255
  744143
  744815
  745295
  746367
  747990
  748630
  748966
  749045
  760569
  761249
  767746
  769096
  772439
  775648
  781268
  786877
  788297
  791854
  792339
  793247
  794457
  803564
  804684
  806806
  809679
  809731
  817363
  819687
  820161
  821757
  823744
  824073
  824655
  824850
  824853
  824885
  824926
  825028
  825125
  825128
  825182
  826357
  826564
  826956
  826979
  827171
  827207
  827225
  827438
  827529
]
14.08 ms
(8.73%)
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
  803564
  824926
  576610
  577278
  746367
  823744
  793247
  416162
  529831
  825128
  820161
  544882
  576584
  775648
  825125
  546181
  827529
  824655
  827171
  559418
  588022
  824073
  826956
  553222
  561792
  562584
  554708
  685305
  666389
  669257
  546243
  575922
  577952
  627563
  748966
  506626
  553218
  711695
  761249
  572723
  651797
  827225
  827438
  821757
  825028
  825182
  535281
  552532
  554698
  572728
  553220
  553226
  577033
  733899
  769096
  781268
  747990
  732936
  740255
  734841
  602287
  788297
  791854
  826357
  827207
  826979
  548343
  545155
  794457
  806806
  804684
  748630
  809679
  734203
  767746
  744143
  504625
  577247
  710150
  650609
  706117
  546163
  546232
  617535
  631899
  617163
  630961
  706643
  707724
  550548
  572636
  760569
  393798
  826564
  824885
  824853
  445716
  544029
  544904
  550426
  550923
  554679
  551774
  720570
  792339
  744815
  749045
  772439
  786877
  726172
  728888
  736724
  745295
  726138
  809731
  817363
  819687
  824850
  554675
  556114
]
2.59 ms
(1.61%)
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
  393798
  416162
  445716
  504625
  506626
  529831
  535281
  544029
  544882
  544904
  545155
  546163
  546181
  546232
  546243
  548343
  550426
  550548
  550923
  551774
  552532
  553218
  553220
  553222
  553226
  554675
  554679
  554698
  554708
  556114
  559418
  561792
  562584
  572636
  572723
  572728
  575922
  576584
  576610
  577033
  577247
  577278
  577952
  588022
  602287
  617163
  617535
  627563
  630961
  631899
  650609
  651797
  666389
  669257
  685305
  706117
  706643
  707724
  710150
  711695
  720570
  726138
  726172
  728888
  732936
  733899
  734203
  734841
  736724
  740255
  744143
  744815
  745295
  746367
  747990
  748630
  748966
  749045
  760569
  761249
  767746
  769096
  772439
  775648
  781268
  786877
  788297
  791854
  792339
  793247
  794457
  803564
  804684
  806806
  809679
  809731
  817363
  819687
  820161
  821757
  823744
  824073
  824655
  824850
  824853
  824885
  824926
  825028
  825125
  825128
  825182
  826357
  826564
  826956
  826979
  827171
  827207
  827225
  827438
  827529
]
1.91 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "clit homemade"
]
1.39 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "clit домашн любительск"
]
1.35 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "clit домашн любительск"
]

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.