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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.84 ms
(79.48%)
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
  364655
  397671
  397868
  417223
  424753
  443640
  449643
  453626
  455745
  455988
  456683
  458200
  458934
  461800
  462308
  465122
  465692
  467132
  467168
  467738
  468476
  473445
  473459
  474489
  478304
  479463
  480894
  483327
  487020
  487022
  487028
  488196
  488201
  488209
  488543
  493061
  496147
  497117
  501829
  501830
  506946
  507280
  508586
  509945
  510093
  510153
  512668
  519121
  523500
  524007
  524625
  526925
  529048
  541974
  546637
  548037
  551267
  551860
  552297
  552353
  555397
  556311
  558979
  558991
  560471
  561253
  567097
  567108
  567698
  569547
  573492
  578052
  578065
  578078
  578101
  578124
  580357
  586397
  589360
  589745
  594852
  599229
  601983
  605563
  606647
  613635
  620214
  635422
  637982
  641743
  655554
  694380
  696158
  700517
  702232
  704866
  708292
  710253
  717850
  721275
  721908
  724297
  725933
  726001
  726016
  727087
  729569
  729571
  729586
  731723
  737452
  741307
  753134
  762776
  786081
  786585
  787007
  789598
  798936
  817385
]
21.74 ms
(13.95%)
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
  762776
  725933
  726001
  455745
  573492
  702232
  726016
  704866
  786585
  578124
  462308
  501830
  488201
  512668
  364655
  397671
  424753
  465692
  473459
  487028
  473445
  479463
  453626
  455988
  493061
  529048
  488209
  561253
  567108
  541974
  546637
  555397
  560471
  578065
  580357
  551860
  569547
  578052
  578078
  694380
  696158
  708292
  717850
  721908
  655554
  710253
  548037
  556311
  567097
  567698
  578101
  637982
  641743
  589745
  599229
  586397
  594852
  606647
  620214
  589360
  601983
  787007
  727087
  737452
  786081
  731723
  724297
  613635
  798936
  467132
  465122
  449643
  417223
  496147
  508586
  519121
  523500
  487020
  509945
  510093
  510153
  507280
  443640
  497117
  458200
  524007
  488543
  526925
  551267
  558991
  817385
  558979
  552297
  721275
  789598
  729569
  729571
  729586
  700517
  458934
  468476
  474489
  456683
  478304
  461800
  467738
  501829
  487022
  488196
  524625
  552353
  467168
  741307
  753134
  397868
  483327
  605563
  635422
  480894
  506946
]
3.31 ms
(2.12%)
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
  364655
  397671
  397868
  417223
  424753
  443640
  449643
  453626
  455745
  455988
  456683
  458200
  458934
  461800
  462308
  465122
  465692
  467132
  467168
  467738
  468476
  473445
  473459
  474489
  478304
  479463
  480894
  483327
  487020
  487022
  487028
  488196
  488201
  488209
  488543
  493061
  496147
  497117
  501829
  501830
  506946
  507280
  508586
  509945
  510093
  510153
  512668
  519121
  523500
  524007
  524625
  526925
  529048
  541974
  546637
  548037
  551267
  551860
  552297
  552353
  555397
  556311
  558979
  558991
  560471
  561253
  567097
  567108
  567698
  569547
  573492
  578052
  578065
  578078
  578101
  578124
  580357
  586397
  589360
  589745
  594852
  599229
  601983
  605563
  606647
  613635
  620214
  635422
  637982
  641743
  655554
  694380
  696158
  700517
  702232
  704866
  708292
  710253
  717850
  721275
  721908
  724297
  725933
  726001
  726016
  727087
  729569
  729571
  729586
  731723
  737452
  741307
  753134
  762776
  786081
  786585
  787007
  789598
  798936
  817385
]
2.13 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife pickup"
]
1.64 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен пикап"
]
1.61 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.00%)
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.