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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.87 ms
(82.55%)
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
  326158
  383742
  396527
  397707
  398132
  406083
  417672
  420106
  421007
  421696
  428458
  434842
  443199
  446086
  446252
  446289
  447738
  448868
  452163
  452604
  454367
  454465
  454505
  454668
  456380
  458062
  459315
  462153
  462910
  462914
  463101
  463415
  464184
  464207
  464891
  466027
  466033
  466139
  470087
  470147
  470312
  470796
  471472
  471713
  474161
  475328
  475485
  477614
  477775
  478402
  480383
  482511
  483762
  483903
  485745
  489128
  489860
  492012
  492052
  492079
  494805
  497047
  497666
  498218
  498228
  498424
  499207
  500151
  501893
  502112
  503285
  503444
  503861
  505335
  505538
  507110
  507535
  509849
  509852
  510267
  510856
  511574
  512916
  513018
  514449
  515373
  515596
  515634
  518412
  518802
  520949
  521022
  521613
  523953
  523962
  525067
  525178
  527979
  528024
  529099
  529722
  530146
  530713
  531531
  532511
  533228
  534006
  534279
  535835
  536286
  536611
  536652
  536674
  538514
  540428
  542486
  545707
  549847
  552494
  821532
]
19.90 ms
(11.66%)
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
  489860
  492052
  500151
  501893
  505335
  505538
  514449
  515596
  518412
  525067
  527979
  529099
  428458
  396527
  383742
  326158
  397707
  398132
  406083
  417672
  421007
  434842
  443199
  421696
  420106
  821532
  482511
  446252
  446289
  458062
  462153
  462910
  464207
  475485
  477614
  489128
  446086
  447738
  452163
  452604
  463101
  463415
  466033
  470147
  470312
  470796
  474161
  477775
  478402
  485745
  448868
  454367
  454465
  454505
  454668
  456380
  459315
  462914
  464891
  466027
  466139
  470087
  471472
  480383
  483903
  492079
  497047
  498424
  507110
  510267
  515373
  518802
  520949
  521022
  525178
  533228
  535835
  538514
  540428
  494805
  503444
  503861
  507535
  510856
  512916
  515634
  523953
  523962
  529722
  534279
  536286
  536611
  497666
  499207
  502112
  503285
  509849
  528024
  530713
  531531
  532511
  536652
  536674
  498218
  498228
  509852
  511574
  513018
  521613
  530146
  534006
  464184
  471713
  475328
  483762
  492012
  545707
  552494
  542486
  549847
]
3.33 ms
(1.95%)
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
  326158
  383742
  396527
  397707
  398132
  406083
  417672
  420106
  421007
  421696
  428458
  434842
  443199
  446086
  446252
  446289
  447738
  448868
  452163
  452604
  454367
  454465
  454505
  454668
  456380
  458062
  459315
  462153
  462910
  462914
  463101
  463415
  464184
  464207
  464891
  466027
  466033
  466139
  470087
  470147
  470312
  470796
  471472
  471713
  474161
  475328
  475485
  477614
  477775
  478402
  480383
  482511
  483762
  483903
  485745
  489128
  489860
  492012
  492052
  492079
  494805
  497047
  497666
  498218
  498228
  498424
  499207
  500151
  501893
  502112
  503285
  503444
  503861
  505335
  505538
  507110
  507535
  509849
  509852
  510267
  510856
  511574
  512916
  513018
  514449
  515373
  515596
  515634
  518412
  518802
  520949
  521022
  521613
  523953
  523962
  525067
  525178
  527979
  528024
  529099
  529722
  530146
  530713
  531531
  532511
  533228
  534006
  534279
  535835
  536286
  536611
  536652
  536674
  538514
  540428
  542486
  545707
  549847
  552494
  821532
]
1.93 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white pantyhose"
]
1.63 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white pantyhose"
]
1.38 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white pantyhose"
]

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.