GET https://search.jues.net/search/embeds/3?q=step%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.44 ms
(82.79%)
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
  390794
  402599
  409088
  430247
  438208
  440771
  447979
  451165
  459783
  463703
  464805
  471628
  478186
  482251
  485460
  515384
  530409
  535915
  547607
  553433
  557958
  559052
  562987
  565898
  566257
  568367
  569394
  571129
  579227
  581893
  582197
  582656
  590735
  591049
  592933
  593598
  593805
  599710
  601325
  602707
  603307
  605261
  609759
  609819
  610114
  615015
  616679
  630332
  633412
  649440
  687942
  688052
  695087
  701247
  702312
  704174
  709503
  709575
  714626
  716935
  717948
  718876
  719443
  726390
  731269
  736130
  736977
  742839
  743115
  743479
  746267
  749766
  749773
  753722
  757114
  758564
  764802
  769547
  769550
  772444
  772446
  773814
  775270
  777196
  777270
  777732
  782503
  786216
  787636
  789188
  790534
  792522
  793282
  793500
  794403
  796197
  796206
  796214
  797468
  798763
  799071
  799983
  803518
  803944
  804329
  807453
  811214
  813752
  813771
  816641
  818672
  819489
  820745
  820746
  821757
  821762
  825114
  825615
]
16.13 ms
(10.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
  796197
  731269
  749766
  773814
  609819
  793282
  794403
  557958
  615015
  402599
  530409
  687942
  716935
  777270
  821762
  688052
  743115
  559052
  777732
  390794
  438208
  430247
  813771
  582656
  593805
  603307
  782503
  789188
  799071
  807453
  792522
  798763
  803518
  736130
  736977
  796214
  746267
  630332
  709575
  799983
  819489
  820746
  463703
  599710
  753722
  440771
  581893
  579227
  610114
  787636
  758564
  718876
  790534
  764802
  818672
  816641
  811214
  566257
  825615
  478186
  447979
  609759
  813752
  565898
  553433
  649440
  702312
  592933
  591049
  593598
  633412
  786216
  726390
  769550
  772444
  804329
  535915
  825114
  482251
  464805
  569394
  717948
  571129
  601325
  605261
  775270
  742839
  772446
  796206
  757114
  714626
  459783
  471628
  820745
  821757
  777196
  803944
  769547
  797468
  547607
  485460
  515384
  562987
  590735
  409088
  451165
  568367
  582197
  695087
  719443
  701247
  704174
  602707
  616679
  793500
  736517
  743479
  749773
  769530
  709503
]
3.29 ms
(2.12%)
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
  390794
  402599
  409088
  430247
  438208
  440771
  447979
  451165
  459783
  463703
  464805
  471628
  478186
  482251
  485460
  515384
  530409
  535915
  547607
  553433
  557958
  559052
  562987
  565898
  566257
  568367
  569394
  571129
  579227
  581893
  582197
  582656
  590735
  591049
  592933
  593598
  593805
  599710
  601325
  602707
  603307
  605261
  609759
  609819
  610114
  615015
  616679
  630332
  633412
  649440
  687942
  688052
  695087
  701247
  702312
  704174
  709503
  709575
  714626
  716935
  717948
  718876
  719443
  726390
  731269
  736130
  736977
  742839
  743115
  743479
  746267
  749766
  749773
  753722
  757114
  758564
  764802
  769547
  769550
  772444
  772446
  773814
  775270
  777196
  777270
  777732
  782503
  786216
  787636
  789188
  790534
  792522
  793282
  793500
  794403
  796197
  796206
  796214
  797468
  798763
  799071
  799983
  803518
  803944
  804329
  807453
  811214
  813752
  813771
  816641
  818672
  819489
  820745
  820746
  821757
  821762
  825114
  825615
]
1.99 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step мам женщин"
]
1.94 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step mother"
]
1.69 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step мам женщин"
]
1.65 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.