GET https://search.jues.net/search/embeds/4?q=hard%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.66 ms
(88.60%)
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
  401525
  401872
  468895
  539571
  541304
  543752
  551515
  552532
  556745
  559669
  572089
  572434
  579507
  585821
  586205
  590182
  597764
  615171
  623006
  631106
  634975
  637614
  648043
  651835
  652927
  654492
  654583
  654732
  655055
  655388
  656085
  656696
  657096
  657105
  657316
  657594
  658006
  658278
  658625
  667755
  677129
  677213
  679115
  679694
  683538
  691662
  692032
  692117
  694600
  695758
  705313
  710599
  710909
  711070
  716035
  716964
  716989
  717650
  718243
  719546
  720039
  720191
  722093
  725320
  729293
  729871
  732564
  733662
  734795
  736228
  736504
  736643
  742245
  747270
  747351
  748841
  754064
  754409
  761682
  763472
  766422
  766885
  768699
  771040
  771915
  777183
  778574
  780550
  780975
  782340
  782718
  782991
  784914
  785808
  788912
  790333
  792751
  797257
  797311
  799780
  800576
  810419
  814502
  816679
  817013
  819184
  819687
  822234
  824290
  824876
  825834
  825838
  826418
  826457
  826852
  827361
  827580
  827900
  827962
]
12.25 ms
(6.28%)
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
  771915
  742245
  748841
  817013
  822234
  816679
  825838
  551515
  552532
  559669
  543752
  572434
  655055
  655388
  677129
  677213
  717650
  657316
  658006
  667755
  691662
  692117
  705313
  710599
  716964
  651835
  718243
  720039
  586205
  590182
  597764
  780550
  782340
  799780
  800576
  810419
  729293
  734795
  761682
  782991
  792751
  766885
  736504
  736643
  747351
  754064
  729871
  747270
  754409
  763472
  725320
  771040
  637614
  784914
  785808
  797257
  401872
  401525
  814502
  819687
  824290
  541304
  656696
  654583
  782718
  736228
  766422
  788912
  768699
  631106
  710909
  824876
  826418
  825834
  826457
  827580
  819184
  824210
  827900
  468895
  722093
  720191
  634975
  615171
  797311
  777183
  780975
  790333
  732564
  733662
  711070
  826852
  827962
  827361
  539571
  572089
  579507
  648043
  656085
  657096
  657105
  679115
  683538
  695758
  719546
  652927
  654492
  658625
  679694
  654732
  657594
  658278
  692032
  694600
  716035
  716989
  556745
  585821
  623006
  778574
]
2.92 ms
(1.50%)
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
  401525
  401872
  468895
  539571
  541304
  543752
  551515
  552532
  556745
  559669
  572089
  572434
  579507
  585821
  586205
  590182
  597764
  615171
  623006
  631106
  634975
  637614
  648043
  651835
  652927
  654492
  654583
  654732
  655055
  655388
  656085
  656696
  657096
  657105
  657316
  657594
  658006
  658278
  658625
  667755
  677129
  677213
  679115
  679694
  683538
  691662
  692032
  692117
  694600
  695758
  705313
  710599
  710909
  711070
  716035
  716964
  716989
  717650
  718243
  719546
  720039
  720191
  722093
  725320
  729293
  729871
  732564
  733662
  734795
  736228
  736504
  736643
  742245
  747270
  747351
  748841
  754064
  754409
  761682
  763472
  766422
  766885
  768699
  771040
  771915
  777183
  778574
  780550
  780975
  782340
  782718
  782991
  784914
  785808
  788912
  790333
  792751
  797257
  797311
  799780
  800576
  810419
  814502
  816679
  817013
  819184
  819687
  822234
  824290
  824876
  825834
  825838
  826418
  826457
  826852
  827361
  827580
  827900
  827962
]
1.98 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard girls"
]
1.80 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard девушк"
]
1.60 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard девушк"
]

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.