SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010092 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010092 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629258,167820,81582,98823,1044075,609866,602245,630667,658489,945312,923584,527965,14185,482671,497564,1028433,501429,1800,251184,547470,256026,748823,629428,539437,732325,314319,512923,719071,8943,875911,57291,456502,284256,92238,467536,48047,1011010,315448,559560,70536,43430,423472,534929,471628,126278,155171,428996,508010,217717,205283,87474,154821,997883,723146,851310,567487,711639,222517,205994,540450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]