GET https://search.jues.net/search/embeds/5?q=mature%20secretary

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.30 ms
(87.40%)
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
  181569
  188507
  233187
  265967
  384988
  387899
  391392
  395240
  395668
  396357
  396404
  402960
  440623
  449872
  452415
  453149
  454555
  459756
  459928
  460175
  464240
  464430
  465382
  467471
  467510
  467512
  467515
  469344
  469509
  470971
  471713
  474104
  474414
  479145
  479147
  483090
  484605
  485073
  485548
  490872
  490928
  494514
  495121
  501179
  501205
  503486
  507170
  508293
  513436
  514363
  514818
  514831
  516806
  519089
  526401
  528807
  530935
  531790
  535414
  535529
  541102
  541637
  544476
  544478
  546255
  546712
  554380
  560485
  560899
  581316
  585498
  588375
  591895
  594827
  600223
  601119
  605218
  610006
  610573
  611950
  611978
  613780
  615022
  619483
  647856
  665260
  667473
  683284
  696308
  697014
  698517
  699675
  707314
  710826
  715394
  715786
  725521
  730104
  730736
  761589
  796504
  802076
  802739
  808212
  808527
  809339
  811220
  815118
  815167
  815290
  815397
  815676
  816266
  817840
  818215
  818391
  819606
  823149
  823176
  826938
]
15.69 ms
(7.40%)
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
  507170
  453149
  530935
  391392
  460175
  696308
  715786
  808527
  474104
  479145
  490872
  544478
  396357
  816266
  823149
  826938
  817840
  818215
  531790
  541102
  667473
  710826
  683284
  699675
  665260
  546255
  591895
  610573
  611978
  585498
  600223
  802739
  802076
  809339
  730736
  808212
  725521
  761589
  698517
  707314
  796504
  402960
  601119
  528807
  501179
  619483
  440623
  469509
  588375
  815290
  459928
  485073
  474414
  503486
  494514
  495121
  554380
  546712
  560899
  613780
  594827
  811220
  611950
  449872
  396404
  464240
  470971
  395240
  459756
  479147
  501205
  508293
  485548
  535414
  233187
  188507
  387899
  467515
  452415
  483090
  519089
  526401
  535529
  514818
  513436
  471713
  541637
  560485
  544476
  697014
  647856
  715394
  581316
  605218
  615022
  610006
  730104
  465382
  469344
  464430
  467471
  454555
  467512
  467510
  516806
  484605
  490928
  514363
  514831
  384988
  181569
  395668
  265967
  818391
  815118
  815397
  815676
  823176
  815167
  819606
]
3.59 ms
(1.70%)
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
  181569
  188507
  233187
  265967
  384988
  387899
  391392
  395240
  395668
  396357
  396404
  402960
  440623
  449872
  452415
  453149
  454555
  459756
  459928
  460175
  464240
  464430
  465382
  467471
  467510
  467512
  467515
  469344
  469509
  470971
  471713
  474104
  474414
  479145
  479147
  483090
  484605
  485073
  485548
  490872
  490928
  494514
  495121
  501179
  501205
  503486
  507170
  508293
  513436
  514363
  514818
  514831
  516806
  519089
  526401
  528807
  530935
  531790
  535414
  535529
  541102
  541637
  544476
  544478
  546255
  546712
  554380
  560485
  560899
  581316
  585498
  588375
  591895
  594827
  600223
  601119
  605218
  610006
  610573
  611950
  611978
  613780
  615022
  619483
  647856
  665260
  667473
  683284
  696308
  697014
  698517
  699675
  707314
  710826
  715394
  715786
  725521
  730104
  730736
  761589
  796504
  802076
  802739
  808212
  808527
  809339
  811220
  815118
  815167
  815290
  815397
  815676
  816266
  817840
  818215
  818391
  819606
  823149
  823176
  826938
]
2.10 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature secretary"
]
1.94 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature секретарш"
]
1.58 ms
(0.75%)
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.