GET https://search.jues.net/search/embeds/4?q=girlfriend%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.23 ms
(84.10%)
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
  282430
  382285
  382519
  386936
  387015
  388198
  389551
  406816
  423595
  423782
  424560
  428595
  428596
  433815
  434566
  437239
  443523
  443992
  445413
  445784
  447273
  447735
  449379
  450435
  453618
  453791
  457014
  457761
  459855
  461316
  463501
  467373
  468399
  473784
  475478
  476935
  478482
  479756
  495673
  504393
  505716
  509859
  509975
  510061
  510474
  511683
  511811
  524225
  525126
  536275
  543501
  552584
  554929
  560952
  561861
  562618
  564423
  564524
  569097
  576560
  583022
  591393
  591750
  594261
  595115
  595868
  602627
  602847
  610504
  610825
  611252
  618533
  618852
  619470
  620597
  623856
  624160
  624162
  630937
  632983
  636428
  646183
  653461
  653854
  655071
  660048
  662203
  664558
  666049
  669430
  669763
  670848
  671342
  672192
  674815
  690490
  691242
  695893
  712859
  713206
  717314
  720042
  722101
  724483
  727923
  728802
  737786
  744958
  746983
  753575
  760955
  766786
  776310
  777168
  788402
  796950
  800474
  801942
  803244
  806715
]
16.05 ms
(10.05%)
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
  583022
  560952
  561861
  564524
  660048
  671342
  672192
  674815
  720042
  653854
  655071
  669430
  690490
  722101
  662203
  691242
  712859
  576560
  602627
  632983
  610504
  611252
  591393
  618533
  623856
  806715
  776310
  796950
  737786
  760955
  766786
  728802
  744958
  746983
  753575
  630937
  713206
  777168
  788402
  803244
  382285
  382519
  389551
  406816
  453618
  468399
  386936
  433815
  387015
  461316
  423595
  443523
  478482
  524225
  504393
  505716
  509859
  509975
  569097
  443992
  434566
  428595
  428596
  447273
  449379
  450435
  453791
  457014
  475478
  459855
  495673
  510474
  511811
  536275
  510061
  525126
  511683
  463501
  543501
  552584
  562618
  554929
  564423
  646183
  664558
  669763
  695893
  653461
  666049
  670848
  602847
  610825
  619470
  624162
  636428
  594261
  618852
  624160
  591750
  595115
  595868
  800474
  801942
  724483
  727923
  620597
  717314
  445413
  447735
  457761
  423782
  445784
  476935
  479756
  282430
  437239
  467373
  473784
  388198
  424560
]
2.83 ms
(1.78%)
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
  282430
  382285
  382519
  386936
  387015
  388198
  389551
  406816
  423595
  423782
  424560
  428595
  428596
  433815
  434566
  437239
  443523
  443992
  445413
  445784
  447273
  447735
  449379
  450435
  453618
  453791
  457014
  457761
  459855
  461316
  463501
  467373
  468399
  473784
  475478
  476935
  478482
  479756
  495673
  504393
  505716
  509859
  509975
  510061
  510474
  511683
  511811
  524225
  525126
  536275
  543501
  552584
  554929
  560952
  561861
  562618
  564423
  564524
  569097
  576560
  583022
  591393
  591750
  594261
  595115
  595868
  602627
  602847
  610504
  610825
  611252
  618533
  618852
  619470
  620597
  623856
  624160
  624162
  630937
  632983
  636428
  646183
  653461
  653854
  655071
  660048
  662203
  664558
  666049
  669430
  669763
  670848
  671342
  672192
  674815
  690490
  691242
  695893
  712859
  713206
  717314
  720042
  722101
  724483
  727923
  728802
  737786
  744958
  746983
  753575
  760955
  766786
  776310
  777168
  788402
  796950
  800474
  801942
  803244
  806715
]
2.00 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girlfriend teen"
]
1.58 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "girlfriend teen"
]
1.57 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "girlfriend teen"
]

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.