SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981968 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981968 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893965,463968,950885,610680,864694,117465,558837,904662,995922,1018750,759008,932921,272110,925894,248189,879762,26166,998469,410692,806867,974130,674157,438654,830337,199247,83232,513936,54015,938239,315803,216535,680412,833134,69538,915373,332428,370023,38829,640913,363662,648865,1008922,367077,845001,304003,126801,509426,201489,49763,123435,504126,356593,591944,391441,654610,183475,971817,260906,738079,186670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]