SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58591 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58591 [ RunTime:0.003106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574518,290330,857575,543349,170551,476212,508318,821384,321169,382219,899382,281765,610970,634013,362786,312982,132138,253988,64052,912826,991562,893036,525272,38147,629534,941602,21568,484929,813675,652393,652640,744685,161452,608166,912544,368095,70913,996711,444049,465601,54817,789628,514015,190745,647757,436304,859645,784159,383707,419624,1027242,1007594,972642,234179,803631,914461,923068,726855,777106,391437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]