SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352465 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352465 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271018,305908,553141,211383,505740,289254,748276,286806,839396,14394,907819,311292,392517,114123,1026510,530386,686547,547102,494745,403534,484158,389289,300957,286011,895204,636497,737260,114660,162743,545107,597304,60272,328849,190128,237046,291003,112025,801799,370270,318065,877729,446626,1022285,801530,408207,605783,842806,967283,863280,209990,924796,648138,391130,99800,883826,489459,902825,452134,1034964,657591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352465 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352465 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002952s ]