SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445612 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445612 [ RunTime:0.003778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137036,44169,28980,118474,572479,859228,106647,667310,792027,838310,730111,1020350,240253,1003622,411982,561044,496380,751279,920852,503902,925511,542527,536995,183215,792658,266224,924865,248843,534473,250520,519096,82642,603639,657183,499198,152331,944449,909643,907161,574978,37944,40155,11810,752891,695238,286173,1046089,601964,159740,663984,581199,984098,542516,550335,413318,893990,489247,349989,858405,1008503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001166s ]