GET https://search.jues.net/search/embeds/6?q=mature%20big%20squirt

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.07 ms
(85.11%)
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
  406089
  409035
  412062
  415859
  418952
  421094
  422340
  423379
  423657
  428103
  430477
  431341
  434337
  443389
  450255
  452638
  452953
  453307
  453344
  454518
  454801
  459151
  460218
  460338
  460658
  462751
  464971
  466294
  468019
  468142
  469434
  469513
  469586
  472124
  472625
  475245
  479477
  479661
  486665
  490831
  491790
  492714
  493180
  493190
  493258
  494231
  494233
  499105
  502324
  505390
  508187
  509024
  511273
  513214
  515571
  519349
  519653
  520778
  522153
  527415
  528384
  529265
  530011
  533643
  534301
  534574
  535019
  535057
  537671
  540564
  544819
  545368
  546110
  550200
  550362
  552585
  554840
  564387
  578829
  584602
  592702
  595061
  597839
  601535
  601604
  602259
  604811
  605688
  608174
  617129
  625801
  628707
  629808
  631937
  633741
  635432
  639742
  642315
  642403
  643100
  693925
  717606
  720249
  729829
  733518
  734038
  736386
  748227
  751572
  770155
  770501
  778941
  788196
  801287
  811296
  811955
  815232
  816007
  818156
  818439
]
19.82 ms
(9.92%)
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
  454518
  469513
  519653
  554840
  550362
  592702
  617129
  597839
  642403
  778941
  751572
  412062
  450255
  493258
  511273
  492714
  453307
  443389
  422340
  468019
  639742
  453344
  528384
  530011
  460658
  452638
  601535
  428103
  415859
  434337
  818439
  454801
  508187
  519349
  534301
  534574
  513214
  472625
  550200
  601604
  605688
  629808
  625801
  628707
  788196
  801287
  729829
  811955
  635432
  479477
  602259
  430477
  459151
  578829
  604811
  733518
  815232
  493190
  499105
  533643
  535057
  540564
  546110
  544819
  552585
  811296
  748227
  717606
  418952
  452953
  816007
  818156
  490831
  469586
  529265
  479661
  693925
  720249
  631937
  642315
  406089
  502324
  584602
  633741
  464971
  509024
  515571
  537671
  522153
  595061
  736386
  770155
  494233
  520778
  535019
  494231
  545368
  491790
  462751
  486665
  493180
  423379
  469434
  468142
  564387
  643100
  734038
  770501
  460338
  466294
  460218
  505390
  431341
  527415
  475245
  421094
  472124
  409035
  608174
  423657
]
2.75 ms
(1.38%)
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
  406089
  409035
  412062
  415859
  418952
  421094
  422340
  423379
  423657
  428103
  430477
  431341
  434337
  443389
  450255
  452638
  452953
  453307
  453344
  454518
  454801
  459151
  460218
  460338
  460658
  462751
  464971
  466294
  468019
  468142
  469434
  469513
  469586
  472124
  472625
  475245
  479477
  479661
  486665
  490831
  491790
  492714
  493180
  493190
  493258
  494231
  494233
  499105
  502324
  505390
  508187
  509024
  511273
  513214
  515571
  519349
  519653
  520778
  522153
  527415
  528384
  529265
  530011
  533643
  534301
  534574
  535019
  535057
  537671
  540564
  544819
  545368
  546110
  550200
  550362
  552585
  554840
  564387
  578829
  584602
  592702
  595061
  597839
  601535
  601604
  602259
  604811
  605688
  608174
  617129
  625801
  628707
  629808
  631937
  633741
  635432
  639742
  642315
  642403
  643100
  693925
  717606
  720249
  729829
  733518
  734038
  736386
  748227
  751572
  770155
  770501
  778941
  788196
  801287
  811296
  811955
  815232
  816007
  818156
  818439
]
2.08 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature big squirt"
]
1.68 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature большие сквирт оргазм"
]
1.58 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature большие сквирт оргазм"
]

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.