GET https://search.jues.net/search/embeds/9?q=sex%20oil

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.77 ms
(83.00%)
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
  91248
  205251
  383595
  385010
  385688
  389026
  389135
  389487
  392535
  393509
  395625
  397935
  402604
  404032
  406445
  410688
  413816
  414427
  414849
  415863
  418545
  424697
  426820
  427007
  429226
  429231
  430573
  440645
  443525
  443531
  444422
  444476
  445205
  445922
  451961
  452360
  453439
  454367
  454404
  454573
  454942
  456257
  456410
  457501
  459148
  459363
  463920
  464172
  465707
  466476
  468279
  469577
  469743
  473183
  473468
  473836
  475431
  475485
  477088
  478492
  478887
  479436
  479800
  480260
  487712
  491058
  498668
  498698
  500428
  501535
  501760
  510001
  510890
  511550
  516950
  519555
  520138
  525251
  526505
  527063
  531477
  538343
  538358
  538363
  545461
  545809
  551321
  551422
  559958
  561346
  563796
  564631
  566541
  569820
  574890
  575801
  591705
  600502
  623543
  644453
  644585
  661078
  669110
  743038
  744709
  758493
  768391
  773215
  777057
  813756
  817468
  818254
  818394
  818783
  818784
  821429
  822268
  825964
  828420
]
16.26 ms
(10.48%)
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
  466476
  426820
  429226
  443531
  480260
  445205
  479436
  501535
  498668
  525251
  526505
  538358
  385688
  393509
  395625
  91248
  389135
  410688
  414849
  413816
  414427
  415863
  453439
  459148
  478887
  445922
  451961
  454367
  457501
  459363
  500428
  469743
  574890
  551422
  600502
  777057
  463920
  444476
  389026
  427007
  519555
  545461
  383595
  205251
  389487
  443525
  454573
  475485
  452360
  456410
  473183
  473836
  498698
  531477
  465707
  469577
  551321
  563796
  569820
  575801
  559958
  429231
  454404
  464172
  479800
  404032
  478492
  424697
  473468
  527063
  487712
  516950
  501760
  392535
  813756
  825964
  561346
  520138
  818783
  821429
  818254
  818394
  818784
  828420
  669110
  661078
  591705
  744709
  743038
  623543
  402604
  406445
  817468
  822268
  758493
  773215
  771167
  385010
  397935
  430573
  444422
  468279
  475431
  454942
  511550
  566541
  545809
  564631
  644585
  644453
  440645
  456257
  477088
  538343
  491058
  538363
  510001
  510890
  418545
  768391
]
3.09 ms
(1.99%)
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
  91248
  205251
  383595
  385010
  385688
  389026
  389135
  389487
  392535
  393509
  395625
  397935
  402604
  404032
  406445
  410688
  413816
  414427
  414849
  415863
  418545
  424697
  426820
  427007
  429226
  429231
  430573
  440645
  443525
  443531
  444422
  444476
  445205
  445922
  451961
  452360
  453439
  454367
  454404
  454573
  454942
  456257
  456410
  457501
  459148
  459363
  463920
  464172
  465707
  466476
  468279
  469577
  469743
  473183
  473468
  473836
  475431
  475485
  477088
  478492
  478887
  479436
  479800
  480260
  487712
  491058
  498668
  498698
  500428
  501535
  501760
  510001
  510890
  511550
  516950
  519555
  520138
  525251
  526505
  527063
  531477
  538343
  538358
  538363
  545461
  545809
  551321
  551422
  559958
  561346
  563796
  564631
  566541
  569820
  574890
  575801
  591705
  600502
  623543
  644453
  644585
  661078
  669110
  743038
  744709
  758493
  768391
  773215
  777057
  813756
  817468
  818254
  818394
  818783
  818784
  821429
  822268
  825964
  828420
]
2.00 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex oil"
]
1.61 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс масл"
]
1.55 ms
(1.00%)
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.