GET https://search.jues.net/search/embeds/5?q=in%20dress

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.24 ms
(86.07%)
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
  45985
  98871
  382363
  385832
  385953
  389806
  397432
  412571
  412578
  415823
  416437
  419281
  420021
  422296
  423773
  423956
  424042
  428732
  439484
  447869
  455364
  456052
  457593
  457870
  458514
  459949
  460558
  462422
  463593
  465700
  467924
  468372
  473445
  478897
  479462
  479891
  480111
  480541
  482441
  482467
  484008
  484701
  485492
  487443
  489347
  493937
  499748
  508327
  508801
  508802
  515627
  516100
  521024
  522178
  527644
  534824
  535408
  537313
  538274
  545237
  545261
  547781
  554174
  554901
  556788
  562736
  565645
  571374
  572228
  576503
  584888
  598985
  600389
  600467
  604969
  605011
  605030
  605033
  605215
  605244
  605281
  605284
  605285
  608202
  614842
  618069
  625282
  628527
  637503
  639637
  639670
  639674
  650721
  664226
  668677
  669023
  669026
  693423
  707812
  721060
  728101
  751262
  751676
  761141
  765810
  778828
  783154
  788816
  791858
  792736
  803374
  804847
  808574
  810635
  811071
  811961
  812743
  814404
  816629
  825672
]
15.92 ms
(8.77%)
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
  751262
  761141
  765810
  605011
  614842
  707812
  778828
  791858
  810635
  811961
  423956
  455364
  457593
  415823
  423773
  412578
  457870
  487443
  508327
  382363
  98871
  397432
  428732
  825672
  468372
  489347
  538274
  515627
  460558
  467924
  482441
  554174
  545261
  572228
  554901
  584888
  650721
  664226
  668677
  669026
  693423
  669023
  562736
  565645
  571374
  600467
  605281
  608202
  598985
  605284
  605285
  625282
  605215
  639674
  600389
  605244
  628527
  639637
  639670
  812743
  803374
  788816
  792736
  808574
  811071
  728101
  751676
  604969
  605030
  605033
  618069
  637503
  721060
  783154
  804847
  419281
  420021
  45985
  389806
  479891
  385832
  424042
  385953
  465700
  478897
  412571
  535408
  508801
  508802
  516100
  521024
  416437
  422296
  439484
  816629
  814404
  482467
  447869
  459949
  479462
  456052
  458514
  473445
  480541
  484008
  484701
  462422
  463593
  480111
  534824
  537313
  499748
  522178
  527644
  485492
  493937
  556788
  576503
  545237
  547781
]
2.54 ms
(1.40%)
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
  45985
  98871
  382363
  385832
  385953
  389806
  397432
  412571
  412578
  415823
  416437
  419281
  420021
  422296
  423773
  423956
  424042
  428732
  439484
  447869
  455364
  456052
  457593
  457870
  458514
  459949
  460558
  462422
  463593
  465700
  467924
  468372
  473445
  478897
  479462
  479891
  480111
  480541
  482441
  482467
  484008
  484701
  485492
  487443
  489347
  493937
  499748
  508327
  508801
  508802
  515627
  516100
  521024
  522178
  527644
  534824
  535408
  537313
  538274
  545237
  545261
  547781
  554174
  554901
  556788
  562736
  565645
  571374
  572228
  576503
  584888
  598985
  600389
  600467
  604969
  605011
  605030
  605033
  605215
  605244
  605281
  605284
  605285
  608202
  614842
  618069
  625282
  628527
  637503
  639637
  639670
  639674
  650721
  664226
  668677
  669023
  669026
  693423
  707812
  721060
  728101
  751262
  751676
  761141
  765810
  778828
  783154
  788816
  791858
  792736
  803374
  804847
  808574
  810635
  811071
  811961
  812743
  814404
  816629
  825672
]
2.10 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "in dress"
]
1.79 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dress"
]
1.63 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dress"
]

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.