GET https://search.jues.net/search/embeds/7?q=licking%20hairy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.52 ms
(87.89%)
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
  123011
  383903
  386408
  396276
  397802
  400100
  406303
  415404
  421974
  424414
  432034
  437686
  443787
  448072
  453161
  455843
  456400
  496086
  501317
  502701
  507947
  509821
  515074
  516104
  521235
  521972
  524355
  534207
  543241
  549326
  551017
  551946
  554350
  555197
  556008
  566007
  566537
  566711
  568553
  568562
  573227
  574201
  577174
  581284
  581332
  583867
  592555
  596409
  604346
  606425
  612401
  620145
  622198
  622622
  622626
  622675
  623598
  624255
  627052
  640692
  641769
  648896
  650957
  650983
  655864
  675968
  676509
  678996
  687560
  687608
  693029
  711875
  712221
  714125
  714981
  716321
  722516
  722521
  727638
  730272
  730324
  736402
  737673
  742803
  744311
  754954
  770111
  770867
  771698
  771808
  773884
  775803
  781238
  783625
  788632
  788640
  797795
  797847
  800147
  801197
  802505
  803079
  803083
  804398
  806311
  807699
  808167
  808418
  809112
  812109
  815222
  817804
  818441
  819049
  820153
  820453
  825141
  826844
  827099
  827419
]
14.88 ms
(7.49%)
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
  507947
  524355
  521235
  515074
  551946
  566007
  566537
  549326
  551017
  556008
  568553
  568562
  678996
  722521
  650957
  650983
  675968
  655864
  714981
  722516
  620145
  592555
  640692
  596409
  606425
  612401
  622198
  622622
  807699
  775803
  783625
  808418
  812109
  727638
  736402
  730324
  770111
  737673
  604346
  622675
  623598
  624255
  716321
  802505
  806311
  808167
  400100
  415404
  424414
  396276
  456400
  455843
  509821
  502701
  516104
  521972
  501317
  406303
  437686
  453161
  448072
  496086
  443787
  421974
  432034
  386408
  383903
  123011
  397802
  818441
  817804
  819049
  825141
  826844
  827099
  827419
  820453
  815222
  820153
  534207
  543241
  581332
  583867
  555197
  573227
  581284
  554350
  566711
  577174
  711875
  676509
  687560
  687608
  712221
  714125
  648896
  693029
  574201
  641769
  622626
  804398
  809112
  781238
  800147
  801197
  770867
  773884
  797847
  803083
  730272
  742803
  744311
  771698
  754954
  771808
  627052
  788632
  788640
  797795
  803079
]
2.85 ms
(1.43%)
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
  123011
  383903
  386408
  396276
  397802
  400100
  406303
  415404
  421974
  424414
  432034
  437686
  443787
  448072
  453161
  455843
  456400
  496086
  501317
  502701
  507947
  509821
  515074
  516104
  521235
  521972
  524355
  534207
  543241
  549326
  551017
  551946
  554350
  555197
  556008
  566007
  566537
  566711
  568553
  568562
  573227
  574201
  577174
  581284
  581332
  583867
  592555
  596409
  604346
  606425
  612401
  620145
  622198
  622622
  622626
  622675
  623598
  624255
  627052
  640692
  641769
  648896
  650957
  650983
  655864
  675968
  676509
  678996
  687560
  687608
  693029
  711875
  712221
  714125
  714981
  716321
  722516
  722521
  727638
  730272
  730324
  736402
  737673
  742803
  744311
  754954
  770111
  770867
  771698
  771808
  773884
  775803
  781238
  783625
  788632
  788640
  797795
  797847
  800147
  801197
  802505
  803079
  803083
  804398
  806311
  807699
  808167
  808418
  809112
  812109
  815222
  817804
  818441
  819049
  820153
  820453
  825141
  826844
  827099
  827419
]
1.80 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking hairy"
]
1.71 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза волосатая"
]
1.25 ms
(0.63%)
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.