GET https://search.jues.net/search/embeds/4?q=couple%20licking

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.62 ms
(86.20%)
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
  388102
  388761
  390207
  395917
  398582
  405000
  407404
  413053
  416859
  419882
  420106
  423736
  426456
  427490
  428494
  429941
  431636
  436542
  439899
  440701
  444601
  444732
  446081
  449744
  452844
  458927
  460451
  460525
  461106
  461451
  462599
  462762
  462883
  463774
  465174
  465307
  466533
  469935
  470184
  470491
  474096
  474112
  476871
  476929
  477853
  491071
  495901
  498118
  499720
  502677
  504171
  504328
  506420
  507189
  507827
  508082
  509363
  509401
  510495
  510496
  510645
  511999
  514945
  515966
  517344
  520608
  521364
  521991
  523952
  532384
  532941
  545848
  547903
  547913
  548675
  552183
  552213
  557202
  559030
  559033
  560447
  566581
  567591
  576161
  577553
  578126
  578350
  581228
  584861
  597601
  603587
  610066
  624753
  640252
  652526
  652968
  652969
  663412
  664287
  670376
  675297
  688041
  697169
  701051
  712823
  716405
  718720
  729894
  737177
  742368
  756735
  762743
  768013
  769733
  800261
  801322
  811084
  812325
  819320
  824289
]
15.01 ms
(8.11%)
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
  819320
  824289
  452844
  463774
  465174
  476871
  458927
  460525
  466533
  474096
  520608
  509363
  509401
  508082
  510495
  514945
  515966
  462883
  491071
  548675
  557202
  567591
  547903
  552183
  552213
  566581
  584861
  652526
  670376
  697169
  712823
  664287
  675297
  718720
  603587
  624753
  640252
  597601
  800261
  742368
  811084
  812325
  762743
  768013
  769733
  729894
  737177
  756735
  610066
  701051
  801322
  413053
  462599
  388761
  390207
  439899
  462762
  469935
  470491
  395917
  398582
  461451
  476929
  429941
  431636
  446081
  449744
  511999
  521991
  504328
  498118
  506420
  510496
  510645
  517344
  523952
  405000
  426456
  465307
  688041
  428494
  419882
  388102
  427490
  407404
  440701
  444732
  416859
  444601
  420106
  423736
  436542
  460451
  461106
  470184
  474112
  477853
  504171
  507827
  521364
  532384
  532941
  499720
  502677
  507189
  495901
  545848
  559033
  560447
  577553
  581228
  547913
  559030
  576161
  578126
  578350
  663412
  716405
  652968
  652969
]
3.28 ms
(1.77%)
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
  388102
  388761
  390207
  395917
  398582
  405000
  407404
  413053
  416859
  419882
  420106
  423736
  426456
  427490
  428494
  429941
  431636
  436542
  439899
  440701
  444601
  444732
  446081
  449744
  452844
  458927
  460451
  460525
  461106
  461451
  462599
  462762
  462883
  463774
  465174
  465307
  466533
  469935
  470184
  470491
  474096
  474112
  476871
  476929
  477853
  491071
  495901
  498118
  499720
  502677
  504171
  504328
  506420
  507189
  507827
  508082
  509363
  509401
  510495
  510496
  510645
  511999
  514945
  515966
  517344
  520608
  521364
  521991
  523952
  532384
  532941
  545848
  547903
  547913
  548675
  552183
  552213
  557202
  559030
  559033
  560447
  566581
  567591
  576161
  577553
  578126
  578350
  581228
  584861
  597601
  603587
  610066
  624753
  640252
  652526
  652968
  652969
  663412
  664287
  670376
  675297
  688041
  697169
  701051
  712823
  716405
  718720
  729894
  737177
  742368
  756735
  762743
  768013
  769733
  800261
  801322
  811084
  812325
  819320
  824289
]
2.22 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "couple licking"
]
1.99 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "couple лиза"
]
1.62 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "couple лиза"
]

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.