SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901071 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901071 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726022,34511,891379,366508,112769,177465,818976,1008322,108707,611998,277204,605599,592228,510023,596547,941380,200690,452777,591009,71261,820287,675167,659746,672300,905452,628574,492710,139896,1003085,292473,902521,100548,513053,159242,964649,655752,541000,571751,801005,478163,652569,439477,924620,851131,329207,399285,951136,49162,80741,553503,410565,496712,267854,377195,236927,269522,274223,29089,888525,884428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]