GET https://search.jues.net/search/embeds/3?q=fuck%20and%20swallow

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.44 ms
(83.15%)
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
  389712
  442542
  457660
  467948
  480700
  515690
  517835
  520474
  521724
  521731
  525760
  530213
  530218
  534254
  539501
  539524
  540690
  541197
  541201
  541202
  541206
  546470
  549232
  550824
  553683
  559337
  559615
  561020
  571230
  581988
  583351
  584257
  585173
  585913
  586104
  588261
  591011
  593910
  600819
  601576
  602183
  602508
  602665
  605909
  610173
  612581
  617849
  621596
  627001
  629776
  629813
  631514
  631908
  632635
  634615
  635686
  636564
  637304
  641956
  643098
  647599
  650808
  653313
  669851
  678225
  693930
  699681
  700647
  703211
  718265
  718782
  719182
  720151
  724740
  725723
  733519
  737018
  740481
  741937
  743794
  745340
  745357
  748152
  751261
  755627
  758239
  761981
  762994
  763145
  763802
  763902
  767632
  774255
  778639
  779461
  779719
  781030
  781621
  781626
  782930
  784016
  784682
  786265
  792510
  795801
  799476
  802971
  804474
  806050
  811051
  811975
  814234
  817881
  819326
  824939
  824974
  825850
  825968
  828647
]
15.17 ms
(10.06%)
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
  778639
  781626
  699681
  534254
  669851
  585913
  617849
  779461
  586104
  761981
  700647
  629813
  737018
  741937
  792510
  762994
  703211
  637304
  763145
  758239
  784682
  782930
  605909
  748152
  724740
  784016
  799476
  811975
  725723
  781621
  634615
  802971
  550824
  740481
  539524
  559615
  602665
  806050
  786265
  549232
  635686
  480700
  517835
  530213
  745340
  751261
  591011
  650808
  804474
  540690
  581988
  553683
  559337
  621596
  593910
  520474
  530218
  755627
  467948
  561020
  627001
  811051
  647599
  600819
  631908
  457660
  442542
  612581
  588261
  585173
  584257
  571230
  718782
  824974
  602508
  636564
  525760
  541201
  601576
  515690
  825968
  583351
  720151
  610173
  541206
  541197
  541202
  817881
  718265
  774255
  767632
  814234
  631514
  763802
  643098
  641956
  632635
  521724
  719182
  653313
  819326
  602183
  828647
  539501
  693930
  678225
  546470
  629776
  733519
  743794
  780386
  779719
  781030
  745357
  763902
  389712
  825850
  824939
  521731
  795801
]
2.81 ms
(1.86%)
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
  389712
  442542
  457660
  467948
  480700
  515690
  517835
  520474
  521724
  521731
  525760
  530213
  530218
  534254
  539501
  539524
  540690
  541197
  541201
  541202
  541206
  546470
  549232
  550824
  553683
  559337
  559615
  561020
  571230
  581988
  583351
  584257
  585173
  585913
  586104
  588261
  591011
  593910
  600819
  601576
  602183
  602508
  602665
  605909
  610173
  612581
  617849
  621596
  627001
  629776
  629813
  631514
  631908
  632635
  634615
  635686
  636564
  637304
  641956
  643098
  647599
  650808
  653313
  669851
  678225
  693930
  699681
  700647
  703211
  718265
  718782
  719182
  720151
  724740
  725723
  733519
  737018
  740481
  741937
  743794
  745340
  745357
  748152
  751261
  755627
  758239
  761981
  762994
  763145
  763802
  763902
  767632
  774255
  778639
  779461
  779719
  781030
  781621
  781626
  782930
  784016
  784682
  786265
  792510
  795801
  799476
  802971
  804474
  806050
  811051
  811975
  814234
  817881
  819326
  824939
  824974
  825850
  825968
  828647
]
2.13 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck and swallow"
]
1.81 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс глота"
]
1.68 ms
(1.11%)
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.