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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.54 ms
(55.29%)
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
  6670
  191316
  341782
  348262
  383719
  383985
  384494
  385175
  385752
  387470
  392082
  395592
  401183
  411709
  419538
  435052
  440620
  442146
  442211
  452594
  454196
  455834
  459844
  464404
  465654
  466150
  466782
  467621
  469453
  470172
  474414
  474964
  479046
  483484
  485083
  486454
  487578
  491352
  492100
  495256
  500628
  503476
  504059
  512494
  513030
  513214
  515588
  515679
  517080
  518564
  518973
  519438
  522034
  522827
  522875
  523280
  525740
  526222
  526268
  534962
  535414
  541907
  544264
  546851
  550823
  552000
  554434
  563214
  569052
  585446
  585519
  588375
  588411
  591702
  592993
  593400
  600786
  605093
  606656
  619235
  619475
  651685
  663982
  665884
  666353
  667196
  671665
  689833
  690144
  695241
  702065
  707308
  708435
  716111
  717998
  718733
  719059
  721895
  724171
  726602
  735875
  741077
  743861
  748144
  759867
  760801
  771757
  777792
  789629
  789708
  791555
  799710
  800356
  802117
  805075
  811105
  815078
  815283
  815977
  818430
]
143.03 ms
(38.29%)
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
  6670
  191316
  341782
  348262
  383719
  383985
  384494
  385175
  385752
  387470
  392082
  395592
  401183
  411709
  419538
  435052
  440620
  442146
  442211
  452594
  454196
  455834
  459844
  464404
  465654
  466150
  466782
  467621
  469453
  470172
  474414
  474964
  479046
  483484
  485083
  486454
  487578
  491352
  492100
  495256
  500628
  503476
  504059
  512494
  513030
  513214
  515588
  515679
  517080
  518564
  518973
  519438
  522034
  522827
  522875
  523280
  525740
  526222
  526268
  534962
  535414
  541907
  544264
  546851
  550823
  552000
  554434
  563214
  569052
  585446
  585519
  588375
  588411
  591702
  592993
  593400
  600786
  605093
  606656
  619235
  619475
  651685
  663982
  665884
  666353
  667196
  671665
  689833
  690144
  695241
  702065
  707308
  708435
  716111
  717998
  718733
  719059
  721895
  724171
  726602
  735875
  741077
  743861
  748144
  759867
  760801
  771757
  777792
  789629
  789708
  791555
  799710
  800356
  802117
  805075
  811105
  815078
  815283
  815977
  818430
]
17.05 ms
(4.56%)
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
  467621
  435052
  500628
  487578
  485083
  401183
  592993
  585519
  6670
  503476
  619475
  191316
  442211
  522034
  667196
  663982
  563214
  419538
  383985
  459844
  474964
  492100
  486454
  517080
  525740
  483484
  491352
  384494
  513030
  526268
  550823
  474414
  535414
  470172
  522827
  464404
  554434
  385752
  392082
  815283
  818430
  815078
  815977
  534962
  518973
  552000
  569052
  541907
  544264
  651685
  671665
  689833
  708435
  718733
  719059
  665884
  690144
  695241
  702065
  717998
  546851
  619235
  591702
  789629
  789708
  799710
  805075
  741077
  791555
  800356
  811105
  735875
  759867
  726602
  743861
  724171
  748144
  771757
  707308
  777792
  341782
  387470
  522875
  760801
  479046
  469453
  411709
  495256
  588411
  385175
  442146
  721895
  605093
  606656
  802117
  518564
  716111
  523280
  593400
  588375
  455834
  395592
  440620
  466782
  504059
  585446
  452594
  465654
  600786
  383719
  348262
  454196
  466150
  512494
  515679
  519438
  526222
  515588
  513214
  666353
]
1.87 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings office"
]
1.78 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел секретарш"
]
1.63 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.