GET https://search.jues.net/search/embeds/5?q=dildo%20pantyhose

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.97 ms
(81.58%)
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
  400990
  422621
  423521
  434338
  434358
  444051
  445431
  448398
  450289
  450357
  450992
  452230
  459795
  462138
  470120
  476771
  483313
  491913
  510271
  513965
  516035
  521535
  527531
  527534
  529022
  530491
  533556
  541618
  542002
  542397
  545608
  546957
  550761
  555062
  560925
  563635
  566395
  572774
  582005
  584832
  585783
  591566
  594852
  595161
  596919
  597878
  601194
  606633
  613530
  616296
  620047
  620248
  622385
  622652
  632697
  634683
  636666
  639252
  647322
  647340
  648220
  662055
  662061
  663151
  666988
  667756
  672825
  673923
  683449
  711982
  716900
  717620
  722373
  729366
  730338
  738481
  738485
  743916
  748690
  750608
  751006
  752359
  755022
  766511
  772709
  772729
  776041
  776776
  777921
  781825
  782825
  783235
  784731
  784792
  786662
  787438
  790055
  791025
  791488
  795979
  796364
  796808
  798429
  801148
  804319
  804651
  806057
  806919
  809005
  809617
  810076
  810606
  811095
  811234
  812372
  813215
  814037
  814503
  815270
  819534
]
17.57 ms
(11.20%)
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
  672825
  662061
  585783
  595161
  620047
  784792
  786662
  795979
  809005
  776041
  798429
  772729
  791488
  810076
  729366
  766511
  738481
  776776
  791025
  811234
  452230
  560925
  530491
  533556
  647322
  632697
  810606
  470120
  510271
  527531
  546957
  662055
  555062
  563635
  584832
  591566
  622385
  597878
  613530
  423521
  434338
  450289
  422621
  444051
  814503
  819534
  476771
  462138
  541618
  666988
  663151
  596919
  620248
  636666
  782825
  781825
  772709
  813215
  743916
  752359
  634683
  777921
  796808
  516035
  513965
  550761
  450357
  545608
  648220
  647340
  722373
  716900
  521535
  815270
  814037
  445431
  542002
  566395
  542397
  582005
  717620
  667756
  711982
  673923
  683449
  622652
  606633
  639252
  594852
  616296
  601194
  801148
  804319
  804651
  806057
  806919
  783235
  787438
  796364
  809617
  811095
  812372
  748690
  784731
  790055
  730338
  750608
  751006
  755022
  738485
  400990
  459795
  434358
  448398
  450992
  483313
  529022
  527534
  491913
  572774
]
4.10 ms
(2.62%)
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
  400990
  422621
  423521
  434338
  434358
  444051
  445431
  448398
  450289
  450357
  450992
  452230
  459795
  462138
  470120
  476771
  483313
  491913
  510271
  513965
  516035
  521535
  527531
  527534
  529022
  530491
  533556
  541618
  542002
  542397
  545608
  546957
  550761
  555062
  560925
  563635
  566395
  572774
  582005
  584832
  585783
  591566
  594852
  595161
  596919
  597878
  601194
  606633
  613530
  616296
  620047
  620248
  622385
  622652
  632697
  634683
  636666
  639252
  647322
  647340
  648220
  662055
  662061
  663151
  666988
  667756
  672825
  673923
  683449
  711982
  716900
  717620
  722373
  729366
  730338
  738481
  738485
  743916
  748690
  750608
  751006
  752359
  755022
  766511
  772709
  772729
  776041
  776776
  777921
  781825
  782825
  783235
  784731
  784792
  786662
  787438
  790055
  791025
  791488
  795979
  796364
  796808
  798429
  801148
  804319
  804651
  806057
  806919
  809005
  809617
  810076
  810606
  811095
  811234
  812372
  813215
  814037
  814503
  815270
  819534
]
2.12 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo pantyhose"
]
1.87 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд pantyhose"
]
1.80 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд 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.