SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813100 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813100 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037865,1004724,310069,470083,485923,820985,439938,886682,874875,398023,36331,297815,915428,537360,350830,918072,972394,152099,328768,393912,649586,139578,523624,166364,284004,231103,270520,219798,338041,134816,162672,150463,553709,297355,198054,439834,113588,816857,221856,398090,678744,901625,146892,533895,932459,473353,692793,371848,806886,640067,211422,555250,724725,730635,992817,820534,78947,330675,687646,896370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]