SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842843 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842843 [ RunTime:0.002854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582507,494996,735924,740113,639381,397343,789590,47810,269095,311982,702992,148541,32600,565345,958433,85956,783607,487270,49276,484159,288969,450719,530383,301390,306849,887062,884702,617002,659318,148538,965140,746688,493224,484614,886802,14307,621722,89679,603809,318006,340875,622335,764968,1028449,587590,861851,854685,788664,887294,221965,878415,780858,632323,846323,496116,607810,298808,451493,385906,307572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]