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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.88 ms
(83.91%)
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
  188462
  400199
  402848
  418589
  420638
  423912
  425037
  427166
  434576
  434693
  437929
  439504
  440876
  441623
  448864
  449061
  450334
  450441
  451672
  454801
  459151
  463840
  469554
  469823
  478285
  478963
  478970
  479816
  481871
  482780
  483814
  485129
  485648
  487730
  488483
  488939
  492703
  492714
  499697
  500304
  502064
  502324
  505418
  508187
  509833
  510898
  516015
  516038
  518643
  519872
  521452
  525669
  528384
  531377
  536613
  544066
  545440
  550531
  558200
  559295
  559810
  568189
  573206
  576256
  578829
  584434
  593812
  593994
  594861
  596929
  601655
  601724
  602259
  603954
  604058
  605673
  616382
  617395
  619574
  627137
  629819
  646669
  647315
  649921
  653455
  663815
  669919
  673901
  687630
  688698
  693944
  705099
  709316
  709374
  713565
  714088
  714183
  715818
  726131
  730216
  734614
  736358
  752710
  756975
  764814
  769482
  772971
  775683
  776096
  779840
  780603
  784750
  792652
  796702
  797055
  801722
  801788
  803047
  807004
  815441
]
14.62 ms
(9.74%)
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
  400199
  485129
  584434
  649921
  780603
  730216
  188462
  521452
  752710
  714183
  437929
  402848
  488483
  478285
  605673
  423912
  483814
  536613
  627137
  573206
  593994
  502064
  518643
  485648
  519872
  434693
  478963
  478970
  784750
  439504
  469823
  451672
  492703
  705099
  713565
  568189
  647315
  594861
  792652
  450334
  487730
  646669
  448864
  482780
  505418
  601724
  425037
  492714
  544066
  454801
  508187
  617395
  775683
  602259
  441623
  459151
  578829
  449061
  693944
  616382
  469554
  463840
  509833
  559295
  629819
  593812
  653455
  596929
  669919
  440876
  479816
  558200
  427166
  525669
  604058
  779840
  510898
  450441
  528384
  516015
  420638
  601655
  502324
  576256
  603954
  550531
  516038
  709316
  673901
  687630
  663815
  715818
  772971
  688698
  764814
  714088
  434576
  796702
  756975
  619574
  418589
  531377
  803047
  734614
  769482
  801788
  726131
  499697
  545440
  797055
  801722
  500304
  776096
  815441
  488939
  709374
  736358
  481871
  559810
  807004
]
2.94 ms
(1.96%)
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
  188462
  400199
  402848
  418589
  420638
  423912
  425037
  427166
  434576
  434693
  437929
  439504
  440876
  441623
  448864
  449061
  450334
  450441
  451672
  454801
  459151
  463840
  469554
  469823
  478285
  478963
  478970
  479816
  481871
  482780
  483814
  485129
  485648
  487730
  488483
  488939
  492703
  492714
  499697
  500304
  502064
  502324
  505418
  508187
  509833
  510898
  516015
  516038
  518643
  519872
  521452
  525669
  528384
  531377
  536613
  544066
  545440
  550531
  558200
  559295
  559810
  568189
  573206
  576256
  578829
  584434
  593812
  593994
  594861
  596929
  601655
  601724
  602259
  603954
  604058
  605673
  616382
  617395
  619574
  627137
  629819
  646669
  647315
  649921
  653455
  663815
  669919
  673901
  687630
  688698
  693944
  705099
  709316
  709374
  713565
  714088
  714183
  715818
  726131
  730216
  734614
  736358
  752710
  756975
  764814
  769482
  772971
  775683
  776096
  779840
  780603
  784750
  792652
  796702
  797055
  801722
  801788
  803047
  807004
  815441
]
1.96 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big squirt"
]
1.64 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сквирт оргазм"
]
1.54 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сквирт оргазм"
]

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.