GET https://search.jues.net/search/embeds/9?q=licking%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.08 ms
(81.30%)
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
  286389
  416155
  417983
  418088
  418361
  421563
  423955
  425971
  435404
  450143
  459368
  460767
  461401
  461836
  464658
  469361
  470283
  470609
  471310
  473115
  480214
  480726
  481249
  485948
  487424
  492646
  499379
  502887
  505318
  508516
  519272
  520144
  520206
  521752
  522648
  523474
  523855
  524743
  525156
  526105
  528030
  528466
  543974
  544515
  545099
  548725
  553428
  555206
  555696
  556561
  559614
  559985
  566055
  566061
  568368
  569274
  571797
  571840
  576904
  576935
  578739
  583598
  584660
  585170
  588794
  590892
  595192
  596176
  598633
  599230
  601634
  606734
  611588
  611812
  613246
  617614
  628659
  658810
  660111
  660435
  687259
  712243
  747066
  760181
  771177
  771182
  771255
  775707
  776582
  780706
  784717
  789491
  789571
  790008
  791356
  792412
  795143
  795148
  797262
  798622
  799394
  802947
  805212
  809481
  812265
  812387
  813894
  814274
  815010
  815075
  816326
  819652
  820406
  820783
  821671
  821741
  822080
  822512
  823217
  826763
]
16.11 ms
(10.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
  470283
  480726
  418361
  508516
  487424
  519272
  524743
  523474
  505318
  526105
  523855
  502887
  522648
  569274
  559614
  595192
  601634
  528030
  417983
  425971
  815075
  820783
  821671
  821741
  822080
  814274
  819652
  820406
  826763
  816326
  823217
  813894
  815010
  822512
  450143
  461836
  471310
  469361
  492646
  499379
  520144
  521752
  528466
  525156
  520206
  464658
  481249
  485948
  543974
  548725
  556561
  568368
  571797
  553428
  559985
  566055
  566061
  571840
  576904
  584660
  544515
  545099
  555206
  576935
  658810
  687259
  712243
  660111
  660435
  555696
  578739
  583598
  613246
  617614
  596176
  588794
  598633
  599230
  611812
  585170
  590892
  606734
  611588
  628659
  784717
  789571
  798622
  812387
  775707
  776582
  795143
  795148
  760181
  790008
  791356
  797262
  802947
  771255
  747066
  771177
  771182
  780706
  789491
  792412
  799394
  805212
  809481
  812265
  460767
  416155
  421563
  459368
  470609
  480214
  286389
  423955
  435404
  418088
  461401
  473115
]
3.01 ms
(2.04%)
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
  286389
  416155
  417983
  418088
  418361
  421563
  423955
  425971
  435404
  450143
  459368
  460767
  461401
  461836
  464658
  469361
  470283
  470609
  471310
  473115
  480214
  480726
  481249
  485948
  487424
  492646
  499379
  502887
  505318
  508516
  519272
  520144
  520206
  521752
  522648
  523474
  523855
  524743
  525156
  526105
  528030
  528466
  543974
  544515
  545099
  548725
  553428
  555206
  555696
  556561
  559614
  559985
  566055
  566061
  568368
  569274
  571797
  571840
  576904
  576935
  578739
  583598
  584660
  585170
  588794
  590892
  595192
  596176
  598633
  599230
  601634
  606734
  611588
  611812
  613246
  617614
  628659
  658810
  660111
  660435
  687259
  712243
  747066
  760181
  771177
  771182
  771255
  775707
  776582
  780706
  784717
  789491
  789571
  790008
  791356
  792412
  795143
  795148
  797262
  798622
  799394
  802947
  805212
  809481
  812265
  812387
  813894
  814274
  815010
  815075
  816326
  819652
  820406
  820783
  821671
  821741
  822080
  822512
  823217
  826763
]
2.22 ms
(1.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.18 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking pov"
]
2.14 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза пов"
]
1.96 ms
(1.33%)
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.