GET https://search.jues.net/search/embeds/4?q=slave%20white%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.77 ms
(76.64%)
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
  394747
  414381
  417866
  425131
  425491
  434793
  436770
  437387
  437686
  442248
  443617
  445414
  447253
  448034
  448052
  448221
  450721
  450910
  450966
  451152
  456790
  458379
  459532
  459703
  463252
  463305
  465256
  469745
  472454
  472784
  473529
  474785
  474896
  475183
  475927
  476015
  478530
  479082
  481795
  483024
  485177
  485975
  485979
  487364
  488372
  489471
  489712
  490520
  491290
  491654
  492972
  493892
  494284
  494745
  495063
  495522
  495746
  495906
  496603
  497395
  499069
  499178
  500528
  500531
  500996
  501081
  501193
  501426
  501996
  506702
  508377
  508519
  508522
  508864
  512385
  512749
  513274
  513825
  514119
  514275
  514836
  515959
  516438
  516652
  516989
  517283
  517418
  518920
  519161
  519771
  519837
  519879
  520448
  520604
  522101
  522565
  523197
  523450
  524235
  524299
  524551
  525087
  525339
  525833
  526370
  526447
  526884
  527054
  527280
  527377
  527625
  527944
  528446
  529374
  530005
  533510
  536684
  540245
  544672
  571998
]
26.42 ms
(16.91%)
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
  459703
  514119
  516652
  499069
  522101
  475927
  394747
  481795
  520604
  494745
  485177
  527625
  501996
  437387
  442248
  443617
  436770
  445414
  472454
  475183
  485979
  458379
  456790
  491290
  524551
  495063
  495746
  514836
  517283
  517418
  527054
  500996
  508519
  523197
  519161
  526370
  544672
  473529
  434793
  459532
  450721
  450910
  463305
  465256
  447253
  450966
  469745
  501081
  501193
  508377
  487364
  508522
  525087
  485975
  492972
  493892
  494284
  501426
  513825
  519879
  527377
  488372
  489471
  437686
  533510
  496603
  500531
  478530
  448034
  476015
  448221
  506702
  519771
  527944
  512385
  520448
  497395
  540245
  527280
  516438
  571998
  425491
  463252
  448052
  508864
  483024
  491654
  513274
  525833
  528446
  514275
  522565
  523450
  472784
  479082
  414381
  417866
  425131
  474785
  490520
  451152
  474896
  489712
  518920
  524299
  526447
  536684
  499178
  500528
  495906
  512749
  516989
  530005
  495522
  515959
  519837
  524235
  525339
  526884
  529374
]
2.76 ms
(1.76%)
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
  394747
  414381
  417866
  425131
  425491
  434793
  436770
  437387
  437686
  442248
  443617
  445414
  447253
  448034
  448052
  448221
  450721
  450910
  450966
  451152
  456790
  458379
  459532
  459703
  463252
  463305
  465256
  469745
  472454
  472784
  473529
  474785
  474896
  475183
  475927
  476015
  478530
  479082
  481795
  483024
  485177
  485975
  485979
  487364
  488372
  489471
  489712
  490520
  491290
  491654
  492972
  493892
  494284
  494745
  495063
  495522
  495746
  495906
  496603
  497395
  499069
  499178
  500528
  500531
  500996
  501081
  501193
  501426
  501996
  506702
  508377
  508519
  508522
  508864
  512385
  512749
  513274
  513825
  514119
  514275
  514836
  515959
  516438
  516652
  516989
  517283
  517418
  518920
  519161
  519771
  519837
  519879
  520448
  520604
  522101
  522565
  523197
  523450
  524235
  524299
  524551
  525087
  525339
  525833
  526370
  526447
  526884
  527054
  527280
  527377
  527625
  527944
  528446
  529374
  530005
  533510
  536684
  540245
  544672
  571998
]
1.93 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slave white wife"
]
1.81 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доминирован white жен"
]
1.81 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "доминирован white жен"
]
1.78 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.