GET https://search.jues.net/search/embeds/4?q=old%20mom%20rus

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.60 ms
(84.00%)
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
  383643
  389519
  390794
  391380
  391668
  392576
  400359
  400489
  400513
  407903
  409083
  411468
  411905
  413090
  413182
  421839
  421849
  421900
  422188
  422338
  426682
  426940
  428137
  428821
  428867
  429574
  433359
  439457
  439608
  439699
  439715
  440964
  443153
  443174
  443194
  443712
  443725
  443726
  443759
  443797
  443809
  443996
  450641
  454230
  454257
  460725
  460728
  460745
  462694
  463177
  465352
  465367
  465373
  465902
  466129
  466223
  466262
  466893
  466942
  467545
  469283
  470019
  470166
  470199
  470275
  474777
  474800
  475881
  476263
  476271
  476275
  476353
  477989
  481923
  482629
  484630
  486110
  490894
  490946
  491988
  492048
  506028
  508721
  511598
  518160
  523902
  523907
  526735
  539512
  546878
  546944
  546958
  547722
  547930
  549844
  557991
  560400
  563125
  563143
  563196
  563232
  563233
  569931
  569943
  573729
  578343
  581614
  598550
  601938
  621402
  626024
  696308
  699625
  726981
  781718
  784306
  784569
  788767
  807326
  813573
]
15.83 ms
(10.10%)
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
  784306
  784569
  383643
  409083
  426682
  454230
  467545
  476353
  477989
  391380
  426940
  428821
  439608
  443996
  469283
  390794
  400489
  400513
  407903
  413182
  428867
  443712
  454257
  443174
  443194
  443725
  466129
  475881
  511598
  492048
  506028
  523902
  626024
  486110
  546944
  560400
  573729
  546958
  601938
  443809
  460745
  470019
  474777
  476275
  481923
  411905
  421849
  465902
  476271
  429574
  433359
  450641
  465373
  470166
  470275
  389519
  411468
  422188
  460725
  463177
  465352
  466223
  422338
  443726
  443797
  466942
  523907
  526735
  508721
  491988
  490946
  439715
  391668
  439699
  474800
  439457
  440964
  421900
  443153
  465367
  466262
  490894
  484630
  421839
  482629
  598550
  813573
  476263
  539512
  518160
  549844
  563125
  563233
  569931
  569943
  563196
  578343
  547930
  563232
  696308
  699625
  546878
  547722
  557991
  563143
  581614
  621402
  781718
  807326
  726981
  788767
  392576
  443759
  460728
  462694
  466893
  470199
  400359
  413090
  428137
]
2.62 ms
(1.67%)
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
  383643
  389519
  390794
  391380
  391668
  392576
  400359
  400489
  400513
  407903
  409083
  411468
  411905
  413090
  413182
  421839
  421849
  421900
  422188
  422338
  426682
  426940
  428137
  428821
  428867
  429574
  433359
  439457
  439608
  439699
  439715
  440964
  443153
  443174
  443194
  443712
  443725
  443726
  443759
  443797
  443809
  443996
  450641
  454230
  454257
  460725
  460728
  460745
  462694
  463177
  465352
  465367
  465373
  465902
  466129
  466223
  466262
  466893
  466942
  467545
  469283
  470019
  470166
  470199
  470275
  474777
  474800
  475881
  476263
  476271
  476275
  476353
  477989
  481923
  482629
  484630
  486110
  490894
  490946
  491988
  492048
  506028
  508721
  511598
  518160
  523902
  523907
  526735
  539512
  546878
  546944
  546958
  547722
  547930
  549844
  557991
  560400
  563125
  563143
  563196
  563232
  563233
  569931
  569943
  573729
  578343
  581614
  598550
  601938
  621402
  626024
  696308
  699625
  726981
  781718
  784306
  784569
  788767
  807326
  813573
]
1.84 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old mom rus"
]
1.84 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old mom русск"
]
1.30 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old 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.