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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
235.48 ms
(64.18%)
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
  419949
  445830
  485613
  525543
  528582
  386304
  443510
  459759
  516336
  405940
  418873
  425668
  443215
  421288
  451875
  476975
  532020
  503855
  515796
  675107
  407277
  468809
  471926
  416263
  427794
  518263
  507627
  405507
  478995
  521151
  521525
  523629
  560902
  667826
  411930
  500798
  494731
  428458
  510448
  383354
  448006
  445838
  723914
  438830
  506304
  424505
  478900
  540238
  508221
  518188
  461651
  675725
  382330
  416165
  475483
  590280
  488536
  421548
  498990
  544824
  542601
  404779
  404451
  420462
  454468
  520788
  675110
  447173
  419298
  499098
  518076
  521850
  464453
  441466
  445935
  476783
  510839
  788260
  514149
  519752
  411884
  538732
  396527
  520662
  559949
  519942
  540609
  434702
  470903
  583960
  445087
  463829
  542627
  499585
  814072
  430712
  828851
  584740
  602606
  701817
  699191
  185159
  542584
  712891
  521852
  780247
  675126
  509001
  513195
  688108
  515896
  542676
  465349
  482668
  493535
  599299
  428521
  468715
  815906
  530588
]
122.01 ms
(33.25%)
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
  185159
  382330
  383354
  386304
  396527
  404451
  404779
  405507
  405940
  407277
  411884
  411930
  416165
  416263
  418873
  419298
  419949
  420462
  421288
  421548
  424505
  425668
  427794
  428458
  428521
  430712
  434702
  438830
  441466
  443215
  443510
  445087
  445830
  445838
  445935
  447173
  448006
  451875
  454468
  459759
  461651
  463829
  464453
  465349
  468715
  468809
  470903
  471926
  475483
  476783
  476975
  478900
  478995
  482668
  485613
  488536
  493535
  494731
  498990
  499098
  499585
  500798
  503855
  506304
  507627
  508221
  509001
  510448
  510839
  513195
  514149
  515796
  515896
  516336
  518076
  518188
  518263
  519752
  519942
  520662
  520788
  521151
  521525
  521850
  521852
  523629
  525543
  528582
  530588
  532020
  538732
  540238
  540609
  542584
  542601
  542627
  542676
  544824
  559949
  560902
  583960
  584740
  590280
  599299
  602606
  667826
  675107
  675110
  675126
  675725
  688108
  699191
  701817
  712891
  723914
  780247
  788260
  814072
  815906
  828851
]
2.99 ms
(0.82%)
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
  185159
  382330
  383354
  386304
  396527
  404451
  404779
  405507
  405940
  407277
  411884
  411930
  416165
  416263
  418873
  419298
  419949
  420462
  421288
  421548
  424505
  425668
  427794
  428458
  428521
  430712
  434702
  438830
  441466
  443215
  443510
  445087
  445830
  445838
  445935
  447173
  448006
  451875
  454468
  459759
  461651
  463829
  464453
  465349
  468715
  468809
  470903
  471926
  475483
  476783
  476975
  478900
  478995
  482668
  485613
  488536
  493535
  494731
  498990
  499098
  499585
  500798
  503855
  506304
  507627
  508221
  509001
  510448
  510839
  513195
  514149
  515796
  515896
  516336
  518076
  518188
  518263
  519752
  519942
  520662
  520788
  521151
  521525
  521850
  521852
  523629
  525543
  528582
  530588
  532020
  538732
  540238
  540609
  542584
  542601
  542627
  542676
  544824
  559949
  560902
  583960
  584740
  590280
  599299
  602606
  667826
  675107
  675110
  675126
  675725
  688108
  699191
  701817
  712891
  723914
  780247
  788260
  814072
  815906
  828851
]
1.81 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс white"
]
1.74 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex white"
]
1.49 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:
[
  "секс white"
]

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.