SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489450 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489450 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140090,309790,19820,524084,885381,799050,87919,721808,1028450,679389,530160,293809,327270,426860,82994,949618,1032861,676732,707215,988487,400607,279304,473107,35930,460797,615261,1043118,545146,552828,602796,540438,978415,1045446,218463,630463,851146,487727,382874,58384,983428,75707,810915,368500,158309,11719,714535,377863,230142,794624,625132,355449,421243,1036280,764163,262442,112039,842595,591098,707806,38418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]