GET https://search.jues.net/search/embeds/6?q=mature%20doggy%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.02 ms
(82.93%)
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
  384795
  398966
  419128
  421880
  421954
  424210
  428695
  432741
  433291
  433350
  435599
  439454
  439641
  439676
  440339
  441228
  441511
  443896
  444709
  450130
  450154
  451713
  452531
  453111
  454152
  454171
  454556
  454812
  456603
  457449
  457683
  458965
  459778
  460277
  460305
  463852
  464132
  464484
  464884
  464997
  467671
  467936
  468337
  468339
  469420
  470502
  474277
  475489
  477307
  477904
  479821
  480423
  481618
  485646
  486046
  488441
  489316
  493735
  496979
  499329
  499338
  500230
  505345
  505726
  516226
  517325
  519766
  523760
  526525
  534633
  535662
  536956
  536980
  545077
  545179
  557240
  563041
  565645
  566763
  570876
  580628
  585457
  586376
  590473
  592907
  599770
  604306
  606077
  613837
  615511
  618856
  664150
  680328
  730342
  735005
  747054
  752011
  756289
  759369
  764151
  765400
  766777
  766779
  767163
  767189
  767272
  770263
  784700
  788079
  794776
  794868
  803957
  804927
  813075
  813422
  813514
  813566
  814226
  816687
  817258
]
17.69 ms
(10.79%)
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
  433291
  440339
  457449
  464484
  433350
  456603
  464132
  526525
  457683
  516226
  590473
  424210
  464997
  421880
  421954
  454812
  460277
  419128
  435599
  452531
  454556
  470502
  505345
  496979
  517325
  443896
  813566
  454152
  486046
  463852
  480423
  468337
  489316
  499329
  519766
  534633
  536956
  535662
  499338
  460305
  566763
  580628
  545179
  557240
  664150
  680328
  545077
  565645
  585457
  586376
  606077
  613837
  592907
  615511
  599770
  604306
  794776
  794868
  813075
  813422
  764151
  767189
  767272
  784700
  813514
  759369
  765400
  767163
  735005
  766777
  730342
  756289
  766779
  788079
  803957
  477904
  500230
  488441
  618856
  439641
  439676
  770263
  481618
  467936
  505726
  570876
  563041
  804927
  384795
  398966
  467671
  475489
  523760
  464884
  428695
  536980
  752011
  747054
  441228
  444709
  439454
  441511
  432741
  814226
  816687
  817258
  450154
  454171
  469420
  474277
  477307
  493735
  451713
  459778
  468339
  479821
  485646
  450130
  453111
  458965
]
2.97 ms
(1.81%)
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
  384795
  398966
  419128
  421880
  421954
  424210
  428695
  432741
  433291
  433350
  435599
  439454
  439641
  439676
  440339
  441228
  441511
  443896
  444709
  450130
  450154
  451713
  452531
  453111
  454152
  454171
  454556
  454812
  456603
  457449
  457683
  458965
  459778
  460277
  460305
  463852
  464132
  464484
  464884
  464997
  467671
  467936
  468337
  468339
  469420
  470502
  474277
  475489
  477307
  477904
  479821
  480423
  481618
  485646
  486046
  488441
  489316
  493735
  496979
  499329
  499338
  500230
  505345
  505726
  516226
  517325
  519766
  523760
  526525
  534633
  535662
  536956
  536980
  545077
  545179
  557240
  563041
  565645
  566763
  570876
  580628
  585457
  586376
  590473
  592907
  599770
  604306
  606077
  613837
  615511
  618856
  664150
  680328
  730342
  735005
  747054
  752011
  756289
  759369
  764151
  765400
  766777
  766779
  767163
  767189
  767272
  770263
  784700
  788079
  794776
  794868
  803957
  804927
  813075
  813422
  813514
  813566
  814226
  816687
  817258
]
2.16 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature doggy pov"
]
1.75 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature рак пов"
]
1.75 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature рак пов"
]

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.