SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043439 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043439 [ RunTime:0.003215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288845,83969,256003,159468,828919,397390,660855,891481,1026173,958687,807504,962407,549341,401988,677073,724552,117202,32264,360871,384201,492989,420986,644414,413916,34636,84589,135296,809920,351112,410366,16399,888770,806494,596156,398162,259486,314666,868322,248272,436397,595616,287303,158870,807779,360585,362502,279871,382003,284314,708957,636618,749344,191891,678813,209036,752263,528248,776239,665874,383545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]