GET https://search.jues.net/search/embeds/2?q=%D0%BF%D0%B0%D1%80%D0%BE%D1%87%D0%BA%D0%B0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.71 ms
(88.09%)
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
  191485
  382542
  383751
  384522
  388365
  388440
  389360
  392748
  393188
  394243
  395258
  395679
  395707
  398253
  398984
  400126
  401673
  402245
  406992
  408767
  409346
  416029
  419731
  425163
  427498
  428450
  428988
  428996
  433808
  435734
  436427
  440257
  442656
  443664
  449436
  456857
  458149
  458712
  460183
  460439
  460863
  461444
  461445
  461490
  462620
  464757
  466060
  467161
  467303
  468899
  470522
  470915
  475622
  476095
  477964
  482030
  484104
  486112
  486846
  487074
  490365
  491513
  500843
  501735
  501776
  504351
  504715
  506531
  506714
  507385
  507827
  507856
  509498
  511183
  511428
  511755
  512921
  513278
  514448
  516440
  517276
  520277
  521936
  522305
  522513
  522796
  525214
  526496
  527366
  528820
  538196
  541994
  542434
  544199
  544395
  551612
  551752
  553642
  554478
  556494
  557027
  559617
  560627
  560654
  565570
  568990
  571830
  571987
  575092
  576038
  576366
  576681
  579879
  583728
  588962
  589784
  596978
  598062
  652969
  690088
]
19.68 ms
(7.96%)
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
  462620
  467303
  393188
  409346
  461444
  466060
  467161
  468899
  395707
  398253
  408767
  449436
  458149
  461445
  482030
  428996
  442656
  476095
  501735
  486112
  486846
  514448
  516440
  522305
  526496
  506714
  507856
  520277
  522796
  484104
  491513
  507385
  538196
  384522
  191485
  394243
  395258
  382542
  388365
  398984
  400126
  433808
  443664
  458712
  456857
  470522
  507827
  509498
  500843
  490365
  560627
  544395
  553642
  554478
  575092
  576038
  576366
  583728
  652969
  690088
  565570
  571830
  579879
  598062
  589784
  588962
  596978
  383751
  388440
  428988
  436427
  440257
  461490
  477964
  389360
  401673
  460183
  460439
  464757
  470915
  419731
  425163
  435734
  460863
  475622
  487074
  504351
  513278
  521936
  527366
  528820
  504715
  506531
  511428
  522513
  525214
  501776
  511183
  511755
  512921
  517276
  392748
  395679
  402245
  416029
  427498
  406992
  428450
  544199
  557027
  568990
  571987
  541994
  559617
  560654
  542434
  551752
  576681
  551612
  556494
]
2.48 ms
(1.00%)
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
  191485
  382542
  383751
  384522
  388365
  388440
  389360
  392748
  393188
  394243
  395258
  395679
  395707
  398253
  398984
  400126
  401673
  402245
  406992
  408767
  409346
  416029
  419731
  425163
  427498
  428450
  428988
  428996
  433808
  435734
  436427
  440257
  442656
  443664
  449436
  456857
  458149
  458712
  460183
  460439
  460863
  461444
  461445
  461490
  462620
  464757
  466060
  467161
  467303
  468899
  470522
  470915
  475622
  476095
  477964
  482030
  484104
  486112
  486846
  487074
  490365
  491513
  500843
  501735
  501776
  504351
  504715
  506531
  506714
  507385
  507827
  507856
  509498
  511183
  511428
  511755
  512921
  513278
  514448
  516440
  517276
  520277
  521936
  522305
  522513
  522796
  525214
  526496
  527366
  528820
  538196
  541994
  542434
  544199
  544395
  551612
  551752
  553642
  554478
  556494
  557027
  559617
  560627
  560654
  565570
  568990
  571830
  571987
  575092
  576038
  576366
  576681
  579879
  583728
  588962
  589784
  596978
  598062
  652969
  690088
]
2.07 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "парочка"
]
1.91 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парочк"
]
1.80 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парочк"
]
1.51 ms
(0.61%)
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.