GET https://search.jues.net/search/embeds/9?q=sexy%20stockings

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.13 ms
(83.46%)
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
  114730
  382591
  385037
  403588
  403880
  413346
  421773
  426399
  428003
  442805
  447490
  451264
  452553
  455646
  457200
  467359
  469003
  471331
  471475
  473928
  477032
  479177
  479669
  479713
  479944
  479950
  480203
  480724
  484821
  485086
  485367
  486228
  489060
  490409
  490414
  492841
  495778
  503490
  504791
  505107
  507647
  508941
  511347
  513061
  515454
  515586
  515593
  516265
  522216
  523873
  525376
  525735
  536288
  536359
  537686
  540794
  547485
  551525
  554635
  556612
  559733
  563222
  566577
  568331
  568660
  569566
  570328
  572264
  572931
  577888
  579149
  579633
  582369
  585358
  585750
  589014
  589898
  590429
  591131
  597075
  598391
  602249
  607155
  608720
  625172
  635667
  640317
  650586
  669062
  675231
  677360
  712558
  721532
  724633
  724854
  727743
  727771
  750756
  751111
  752670
  758388
  758606
  759941
  761466
  769645
  769764
  770836
  774333
  779039
  781001
  786254
  789690
  795030
  796509
  798325
  801471
  807493
  807597
  811421
  815124
]
17.15 ms
(10.67%)
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
  556612
  579633
  590429
  473928
  507647
  489060
  490414
  795030
  598391
  789690
  515593
  442805
  577888
  114730
  382591
  815124
  457200
  477032
  479669
  479713
  559733
  568331
  570328
  669062
  675231
  712558
  677360
  721532
  650586
  563222
  569566
  572931
  589898
  608720
  640317
  589014
  607155
  635667
  781001
  796509
  798325
  807597
  727743
  751111
  758388
  761466
  770836
  786254
  724633
  727771
  758606
  774333
  724854
  750756
  759941
  752670
  769645
  769764
  779039
  807493
  811421
  467359
  471331
  479950
  479177
  480203
  385037
  413346
  479944
  486228
  485367
  522216
  525376
  515586
  525735
  485086
  426399
  428003
  471475
  536288
  547485
  551525
  566577
  801471
  523873
  540794
  504791
  403880
  582369
  492841
  515454
  572264
  495778
  480724
  554635
  568660
  585358
  585750
  421773
  455646
  508941
  503490
  536359
  447490
  451264
  484821
  602249
  403588
  469003
  511347
  516265
  505107
  513061
  597075
  625172
  537686
  490409
  579149
  591131
  452553
]
2.88 ms
(1.79%)
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
  114730
  382591
  385037
  403588
  403880
  413346
  421773
  426399
  428003
  442805
  447490
  451264
  452553
  455646
  457200
  467359
  469003
  471331
  471475
  473928
  477032
  479177
  479669
  479713
  479944
  479950
  480203
  480724
  484821
  485086
  485367
  486228
  489060
  490409
  490414
  492841
  495778
  503490
  504791
  505107
  507647
  508941
  511347
  513061
  515454
  515586
  515593
  516265
  522216
  523873
  525376
  525735
  536288
  536359
  537686
  540794
  547485
  551525
  554635
  556612
  559733
  563222
  566577
  568331
  568660
  569566
  570328
  572264
  572931
  577888
  579149
  579633
  582369
  585358
  585750
  589014
  589898
  590429
  591131
  597075
  598391
  602249
  607155
  608720
  625172
  635667
  640317
  650586
  669062
  675231
  677360
  712558
  721532
  724633
  724854
  727743
  727771
  750756
  751111
  752670
  758388
  758606
  759941
  761466
  769645
  769764
  770836
  774333
  779039
  781001
  786254
  789690
  795030
  796509
  798325
  801471
  807493
  807597
  811421
  815124
]
1.73 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy stockings"
]
1.65 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy чулк нижн бел"
]
1.64 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy чулк нижн бел"
]

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.