SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336951 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336951 [ RunTime:0.002724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91421,112554,507297,884409,72539,19957,293653,131574,43582,868247,622058,768284,812140,254554,94684,538196,313295,133447,662410,229579,261511,307269,770371,629735,578981,206260,270936,763524,1048682,485470,275284,744593,218199,583190,879311,370856,760506,490361,345245,517253,343938,874206,305817,521013,530902,12279,154579,776133,518516,92142,808531,359627,463537,102114,280689,310853,457099,314055,611095,800605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]