SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554612 LIMIT 1 [ RunTime:0.000805s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554612 [ RunTime:0.006223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220305,961758,700618,1047908,145439,582927,118700,675596,199959,814404,335405,338283,109692,939365,628836,698270,100013,568373,538024,821960,123421,28485,428788,951270,465435,372711,413913,4511,59143,550170,407690,114548,652178,345079,643084,839581,592619,770544,36489,253105,927188,730768,761211,884964,976753,40971,750331,665961,824686,93302,886332,211321,905304,861759,710192,855278,854403,980368,321017,157359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]