GET https://search.jues.net/search/embeds/3?q=big%20dick%20surprise

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.21 ms
(82.86%)
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
  130054
  404724
  416255
  422055
  423709
  428166
  429713
  443862
  448689
  451509
  452676
  453006
  453732
  456208
  459177
  459353
  460437
  463948
  465256
  466034
  472449
  474743
  475471
  480567
  482305
  484755
  487131
  491654
  491659
  497058
  497184
  497408
  497729
  505917
  505961
  508558
  508848
  509085
  513278
  514384
  517599
  518504
  520490
  521320
  523679
  524962
  526649
  534217
  542648
  546140
  548652
  554366
  560479
  566220
  568422
  571066
  571149
  576028
  576372
  576840
  577641
  579825
  579828
  579867
  582615
  583446
  585910
  587679
  588023
  590461
  593620
  593622
  593750
  593775
  595772
  595967
  601369
  601401
  603464
  604679
  606599
  607780
  613017
  613238
  617161
  627307
  632734
  639247
  648219
  668451
  668529
  672342
  672367
  673415
  673797
  675296
  682226
  698082
  699577
  715520
  718438
  718894
  730350
  740392
  742046
  742839
  744863
  747654
  748979
  750668
  751704
  760955
  761320
  761580
  770929
  786153
  786462
  812782
  818630
  820881
]
15.41 ms
(10.99%)
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
  508848
  459353
  463948
  451509
  460437
  475471
  472449
  497058
  554366
  466034
  453006
  443862
  482305
  491654
  513278
  509085
  514384
  487131
  505961
  520490
  571066
  672367
  668451
  593620
  585910
  587679
  593750
  484755
  542648
  517599
  818630
  718438
  682226
  588023
  595967
  603464
  607780
  593775
  613238
  770929
  786462
  742046
  748979
  761320
  761580
  747654
  751704
  604679
  130054
  673797
  579825
  632734
  524962
  606599
  523679
  546140
  497729
  740392
  718894
  672342
  404724
  428166
  448689
  452676
  505917
  534217
  576372
  648219
  474743
  518504
  715520
  453732
  820881
  568422
  576840
  579828
  583446
  560479
  571149
  582615
  548652
  576028
  675296
  698082
  673415
  668529
  566220
  601401
  601369
  613017
  590461
  595772
  627307
  786153
  742839
  760955
  812782
  744863
  730350
  750668
  639247
  526649
  699577
  579867
  593622
  617161
  422055
  459177
  497408
  480567
  577641
  429713
  423709
  456208
  491659
  497184
  521320
  508558
  416255
  465256
]
2.34 ms
(1.67%)
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
  130054
  404724
  416255
  422055
  423709
  428166
  429713
  443862
  448689
  451509
  452676
  453006
  453732
  456208
  459177
  459353
  460437
  463948
  465256
  466034
  472449
  474743
  475471
  480567
  482305
  484755
  487131
  491654
  491659
  497058
  497184
  497408
  497729
  505917
  505961
  508558
  508848
  509085
  513278
  514384
  517599
  518504
  520490
  521320
  523679
  524962
  526649
  534217
  542648
  546140
  548652
  554366
  560479
  566220
  568422
  571066
  571149
  576028
  576372
  576840
  577641
  579825
  579828
  579867
  582615
  583446
  585910
  587679
  588023
  590461
  593620
  593622
  593750
  593775
  595772
  595967
  601369
  601401
  603464
  604679
  606599
  607780
  613017
  613238
  617161
  627307
  632734
  639247
  648219
  668451
  668529
  672342
  672367
  673415
  673797
  675296
  682226
  698082
  699577
  715520
  718438
  718894
  730350
  740392
  742046
  742839
  744863
  747654
  748979
  750668
  751704
  760955
  761320
  761580
  770929
  786153
  786462
  812782
  818630
  820881
]
1.91 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big dick surprise"
]
1.61 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член surprise"
]
1.25 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член surprise"
]

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.