SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001790s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671812 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671812 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572302,563245,876719,581959,407906,19352,410094,358748,539106,734185,876279,833044,330533,550070,816237,190418,7594,189818,986459,107903,928760,78945,753196,775044,289678,873841,977151,942222,1021137,6584,276553,452113,299911,899229,251259,565699,841070,66438,757450,281646,172843,74999,154415,232685,386770,1007441,906196,695861,783719,500247,229224,899544,787551,778823,732061,562398,508579,837096,129145,653647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]