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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.19 ms
(83.15%)
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
  191495
  233365
  358592
  399164
  415551
  415822
  423505
  444223
  446993
  448398
  450198
  452330
  453147
  454551
  455747
  457038
  457199
  461860
  462002
  466948
  467639
  470689
  471336
  472268
  473449
  474205
  474891
  475715
  491331
  494227
  507249
  509075
  513766
  520318
  523601
  524314
  526938
  527061
  530045
  533740
  534651
  536381
  537075
  540461
  542522
  543623
  545181
  547614
  549298
  551073
  552852
  552863
  555009
  558750
  558757
  559674
  565328
  566014
  567411
  567481
  568216
  568346
  572605
  573216
  576972
  579213
  581135
  582615
  585380
  587533
  587996
  592511
  592857
  596292
  601030
  604082
  604704
  611186
  625849
  630448
  630890
  631807
  635486
  644588
  649093
  668937
  689701
  690050
  691510
  692806
  693799
  693990
  694470
  695246
  695249
  695628
  697369
  698550
  700953
  714623
  725303
  729453
  750729
  750893
  751958
  756504
  760687
  760862
  768032
  782978
  786258
  791567
  795832
  801569
  803148
  803292
  803676
  811093
  812495
  821596
]
16.20 ms
(10.43%)
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
  821596
  450198
  457199
  466948
  473449
  491331
  446993
  452330
  453147
  457038
  472268
  474205
  494227
  530045
  534651
  513766
  533740
  524314
  507249
  523601
  527061
  536381
  537075
  540461
  467639
  471336
  551073
  552863
  558750
  568346
  572605
  581135
  543623
  549298
  555009
  565328
  576972
  579213
  582615
  542522
  545181
  552852
  559674
  566014
  567481
  568216
  573216
  668937
  691510
  694470
  695628
  700953
  690050
  692806
  693799
  697369
  714623
  649093
  689701
  693990
  695246
  695249
  547614
  558757
  567411
  585380
  592857
  596292
  604704
  604082
  630448
  631807
  635486
  644588
  587533
  592511
  601030
  611186
  587996
  625849
  630890
  791567
  801569
  803148
  782978
  803292
  812495
  729453
  795832
  803676
  725303
  750729
  751958
  760687
  760862
  750893
  756504
  768032
  698550
  786258
  811093
  399164
  462002
  474891
  191495
  358592
  415551
  423505
  454551
  233365
  444223
  461860
  475715
  415822
  448398
  455747
  470689
  520318
  526938
  509075
]
2.44 ms
(1.57%)
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
  191495
  233365
  358592
  399164
  415551
  415822
  423505
  444223
  446993
  448398
  450198
  452330
  453147
  454551
  455747
  457038
  457199
  461860
  462002
  466948
  467639
  470689
  471336
  472268
  473449
  474205
  474891
  475715
  491331
  494227
  507249
  509075
  513766
  520318
  523601
  524314
  526938
  527061
  530045
  533740
  534651
  536381
  537075
  540461
  542522
  543623
  545181
  547614
  549298
  551073
  552852
  552863
  555009
  558750
  558757
  559674
  565328
  566014
  567411
  567481
  568216
  568346
  572605
  573216
  576972
  579213
  581135
  582615
  585380
  587533
  587996
  592511
  592857
  596292
  601030
  604082
  604704
  611186
  625849
  630448
  630890
  631807
  635486
  644588
  649093
  668937
  689701
  690050
  691510
  692806
  693799
  693990
  694470
  695246
  695249
  695628
  697369
  698550
  700953
  714623
  725303
  729453
  750729
  750893
  751958
  756504
  760687
  760862
  768032
  782978
  786258
  791567
  795832
  801569
  803148
  803292
  803676
  811093
  812495
  821596
]
1.97 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf video"
]
1.94 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf video"
]
1.81 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf video"
]

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.