GET https://search.jues.net/search/embeds/6?q=bdsm%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.29 ms
(51.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм mom"
]
167.21 ms
(40.92%)
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
  415004
  422208
  425622
  428116
  439560
  439799
  442239
  443646
  446054
  446633
  450226
  450641
  463094
  463305
  466685
  468631
  468884
  469566
  470416
  472743
  474785
  475833
  478530
  478832
  480526
  481173
  486665
  486706
  488477
  488538
  491266
  491273
  494081
  494516
  496103
  496835
  497332
  499787
  500430
  500562
  501193
  501474
  507211
  509660
  511160
  511812
  512176
  513155
  513677
  514709
  514746
  514757
  515420
  515934
  516610
  517587
  517932
  519549
  521167
  521206
  521381
  522016
  522460
  522604
  522917
  522925
  523291
  524257
  524309
  525087
  527014
  527065
  527377
  527916
  528119
  528297
  530010
  531419
  532028
  533450
  533844
  534334
  536233
  536335
  536586
  537595
  540071
  540562
  544302
  561107
  561136
  561140
  561142
  563844
  565150
  567347
  572189
  579205
  580290
  581882
  596082
  596900
  600014
  604369
  605636
  610692
  617418
  624290
  632694
  637413
  638991
  639706
  644998
  648252
  648861
  650851
  678969
  724823
  784315
  816086
]
20.30 ms
(4.97%)
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
  463094
  415004
  439560
  450226
  450641
  463305
  443646
  470416
  472743
  468884
  481173
  501193
  514757
  528119
  491266
  497332
  513677
  514746
  525087
  488477
  488538
  496835
  507211
  521167
  523291
  524257
  527377
  528297
  533450
  496103
  527014
  650851
  600014
  512176
  532028
  644998
  816086
  446054
  474785
  522925
  530010
  536335
  513155
  536586
  514709
  521206
  466685
  561140
  561142
  563844
  565150
  572189
  581882
  678969
  648252
  648861
  561107
  638991
  596900
  610692
  617418
  639706
  596082
  604369
  784315
  632694
  446633
  478530
  480526
  442239
  425622
  439799
  475833
  509660
  511160
  516610
  515934
  519549
  522460
  491273
  515420
  524309
  494516
  499787
  501474
  517587
  522016
  522604
  522917
  527916
  567347
  637413
  500562
  486665
  494081
  544302
  428116
  521381
  534334
  540562
  537595
  531419
  536233
  527065
  533844
  540071
  580290
  579205
  561136
  624290
  605636
  724823
  469566
  422208
  468631
  478832
  511812
  500430
  517932
  486706
]
3.09 ms
(0.76%)
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
  415004
  422208
  425622
  428116
  439560
  439799
  442239
  443646
  446054
  446633
  450226
  450641
  463094
  463305
  466685
  468631
  468884
  469566
  470416
  472743
  474785
  475833
  478530
  478832
  480526
  481173
  486665
  486706
  488477
  488538
  491266
  491273
  494081
  494516
  496103
  496835
  497332
  499787
  500430
  500562
  501193
  501474
  507211
  509660
  511160
  511812
  512176
  513155
  513677
  514709
  514746
  514757
  515420
  515934
  516610
  517587
  517932
  519549
  521167
  521206
  521381
  522016
  522460
  522604
  522917
  522925
  523291
  524257
  524309
  525087
  527014
  527065
  527377
  527916
  528119
  528297
  530010
  531419
  532028
  533450
  533844
  534334
  536233
  536335
  536586
  537595
  540071
  540562
  544302
  561107
  561136
  561140
  561142
  563844
  565150
  567347
  572189
  579205
  580290
  581882
  596082
  596900
  600014
  604369
  605636
  610692
  617418
  624290
  632694
  637413
  638991
  639706
  644998
  648252
  648861
  650851
  678969
  724823
  784315
  816086
]
1.97 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bdsm mom"
]
1.78 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм mom"
]

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.