GET https://search.jues.net/search/embeds/10?q=big%20white%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
257.66 ms
(51.03%)
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
  6643
  29272
  75896
  124062
  183343
  197690
  385123
  387324
  387817
  390835
  394152
  394772
  398771
  404432
  406659
  412018
  416131
  420062
  420240
  428513
  429205
  431794
  437335
  447834
  448662
  452218
  462484
  462970
  471898
  472225
  473959
  478854
  479771
  479995
  480037
  481282
  482485
  482950
  483470
  484148
  485713
  486188
  486222
  488086
  489122
  489429
  489933
  490152
  491891
  494552
  496661
  496859
  498199
  500468
  501679
  502036
  502894
  505899
  505909
  506886
  507517
  511887
  512102
  513721
  514818
  516413
  516641
  517699
  518780
  520243
  521749
  522490
  523007
  525413
  526209
  529288
  529878
  530453
  530538
  530599
  530730
  531185
  531345
  531377
  531973
  532238
  532292
  532692
  533396
  534700
  534781
  535544
  535948
  537594
  538158
  540192
  540829
  541177
  544289
  546293
  561887
  607500
  612245
  707739
  710372
  715904
  716170
  724202
  727298
  728655
  734002
  737448
  755108
  755799
  759805
  760127
  813473
  816419
  816880
  822177
]
215.63 ms
(42.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие white сиськ"
]
16.84 ms
(3.33%)
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
  428513
  710372
  546293
  540829
  516641
  530453
  535544
  531345
  532292
  511887
  531377
  502036
  734002
  755799
  759805
  437335
  516413
  489122
  385123
  406659
  404432
  429205
  822177
  471898
  488086
  447834
  481282
  485713
  490152
  480037
  482950
  484148
  489429
  491891
  496859
  521749
  523007
  525413
  530538
  531973
  532692
  538158
  494552
  496661
  498199
  513721
  517699
  526209
  530599
  532238
  533396
  534781
  500468
  529878
  531185
  535948
  501679
  506886
  530730
  478854
  482485
  486222
  489933
  561887
  716170
  607500
  737448
  813473
  755108
  760127
  728655
  707739
  448662
  29272
  416131
  420062
  505909
  486188
  124062
  183343
  75896
  387817
  390835
  420240
  816419
  816880
  534700
  540192
  472225
  544289
  727298
  715904
  6643
  387324
  412018
  394772
  507517
  431794
  462484
  483470
  452218
  473959
  505899
  514818
  529288
  520243
  522490
  537594
  541177
  394152
  479995
  462970
  479771
  512102
  518780
  502894
  724202
  197690
  612245
  398771
]
9.33 ms
(1.85%)
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
  6643
  29272
  75896
  124062
  183343
  197690
  385123
  387324
  387817
  390835
  394152
  394772
  398771
  404432
  406659
  412018
  416131
  420062
  420240
  428513
  429205
  431794
  437335
  447834
  448662
  452218
  462484
  462970
  471898
  472225
  473959
  478854
  479771
  479995
  480037
  481282
  482485
  482950
  483470
  484148
  485713
  486188
  486222
  488086
  489122
  489429
  489933
  490152
  491891
  494552
  496661
  496859
  498199
  500468
  501679
  502036
  502894
  505899
  505909
  506886
  507517
  511887
  512102
  513721
  514818
  516413
  516641
  517699
  518780
  520243
  521749
  522490
  523007
  525413
  526209
  529288
  529878
  530453
  530538
  530599
  530730
  531185
  531345
  531377
  531973
  532238
  532292
  532692
  533396
  534700
  534781
  535544
  535948
  537594
  538158
  540192
  540829
  541177
  544289
  546293
  561887
  607500
  612245
  707739
  710372
  715904
  716170
  724202
  727298
  728655
  734002
  737448
  755108
  755799
  759805
  760127
  813473
  816419
  816880
  822177
]
1.97 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big white tits"
]
1.87 ms
(0.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.33%)
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.