GET https://search.jues.net/search/embeds/6?q=skinny%20mmf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.03 ms
(50.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
179.01 ms
(43.44%)
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
  95864
  193666
  395539
  406332
  408616
  413833
  417367
  418065
  420060
  426033
  429196
  429805
  448584
  455110
  469917
  470236
  470778
  473548
  475894
  475918
  477354
  479844
  480429
  484843
  486415
  486757
  490841
  491474
  497583
  499543
  507814
  508016
  508053
  508525
  511702
  518028
  521823
  521993
  522939
  524067
  524726
  526126
  526145
  529855
  530012
  530663
  533548
  535747
  537500
  541781
  543587
  544396
  544485
  548606
  550979
  551164
  551179
  551219
  552119
  554418
  559055
  560430
  560590
  561134
  561416
  562281
  562839
  565349
  565416
  565429
  565462
  566579
  566620
  567748
  567762
  568190
  568281
  574269
  575162
  575201
  576056
  576109
  576381
  576384
  581552
  583511
  583592
  584550
  584710
  585730
  593368
  593841
  603216
  604142
  604984
  606540
  612066
  631947
  667859
  684541
  716777
  720875
  721613
  730098
  733889
  742484
  775780
  775836
  777140
  785337
  788582
  790213
  800610
  805372
  809300
  809302
  810694
  821852
  821856
  825561
]
17.17 ms
(4.17%)
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
  775780
  777140
  785337
  733889
  720875
  800610
  448584
  473548
  395539
  455110
  469917
  479844
  508016
  486757
  497583
  524726
  491474
  548606
  499543
  544396
  551164
  551179
  565349
  575201
  576381
  565462
  684541
  612066
  470778
  484843
  526145
  530663
  418065
  420060
  535747
  559055
  554418
  552119
  583592
  470236
  821852
  821856
  825561
  507814
  533548
  543587
  544485
  583511
  565416
  565429
  566579
  721613
  667859
  716777
  603216
  775836
  805372
  788582
  742484
  730098
  790213
  809302
  508053
  526126
  490841
  511702
  508525
  537500
  561416
  568190
  604984
  475894
  522939
  550979
  581552
  541781
  568281
  585730
  574269
  593368
  524067
  429805
  406332
  551219
  567748
  576109
  562839
  604142
  417367
  413833
  518028
  606540
  529855
  480429
  193666
  486415
  530012
  575162
  561134
  566620
  567762
  593841
  631947
  809300
  475918
  477354
  584710
  810694
  95864
  521993
  429196
  560590
  576384
  584550
  562281
  576056
  560430
  426033
  521823
  408616
]
3.04 ms
(0.74%)
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
  95864
  193666
  395539
  406332
  408616
  413833
  417367
  418065
  420060
  426033
  429196
  429805
  448584
  455110
  469917
  470236
  470778
  473548
  475894
  475918
  477354
  479844
  480429
  484843
  486415
  486757
  490841
  491474
  497583
  499543
  507814
  508016
  508053
  508525
  511702
  518028
  521823
  521993
  522939
  524067
  524726
  526126
  526145
  529855
  530012
  530663
  533548
  535747
  537500
  541781
  543587
  544396
  544485
  548606
  550979
  551164
  551179
  551219
  552119
  554418
  559055
  560430
  560590
  561134
  561416
  562281
  562839
  565349
  565416
  565429
  565462
  566579
  566620
  567748
  567762
  568190
  568281
  574269
  575162
  575201
  576056
  576109
  576381
  576384
  581552
  583511
  583592
  584550
  584710
  585730
  593368
  593841
  603216
  604142
  604984
  606540
  612066
  631947
  667859
  684541
  716777
  720875
  721613
  730098
  733889
  742484
  775780
  775836
  777140
  785337
  788582
  790213
  800610
  805372
  809300
  809302
  810694
  821852
  821856
  825561
]
2.11 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny mmf"
]
1.91 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые мжм секс втро"
]
1.82 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.