SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38583 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38583 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441490,515544,270012,222281,66122,185289,552093,419000,865698,608665,929524,758470,94952,348697,185255,786317,89958,650184,836943,240878,482106,477491,43372,418362,443405,959166,341723,9598,935531,496326,67539,227599,395239,741639,972515,968968,409068,904148,616045,27957,436478,302133,649720,267052,2967,1000578,299867,1034224,466416,153119,841133,923589,286060,852946,238244,173587,96983,541599,180134,170106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001156s ]