SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010083 LIMIT 1 [ RunTime:0.000829s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010083 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195752,487882,39140,367256,980600,199229,153568,236400,105755,906684,680382,748742,77638,794783,433309,615227,507661,695908,397309,841601,249414,8988,440627,31091,399468,947711,428230,839082,58580,828580,260771,792280,101570,565825,922731,509176,754915,250385,563125,364484,696180,181175,714797,283864,278190,928302,1006823,652301,266015,483816,245001,802862,242080,125206,217308,599049,889626,596603,806069,185426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]