GET https://search.jues.net/search/embeds/6?q=milf%20bdsm%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.60 ms
(85.51%)
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
  412925
  420125
  420203
  420267
  421234
  422208
  428116
  430314
  434209
  439518
  441952
  443636
  447810
  447896
  451866
  452535
  454107
  465731
  467867
  469595
  470774
  473791
  475833
  475927
  478090
  486217
  486685
  487746
  490684
  495400
  496603
  497866
  497921
  500375
  503405
  505132
  506500
  508565
  509879
  510396
  511812
  512059
  515420
  517005
  518599
  519390
  519561
  522157
  522871
  522917
  522976
  524018
  524712
  525731
  525864
  526047
  526891
  528682
  529794
  530010
  530275
  530377
  530495
  530659
  530703
  530808
  531097
  532655
  532680
  532762
  533844
  534645
  534988
  535023
  535025
  535084
  536586
  537114
  537241
  537584
  537595
  540437
  541872
  543552
  543652
  543840
  543848
  543856
  544627
  559111
  559142
  560924
  561136
  565909
  568480
  569927
  576219
  578411
  580290
  585954
  587970
  590505
  593863
  596082
  596851
  599835
  600014
  609958
  613508
  617418
  630552
  632680
  634138
  639706
  641949
  648241
  648252
  652544
  758915
  784304
]
19.70 ms
(9.70%)
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
  486217
  530010
  537241
  496603
  536586
  541872
  648252
  587970
  617418
  639706
  596082
  613508
  641949
  475927
  475833
  515420
  522917
  434209
  543856
  585954
  758915
  412925
  428116
  420203
  522157
  526891
  535084
  561136
  593863
  422208
  511812
  497866
  420125
  503405
  534988
  519390
  531097
  537114
  544627
  652544
  596851
  543848
  525731
  469595
  543652
  599835
  497921
  543552
  490684
  420267
  443636
  478090
  535023
  537595
  533844
  580290
  576219
  430314
  454107
  535025
  537584
  559142
  568480
  632680
  634138
  421234
  509879
  522871
  473791
  451866
  532655
  560924
  609958
  447810
  530703
  519561
  530495
  578411
  439518
  526047
  524712
  532680
  505132
  510396
  524018
  530808
  447896
  486685
  487746
  530275
  528682
  532762
  559111
  470774
  452535
  525864
  512059
  530377
  540437
  530659
  648241
  630552
  467867
  518599
  529794
  441952
  465731
  569927
  784304
  590505
  500375
  600014
  565909
  534645
  517005
  495400
  506500
  522976
  543840
  508565
]
3.27 ms
(1.61%)
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
  412925
  420125
  420203
  420267
  421234
  422208
  428116
  430314
  434209
  439518
  441952
  443636
  447810
  447896
  451866
  452535
  454107
  465731
  467867
  469595
  470774
  473791
  475833
  475927
  478090
  486217
  486685
  487746
  490684
  495400
  496603
  497866
  497921
  500375
  503405
  505132
  506500
  508565
  509879
  510396
  511812
  512059
  515420
  517005
  518599
  519390
  519561
  522157
  522871
  522917
  522976
  524018
  524712
  525731
  525864
  526047
  526891
  528682
  529794
  530010
  530275
  530377
  530495
  530659
  530703
  530808
  531097
  532655
  532680
  532762
  533844
  534645
  534988
  535023
  535025
  535084
  536586
  537114
  537241
  537584
  537595
  540437
  541872
  543552
  543652
  543840
  543848
  543856
  544627
  559111
  559142
  560924
  561136
  565909
  568480
  569927
  576219
  578411
  580290
  585954
  587970
  590505
  593863
  596082
  596851
  599835
  600014
  609958
  613508
  617418
  630552
  632680
  634138
  639706
  641949
  648241
  648252
  652544
  758915
  784304
]
1.73 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf bdsm anal"
]
1.62 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf бдсм анал"
]
1.60 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf бдсм анал"
]

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.