GET https://search.jues.net/search/embeds/5?q=saggy%20tits%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.09 ms
(81.85%)
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
  80699
  153249
  391356
  423980
  426515
  428046
  428084
  441452
  443111
  443189
  443627
  443968
  443975
  444144
  445240
  445714
  446017
  448670
  453214
  453738
  454453
  454476
  455123
  457581
  459407
  459602
  459959
  460433
  460572
  481400
  483210
  485027
  487307
  487396
  489942
  493185
  494590
  495244
  499742
  506866
  506924
  507116
  511478
  512197
  518152
  521451
  523513
  530103
  530614
  531682
  532149
  537578
  539375
  539483
  539539
  545875
  545935
  546490
  547133
  548040
  548042
  549732
  550279
  551810
  554295
  563423
  563997
  568173
  569993
  574182
  577122
  579220
  614391
  618080
  618604
  624860
  634732
  635840
  638493
  641117
  644147
  651642
  665281
  666757
  666808
  684706
  697204
  705073
  710912
  711599
  717517
  725477
  728643
  730109
  734616
  735881
  736581
  745880
  746347
  763444
  794400
  799531
  800932
  800980
  804188
  804600
  806302
  810594
  811541
  813865
  817092
  817599
  818184
  818663
  825068
  825272
  825886
  827587
  828145
]
17.35 ms
(10.83%)
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
  443968
  817092
  828145
  548042
  614391
  638493
  80699
  563997
  644147
  539375
  493185
  153249
  428084
  445714
  448670
  487307
  457581
  460433
  485027
  454453
  512197
  506924
  550279
  569993
  579220
  549732
  577122
  666808
  665281
  459407
  391356
  459959
  459602
  443975
  428046
  444144
  453214
  521451
  487396
  511478
  618080
  635840
  804600
  804188
  763444
  443111
  825886
  818184
  827587
  828527
  537578
  530614
  546490
  568173
  574182
  547133
  545875
  545935
  651642
  666757
  548040
  624860
  799531
  811541
  734616
  806302
  736581
  730109
  735881
  728643
  634732
  641117
  697204
  710912
  800932
  817599
  818663
  813865
  532149
  810594
  506866
  825272
  825068
  531682
  618604
  800980
  746347
  794400
  426515
  453738
  423980
  483210
  539539
  725477
  745880
  445240
  494590
  523513
  499742
  443627
  441452
  443189
  454476
  455123
  446017
  507116
  539483
  495244
  518152
  530103
  460572
  481400
  489942
  554295
  684706
  717517
  705073
  711599
  551810
  563423
]
4.43 ms
(2.77%)
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
  80699
  153249
  391356
  423980
  426515
  428046
  428084
  441452
  443111
  443189
  443627
  443968
  443975
  444144
  445240
  445714
  446017
  448670
  453214
  453738
  454453
  454476
  455123
  457581
  459407
  459602
  459959
  460433
  460572
  481400
  483210
  485027
  487307
  487396
  489942
  493185
  494590
  495244
  499742
  506866
  506924
  507116
  511478
  512197
  518152
  521451
  523513
  530103
  530614
  531682
  532149
  537578
  539375
  539483
  539539
  545875
  545935
  546490
  547133
  548040
  548042
  549732
  550279
  551810
  554295
  563423
  563997
  568173
  569993
  574182
  577122
  579220
  614391
  618080
  618604
  624860
  634732
  635840
  638493
  641117
  644147
  651642
  665281
  666757
  666808
  684706
  697204
  705073
  710912
  711599
  717517
  725477
  728643
  730109
  734616
  735881
  736581
  745880
  746347
  763444
  794400
  799531
  800932
  800980
  804188
  804600
  806302
  810594
  811541
  813865
  817092
  817599
  818184
  818663
  825068
  825272
  825886
  827587
  828145
]
2.07 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy tits doggy"
]
1.84 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy сиськ рак"
]
1.70 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy сиськ рак"
]

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.