GET https://search.jues.net/search/embeds?q=mom%20doggy%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.65 ms
(88.19%)
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
  7748
  73143
  91345
  153618
  229207
  381958
  387104
  388113
  388228
  391565
  392772
  395530
  395534
  395988
  396862
  397014
  401014
  403463
  403600
  413112
  413130
  417849
  421132
  421887
  422171
  422807
  424096
  428846
  428910
  433070
  439713
  443160
  446277
  448362
  448955
  450821
  461841
  472166
  472299
  480415
  486820
  493247
  499332
  500931
  511500
  514589
  516008
  520691
  522614
  522645
  526528
  527174
  528750
  529965
  531993
  532055
  532587
  535734
  536944
  537815
  541528
  543994
  547885
  551508
  552942
  555093
  559881
  562550
  567081
  571508
  573990
  581893
  584395
  585145
  586682
  591944
  598206
  608639
  609823
  611389
  619490
  634275
  636140
  639788
  650625
  650681
  661056
  666612
  670753
  683078
  686768
  707457
  710275
  714544
  723726
  725639
  725654
  726891
  742638
  748609
  753633
  758023
  758564
  764044
  768962
  771243
  772208
  773105
  784641
  801590
  805715
  813118
  814583
  814587
  815770
  818502
  821762
  823592
  828397
  828871
]
10.47 ms
(6.13%)
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
  7748
  392772
  815770
  609823
  537815
  403600
  396862
  535734
  821762
  443160
  562550
  584395
  428846
  229207
  636140
  531993
  413130
  725654
  573990
  421887
  532055
  683078
  784641
  639788
  725639
  153618
  461841
  619490
  547885
  493247
  73143
  742638
  670753
  753633
  634275
  571508
  381958
  661056
  395988
  541528
  532587
  773105
  424096
  522645
  397014
  818502
  650625
  591944
  828397
  91345
  514589
  543994
  748609
  391565
  813118
  395530
  536944
  499332
  559881
  723726
  395534
  516008
  486820
  585145
  527174
  771243
  726891
  403463
  714544
  422171
  413112
  586682
  388113
  611389
  768962
  528750
  828871
  472166
  666612
  472299
  422807
  686768
  551508
  446277
  805715
  401014
  522614
  707457
  608639
  801590
  758023
  650681
  552942
  520691
  439713
  448362
  450821
  764044
  772208
  388228
  710275
  555093
  428910
  581893
  758564
  387104
  823592
  421132
  433070
  500931
  511500
  567081
  598206
  480415
  526528
  529965
  448955
  417849
  814583
  814587
]
2.67 ms
(1.56%)
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
  7748
  73143
  91345
  153618
  229207
  381958
  387104
  388113
  388228
  391565
  392772
  395530
  395534
  395988
  396862
  397014
  401014
  403463
  403600
  413112
  413130
  417849
  421132
  421887
  422171
  422807
  424096
  428846
  428910
  433070
  439713
  443160
  446277
  448362
  448955
  450821
  461841
  472166
  472299
  480415
  486820
  493247
  499332
  500931
  511500
  514589
  516008
  520691
  522614
  522645
  526528
  527174
  528750
  529965
  531993
  532055
  532587
  535734
  536944
  537815
  541528
  543994
  547885
  551508
  552942
  555093
  559881
  562550
  567081
  571508
  573990
  581893
  584395
  585145
  586682
  591944
  598206
  608639
  609823
  611389
  619490
  634275
  636140
  639788
  650625
  650681
  661056
  666612
  670753
  683078
  686768
  707457
  710275
  714544
  723726
  725639
  725654
  726891
  742638
  748609
  753633
  758023
  758564
  764044
  768962
  771243
  772208
  773105
  784641
  801590
  805715
  813118
  814583
  814587
  815770
  818502
  821762
  823592
  828397
  828871
]
2.15 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom doggy big"
]
1.83 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom рак большие"
]
1.77 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.75%)
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.