GET https://search.jues.net/search/embeds/2?q=black%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.98 ms
(87.88%)
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
  41516
  45605
  145646
  191487
  239677
  249637
  328534
  382411
  386304
  392458
  394751
  395833
  396560
  396609
  397849
  399058
  399352
  399414
  400753
  401203
  401724
  401728
  402657
  402664
  403579
  404264
  404829
  405507
  409080
  412949
  413235
  414098
  415097
  421435
  425992
  429181
  433694
  433745
  445017
  448692
  449868
  457145
  463262
  466968
  467324
  472151
  473094
  474852
  475698
  477396
  483734
  491977
  494365
  502562
  503828
  505690
  513290
  516686
  523367
  524863
  529286
  532441
  533480
  534237
  536932
  538428
  549977
  560184
  562128
  564608
  565100
  565149
  568600
  571269
  575020
  575197
  576415
  580706
  586463
  586631
  590244
  593394
  604083
  607101
  607152
  607215
  617130
  624831
  626138
  627740
  630227
  630266
  630292
  635948
  639131
  645010
  650793
  657865
  672140
  675008
  689005
  718203
  725115
  727801
  730466
  737910
  738855
  743159
  747004
  781697
  789692
  790983
  803091
  803321
  807621
  813388
  821844
  821848
  823929
  825039
]
14.89 ms
(7.56%)
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
  624831
  607152
  607101
  617130
  790983
  803091
  807621
  813388
  730466
  737910
  725115
  738855
  607215
  635948
  718203
  45605
  41516
  402657
  491977
  586631
  675008
  575197
  239677
  145646
  394751
  392458
  382411
  399352
  401724
  421435
  821844
  821848
  823929
  523367
  536932
  533480
  568600
  564608
  575020
  657865
  650793
  593394
  639131
  586463
  626138
  630292
  590244
  627740
  781697
  803321
  727801
  743159
  630227
  789692
  409080
  467324
  401728
  402664
  191487
  396560
  397849
  399058
  404264
  403579
  412949
  445017
  425992
  429181
  415097
  645010
  825039
  472151
  477396
  448692
  473094
  474852
  503828
  494365
  524863
  538428
  505690
  483734
  571269
  580706
  672140
  689005
  549977
  560184
  604083
  747004
  630266
  463262
  395833
  413235
  249637
  404829
  399414
  475698
  513290
  502562
  516686
  386304
  328534
  396609
  400753
  401203
  405507
  433694
  433745
  414098
  449868
  466968
  457145
  532441
  529286
  534237
  565100
  576415
  565149
  562128
]
2.27 ms
(1.15%)
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
  41516
  45605
  145646
  191487
  239677
  249637
  328534
  382411
  386304
  392458
  394751
  395833
  396560
  396609
  397849
  399058
  399352
  399414
  400753
  401203
  401724
  401728
  402657
  402664
  403579
  404264
  404829
  405507
  409080
  412949
  413235
  414098
  415097
  421435
  425992
  429181
  433694
  433745
  445017
  448692
  449868
  457145
  463262
  466968
  467324
  472151
  473094
  474852
  475698
  477396
  483734
  491977
  494365
  502562
  503828
  505690
  513290
  516686
  523367
  524863
  529286
  532441
  533480
  534237
  536932
  538428
  549977
  560184
  562128
  564608
  565100
  565149
  568600
  571269
  575020
  575197
  576415
  580706
  586463
  586631
  590244
  593394
  604083
  607101
  607152
  607215
  617130
  624831
  626138
  627740
  630227
  630266
  630292
  635948
  639131
  645010
  650793
  657865
  672140
  675008
  689005
  718203
  725115
  727801
  730466
  737910
  738855
  743159
  747004
  781697
  789692
  790983
  803091
  803321
  807621
  813388
  821844
  821848
  823929
  825039
]
1.94 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black old"
]
1.84 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black old"
]
1.56 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black old"
]

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.