GET https://search.jues.net/search/embeds/10?q=extreme%20skinny

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.85 ms
(85.39%)
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
  387544
  395474
  396275
  396360
  396560
  397946
  398440
  399058
  399853
  400932
  400940
  401655
  404369
  404800
  408332
  410690
  413960
  414666
  415303
  415966
  416512
  416525
  416580
  416670
  416688
  419571
  421517
  428241
  430350
  432970
  444743
  446330
  449011
  450557
  450969
  452646
  456628
  458921
  467196
  470458
  472445
  473094
  478775
  479842
  481148
  482814
  484433
  492839
  494347
  494493
  495066
  495126
  497406
  497439
  497474
  497688
  500721
  501598
  501645
  504144
  505103
  506769
  510550
  517819
  518935
  519819
  520627
  520853
  521454
  521737
  522866
  523357
  524676
  525680
  526188
  528922
  529152
  530624
  531134
  531242
  532261
  533931
  534032
  536542
  536641
  536712
  537915
  538448
  549091
  554423
  565243
  565247
  567395
  578156
  580190
  586587
  597823
  599440
  600200
  600218
  606275
  628379
  628388
  628909
  628916
  637023
  647969
  668688
  674968
  677307
  680190
  695885
  698210
  702629
  720333
  725111
  748893
  761123
  764058
  790373
]
17.34 ms
(9.50%)
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
  748893
  536712
  680190
  404369
  415966
  421517
  432970
  416512
  484433
  530624
  531242
  526188
  501598
  504144
  565243
  647969
  668688
  565247
  580190
  600200
  606275
  637023
  628379
  628388
  599440
  470458
  400940
  478775
  510550
  520853
  520627
  674968
  677307
  586587
  600218
  698210
  720333
  764058
  529152
  532261
  538448
  554423
  567395
  578156
  549091
  695885
  597823
  628909
  628916
  790373
  725111
  761123
  702629
  395474
  387544
  396275
  396360
  396560
  397946
  398440
  400932
  399058
  399853
  401655
  404800
  413960
  416688
  430350
  408332
  414666
  415303
  416580
  416670
  416525
  428241
  444743
  410690
  419571
  452646
  467196
  472445
  481148
  482814
  446330
  492839
  449011
  450557
  450969
  456628
  458921
  473094
  479842
  494493
  495066
  495126
  497474
  497688
  501645
  505103
  517819
  518935
  524676
  534032
  536542
  536641
  537915
  497406
  497439
  521454
  522866
  523357
  531134
  533931
  494347
  500721
  506769
  519819
  521737
  525680
  528922
]
2.78 ms
(1.52%)
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
  387544
  395474
  396275
  396360
  396560
  397946
  398440
  399058
  399853
  400932
  400940
  401655
  404369
  404800
  408332
  410690
  413960
  414666
  415303
  415966
  416512
  416525
  416580
  416670
  416688
  419571
  421517
  428241
  430350
  432970
  444743
  446330
  449011
  450557
  450969
  452646
  456628
  458921
  467196
  470458
  472445
  473094
  478775
  479842
  481148
  482814
  484433
  492839
  494347
  494493
  495066
  495126
  497406
  497439
  497474
  497688
  500721
  501598
  501645
  504144
  505103
  506769
  510550
  517819
  518935
  519819
  520627
  520853
  521454
  521737
  522866
  523357
  524676
  525680
  526188
  528922
  529152
  530624
  531134
  531242
  532261
  533931
  534032
  536542
  536641
  536712
  537915
  538448
  549091
  554423
  565243
  565247
  567395
  578156
  580190
  586587
  597823
  599440
  600200
  600218
  606275
  628379
  628388
  628909
  628916
  637023
  647969
  668688
  674968
  677307
  680190
  695885
  698210
  702629
  720333
  725111
  748893
  761123
  764058
  790373
]
1.97 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme skinny"
]
1.58 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор худые"
]
1.45 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.