SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45307 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45307 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317186,689226,972370,606143,441198,96410,280802,710342,119718,505282,498931,177590,80094,173128,311824,687329,364214,109783,996343,801385,733587,434868,266253,276921,918683,966545,396592,757674,603913,887324,5960,299713,605552,123131,992448,267869,31282,904778,313108,947533,899508,831564,872629,366242,554655,627253,95047,410430,702725,745080,1025066,923550,1035813,344295,278250,721415,361526,507288,619023,735996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]