GET https://search.jues.net/search/embeds/5?q=hot%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.28 ms
(79.99%)
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
  151564
  382986
  385751
  386583
  392508
  403258
  403755
  408790
  410775
  428966
  435888
  444650
  454098
  458776
  459713
  469161
  470700
  481927
  496423
  503405
  517677
  517817
  518309
  521952
  528150
  530175
  538472
  538750
  552358
  553263
  554094
  556930
  559468
  571546
  581117
  583964
  587108
  589927
  592751
  593697
  595777
  597125
  598360
  600362
  601550
  610989
  623279
  628339
  631521
  636913
  649339
  649601
  652954
  653541
  656228
  660842
  662038
  662974
  663777
  665263
  677327
  679354
  679363
  679370
  679391
  680573
  683303
  687361
  688937
  689758
  693496
  695988
  697562
  699483
  701020
  704019
  705182
  706761
  718127
  719787
  720087
  724734
  734459
  735709
  745912
  747219
  748952
  749513
  751181
  755237
  755341
  756382
  759160
  760821
  770084
  772837
  777155
  778099
  782457
  782487
  782874
  785650
  787405
  788726
  790413
  794179
  796631
  796800
  797018
  797327
  797792
  799973
  810948
  811405
  811663
  812419
  812912
  813428
  820499
  826883
]
26.20 ms
(13.85%)
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
  687361
  706761
  688937
  587108
  598360
  705182
  636913
  777155
  813428
  735709
  530175
  665263
  503405
  403258
  597125
  583964
  649601
  749513
  410775
  812419
  751181
  392508
  677327
  610989
  386583
  653541
  553263
  554094
  796631
  755237
  770084
  385751
  517677
  679391
  593697
  778099
  788726
  796800
  810948
  734459
  382986
  601550
  652954
  782874
  718127
  600362
  679370
  785650
  556930
  656228
  719787
  662038
  679363
  628339
  772837
  581117
  458776
  459713
  787405
  797327
  760821
  745912
  756382
  820499
  151564
  538750
  724734
  689758
  683303
  589927
  623279
  435888
  538472
  571546
  720087
  759160
  631521
  799973
  790413
  826883
  782487
  521952
  695988
  663777
  748952
  704019
  444650
  797018
  782457
  408790
  649339
  660842
  680573
  679354
  595777
  701020
  428966
  454098
  518309
  496423
  403755
  481927
  528150
  552358
  693496
  592751
  797792
  755341
  794179
  747219
  811663
  812912
  517817
  811405
  470700
  469161
  699483
  697562
  559468
  662974
]
3.55 ms
(1.87%)
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
  151564
  382986
  385751
  386583
  392508
  403258
  403755
  408790
  410775
  428966
  435888
  444650
  454098
  458776
  459713
  469161
  470700
  481927
  496423
  503405
  517677
  517817
  518309
  521952
  528150
  530175
  538472
  538750
  552358
  553263
  554094
  556930
  559468
  571546
  581117
  583964
  587108
  589927
  592751
  593697
  595777
  597125
  598360
  600362
  601550
  610989
  623279
  628339
  631521
  636913
  649339
  649601
  652954
  653541
  656228
  660842
  662038
  662974
  663777
  665263
  677327
  679354
  679363
  679370
  679391
  680573
  683303
  687361
  688937
  689758
  693496
  695988
  697562
  699483
  701020
  704019
  705182
  706761
  718127
  719787
  720087
  724734
  734459
  735709
  745912
  747219
  748952
  749513
  751181
  755237
  755341
  756382
  759160
  760821
  770084
  772837
  777155
  778099
  782457
  782487
  782874
  785650
  787405
  788726
  790413
  794179
  796631
  796800
  797018
  797327
  797792
  799973
  810948
  811405
  811663
  812419
  812912
  813428
  820499
  826883
]
2.57 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot girls"
]
1.95 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot девушк"
]
1.64 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot девушк"
]

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.