SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047856 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047856 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34441,969888,260886,675660,341083,140201,430279,336200,241870,367527,920611,53234,240703,622137,1038265,336854,693974,46378,565369,910773,867592,21611,918652,252978,665283,361233,336465,635754,22987,50541,530046,218420,970711,156212,839215,763868,670239,741614,263796,167280,945006,426400,989617,735751,849109,543467,324970,290850,928520,392863,450075,706555,90887,878609,239480,847775,71754,943188,383044,416363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]