GET https://search.jues.net/search/embeds/4?q=webcam%20finger

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.42 ms
(84.13%)
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
  383599
  397655
  399598
  405699
  418146
  419666
  423324
  426995
  429106
  429706
  433581
  435788
  435816
  439257
  440637
  441210
  448577
  448906
  449484
  449546
  449963
  452757
  452914
  458212
  460070
  465439
  467982
  469080
  478029
  478991
  482900
  493789
  495636
  496890
  497719
  503482
  509760
  510766
  513176
  514769
  516373
  517763
  518807
  521625
  522082
  523606
  524122
  524953
  525466
  526095
  527271
  528374
  530420
  531559
  533922
  536064
  540752
  542509
  546720
  547546
  547881
  547945
  553229
  553601
  554083
  554204
  555384
  555418
  555432
  556449
  557582
  558098
  560738
  560789
  562203
  562449
  568864
  569627
  574446
  575610
  577482
  579159
  580001
  581092
  582829
  584284
  586170
  586285
  586757
  590807
  591406
  598917
  600467
  600473
  600491
  601138
  601798
  604356
  609146
  611192
  617146
  625762
  629208
  639133
  642895
  650075
  650518
  652052
  659361
  660821
  662518
  669303
  678950
  686133
  686972
  714289
  757421
  772441
  782070
  782094
]
16.24 ms
(9.52%)
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
  652052
  660821
  686133
  669303
  686972
  557582
  562203
  577482
  600467
  590807
  600473
  609146
  642895
  601138
  617146
  586757
  604356
  625762
  772441
  757421
  611192
  782070
  782094
  399598
  429706
  433581
  426995
  435816
  439257
  429106
  448577
  448906
  513176
  514769
  523606
  525466
  496890
  517763
  383599
  452757
  449484
  478991
  530420
  546720
  518807
  482900
  397655
  405699
  423324
  440637
  441210
  418146
  435788
  419666
  449546
  449963
  452914
  467982
  469080
  458212
  460070
  478029
  516373
  522082
  531559
  540752
  509760
  510766
  521625
  524953
  526095
  527271
  528374
  533922
  536064
  495636
  497719
  524122
  503482
  465439
  493789
  547546
  547881
  553229
  555384
  560738
  569627
  575610
  542509
  547945
  555418
  555432
  556449
  558098
  560789
  579159
  554083
  554204
  562449
  568864
  580001
  581092
  582829
  584284
  659361
  662518
  650075
  650518
  678950
  714289
  553601
  574446
  586285
  591406
  629208
  639133
  586170
  598917
  600491
  601798
]
2.98 ms
(1.75%)
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
  383599
  397655
  399598
  405699
  418146
  419666
  423324
  426995
  429106
  429706
  433581
  435788
  435816
  439257
  440637
  441210
  448577
  448906
  449484
  449546
  449963
  452757
  452914
  458212
  460070
  465439
  467982
  469080
  478029
  478991
  482900
  493789
  495636
  496890
  497719
  503482
  509760
  510766
  513176
  514769
  516373
  517763
  518807
  521625
  522082
  523606
  524122
  524953
  525466
  526095
  527271
  528374
  530420
  531559
  533922
  536064
  540752
  542509
  546720
  547546
  547881
  547945
  553229
  553601
  554083
  554204
  555384
  555418
  555432
  556449
  557582
  558098
  560738
  560789
  562203
  562449
  568864
  569627
  574446
  575610
  577482
  579159
  580001
  581092
  582829
  584284
  586170
  586285
  586757
  590807
  591406
  598917
  600467
  600473
  600491
  601138
  601798
  604356
  609146
  611192
  617146
  625762
  629208
  639133
  642895
  650075
  650518
  652052
  659361
  660821
  662518
  669303
  678950
  686133
  686972
  714289
  757421
  772441
  782070
  782094
]
2.14 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam finger"
]
2.09 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер палец"
]
1.75 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.