GET https://search.jues.net/search/embeds/4?q=sex%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.67 ms
(80.65%)
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
  70246
  76172
  381740
  400624
  414369
  428382
  428587
  444937
  446958
  451166
  451303
  455245
  458464
  461991
  463773
  464210
  464619
  466288
  466562
  479798
  484051
  489542
  494118
  497829
  498456
  502187
  502313
  503046
  503215
  505690
  507010
  509265
  511181
  512717
  513574
  517564
  517595
  517768
  518596
  520501
  522209
  522792
  522806
  523855
  524141
  524587
  525717
  526104
  526767
  528149
  528710
  529271
  530457
  531594
  532082
  537945
  540189
  548415
  548732
  549985
  550276
  551172
  555141
  556777
  560646
  565741
  572242
  572373
  574546
  575535
  577059
  578419
  578845
  582712
  584480
  587852
  598921
  599541
  603783
  604034
  604093
  617360
  621265
  623014
  628639
  649904
  671371
  683978
  691897
  711960
  713733
  714504
  724656
  747027
  749269
  751620
  752926
  758206
  759145
  765185
  765346
  766387
  779312
  786414
  787103
  791738
  794455
  794785
  794806
  794815
  794831
  802891
  803914
  804104
  805561
  810789
  812028
  817039
  818644
]
19.11 ms
(12.36%)
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
  461991
  503215
  509265
  522209
  458464
  466562
  617360
  548732
  587852
  578845
  428382
  525717
  505690
  713733
  572373
  604093
  444937
  522792
  498456
  400624
  520501
  603783
  572242
  584480
  507010
  497829
  531594
  528149
  414369
  671371
  446958
  528710
  555141
  479798
  551172
  804104
  489542
  513574
  523855
  464210
  503046
  582712
  575535
  428587
  517595
  484051
  524760
  463773
  466288
  791738
  502187
  530457
  512717
  511181
  598921
  537945
  524587
  494118
  517564
  599541
  451303
  517768
  529271
  455245
  464619
  524141
  522806
  574546
  560646
  621265
  526104
  751620
  532082
  758206
  70246
  752926
  76172
  711960
  794831
  578419
  794806
  818644
  540189
  747027
  805561
  803914
  623014
  794455
  526767
  550276
  794815
  381740
  518596
  556777
  649904
  802891
  765346
  810789
  548415
  577059
  724656
  749269
  794785
  766387
  691897
  765185
  628639
  683978
  604034
  787103
  812028
  714504
  817039
  565741
  759145
  786414
  549985
  779312
  502313
  451166
]
2.78 ms
(1.80%)
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
  70246
  76172
  381740
  400624
  414369
  428382
  428587
  444937
  446958
  451166
  451303
  455245
  458464
  461991
  463773
  464210
  464619
  466288
  466562
  479798
  484051
  489542
  494118
  497829
  498456
  502187
  502313
  503046
  503215
  505690
  507010
  509265
  511181
  512717
  513574
  517564
  517595
  517768
  518596
  520501
  522209
  522792
  522806
  523855
  524141
  524587
  525717
  526104
  526767
  528149
  528710
  529271
  530457
  531594
  532082
  537945
  540189
  548415
  548732
  549985
  550276
  551172
  555141
  556777
  560646
  565741
  572242
  572373
  574546
  575535
  577059
  578419
  578845
  582712
  584480
  587852
  598921
  599541
  603783
  604034
  604093
  617360
  621265
  623014
  628639
  649904
  671371
  683978
  691897
  711960
  713733
  714504
  724656
  747027
  749269
  751620
  752926
  758206
  759145
  765185
  765346
  766387
  779312
  786414
  787103
  791738
  794455
  794785
  794806
  794815
  794831
  802891
  803914
  804104
  805561
  810789
  812028
  817039
  818644
]
2.24 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс hot"
]
1.96 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex hot"
]
1.96 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс hot"
]

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.