SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804260 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804260 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894170,761381,818615,74379,387555,983461,1040131,120419,957810,464919,389796,767678,413751,200197,820532,833908,895362,365695,341678,859090,1028932,244279,58542,203606,567007,562357,712692,117537,942364,81720,921006,965565,1039244,736507,656470,148641,509261,377573,40040,767267,772188,236654,22980,332436,96501,515532,81277,534667,292788,997629,740305,1018409,101335,1042880,383844,48682,600724,994208,831042,1008915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]