SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810800 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810800 [ RunTime:0.003001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237248,41038,28478,868894,162748,380271,945762,47658,821261,560400,349988,472936,606930,684375,984790,440517,270080,316257,245406,309551,787032,595780,474898,526548,573024,219478,880253,373511,1047489,29462,622940,996181,295067,816343,1036658,483441,60289,585958,447103,825407,879913,294531,952309,25664,800893,657863,536139,893052,346846,161475,298307,265975,883378,424043,979215,774099,332947,853877,215136,437630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]