SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330025 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330025 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343492,134151,691663,790803,191218,691080,536643,917176,930142,451711,959404,484426,629189,233098,12140,206084,710633,255647,84260,397716,409988,70392,1043295,122086,1014115,837140,563335,282955,496785,867279,835255,93143,342180,625621,830866,528321,727659,830872,883681,361731,28967,1028759,161756,755968,887443,81901,67467,740736,206040,723470,18984,541260,998259,871093,241224,330473,675414,189693,492097,88086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]