GET https://search.jues.net/search/embeds/6?q=pantyhose%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.23 ms
(58.17%)
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
  20180
  233018
  389117
  391472
  391583
  398969
  398970
  399829
  400847
  400851
  400998
  401008
  401470
  401749
  401807
  402897
  405501
  406711
  411333
  411336
  411361
  411421
  411912
  418883
  419095
  419655
  420087
  422523
  422546
  422671
  423015
  424427
  425957
  426665
  428138
  428890
  430287
  433322
  434286
  434325
  439593
  439608
  441209
  443422
  443720
  448532
  454208
  458311
  460179
  461620
  464753
  465348
  466136
  466168
  466310
  466350
  467404
  467461
  467489
  467502
  467514
  467519
  470148
  470199
  470288
  470954
  470956
  476256
  477975
  479034
  481124
  481929
  484429
  485346
  490879
  490884
  490917
  491144
  491704
  491993
  497422
  509918
  511598
  523205
  532338
  537916
  539462
  544489
  546713
  549764
  550744
  554105
  559552
  563141
  565372
  566075
  566076
  569245
  589619
  590330
  601337
  608505
  608550
  610600
  619520
  622387
  623203
  633718
  636593
  637427
  651669
  667895
  688586
  697892
  698102
  721014
  744355
  789968
  811037
  814857
]
128.75 ms
(35.13%)
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
  20180
  233018
  389117
  391472
  391583
  398969
  398970
  399829
  400847
  400851
  400998
  401008
  401470
  401749
  401807
  402897
  405501
  406711
  411333
  411336
  411361
  411421
  411912
  418883
  419095
  419655
  420087
  422523
  422546
  422671
  423015
  424427
  425957
  426665
  428138
  428890
  430287
  433322
  434286
  434325
  439593
  439608
  441209
  443422
  443720
  448532
  454208
  458311
  460179
  461620
  464753
  465348
  466136
  466168
  466310
  466350
  467404
  467461
  467489
  467502
  467514
  467519
  470148
  470199
  470288
  470954
  470956
  476256
  477975
  479034
  481124
  481929
  484429
  485346
  490879
  490884
  490917
  491144
  491704
  491993
  497422
  509918
  511598
  523205
  532338
  537916
  539462
  544489
  546713
  549764
  550744
  554105
  559552
  563141
  565372
  566075
  566076
  569245
  589619
  590330
  601337
  608505
  608550
  610600
  619520
  622387
  623203
  633718
  636593
  637427
  651669
  667895
  688586
  697892
  698102
  721014
  744355
  789968
  811037
  814857
]
18.17 ms
(4.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
  697892
  667895
  549764
  563141
  569245
  601337
  622387
  590330
  608505
  608550
  789968
  619520
  811037
  233018
  400851
  401470
  411333
  419655
  420087
  479034
  411336
  426665
  434325
  441209
  443720
  467519
  391472
  391583
  433322
  439608
  466350
  470148
  476256
  20180
  389117
  402897
  406711
  422523
  425957
  428138
  443422
  448532
  464753
  481929
  411361
  419095
  466136
  466168
  509918
  484429
  490884
  491704
  491993
  511598
  490879
  485346
  490917
  491144
  430287
  497422
  537916
  523205
  470288
  550744
  688586
  633718
  637427
  623203
  466310
  400847
  401807
  405501
  422671
  422546
  423015
  814857
  461620
  454208
  470954
  532338
  539462
  546713
  566075
  544489
  554105
  559552
  566076
  651669
  721014
  565372
  636593
  589619
  744355
  610600
  698102
  428890
  470199
  470956
  477975
  481124
  398970
  400998
  401008
  401749
  439593
  458311
  460179
  465348
  467489
  398969
  399829
  411421
  411912
  418883
  424427
  434286
  467404
  467461
  467502
  467514
]
1.92 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pantyhose young"
]
1.54 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pantyhose young"
]
1.52 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pantyhose young"
]

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.