GET https://search.jues.net/search/embeds/6?q=skinny%20bitch

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.45 ms
(83.94%)
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
  381803
  383911
  391697
  395395
  395567
  396704
  396772
  397200
  398799
  401359
  403210
  406931
  407177
  415256
  418360
  418405
  423033
  424622
  428539
  428931
  429426
  437710
  437730
  438714
  439130
  443867
  445013
  445986
  447329
  447629
  448095
  448760
  449744
  450256
  454272
  454742
  462939
  464600
  466443
  467173
  469248
  469773
  470404
  470764
  474613
  475740
  476834
  477693
  478885
  479248
  479281
  479531
  483842
  484400
  485196
  487680
  487824
  490000
  491656
  492043
  493849
  494942
  495358
  495549
  496959
  497130
  498865
  499741
  500151
  501452
  501615
  502082
  504233
  505865
  506154
  506268
  508064
  509358
  510467
  510689
  511224
  511982
  513700
  514802
  516161
  518321
  519762
  521323
  523709
  523984
  525758
  543835
  546006
  546977
  550236
  551256
  551597
  551604
  551614
  558658
  560477
  562248
  566451
  567701
  570295
  571865
  575789
  579202
  581649
  584527
  587885
  588674
  590554
  602651
  605050
  637049
  651589
  659042
  770264
]
13.59 ms
(9.71%)
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
  397200
  401359
  443867
  450256
  462939
  469773
  478885
  391697
  395395
  396704
  406931
  418405
  429426
  437710
  449744
  464600
  470764
  479281
  504233
  508064
  509358
  511982
  490000
  494942
  506268
  521323
  485196
  487680
  497130
  510467
  523984
  484400
  491656
  492043
  499741
  519762
  523709
  476834
  403210
  447629
  551256
  651589
  495549
  469248
  479531
  502082
  505865
  501615
  566451
  551597
  551604
  560477
  570295
  575789
  584527
  546006
  571865
  579202
  587885
  605050
  590554
  602651
  418360
  438714
  437730
  454272
  447329
  479248
  477693
  511224
  518321
  483842
  506154
  495358
  513700
  500151
  501452
  381803
  562248
  395567
  496959
  543835
  448095
  448760
  428539
  470404
  546977
  558658
  551614
  567701
  659042
  475740
  516161
  498865
  637049
  823743
  398799
  428931
  423033
  424622
  588674
  454742
  415256
  525758
  407177
  445986
  474613
  550236
  581649
  770264
  467173
  439130
  466443
  445013
  510689
  493849
  487824
  514802
  383911
  396772
]
2.90 ms
(2.08%)
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
  381803
  383911
  391697
  395395
  395567
  396704
  396772
  397200
  398799
  401359
  403210
  406931
  407177
  415256
  418360
  418405
  423033
  424622
  428539
  428931
  429426
  437710
  437730
  438714
  439130
  443867
  445013
  445986
  447329
  447629
  448095
  448760
  449744
  450256
  454272
  454742
  462939
  464600
  466443
  467173
  469248
  469773
  470404
  470764
  474613
  475740
  476834
  477693
  478885
  479248
  479281
  479531
  483842
  484400
  485196
  487680
  487824
  490000
  491656
  492043
  493849
  494942
  495358
  495549
  496959
  497130
  498865
  499741
  500151
  501452
  501615
  502082
  504233
  505865
  506154
  506268
  508064
  509358
  510467
  510689
  511224
  511982
  513700
  514802
  516161
  518321
  519762
  521323
  523709
  523984
  525758
  543835
  546006
  546977
  550236
  551256
  551597
  551604
  551614
  558658
  560477
  562248
  566451
  567701
  570295
  571865
  575789
  579202
  581649
  584527
  587885
  588674
  590554
  602651
  605050
  637049
  651589
  659042
  770264
]
1.69 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая девушк"
]
1.68 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny bitch"
]
1.41 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.19 ms
(0.85%)
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.