SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291997 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291997 [ RunTime:0.003083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924442,342610,21311,107472,639739,841479,277049,645712,386612,381178,320693,910355,240112,232618,411423,210930,283057,756187,883188,1028180,772134,580696,479926,194532,479982,21705,614332,756578,22073,288992,680006,15694,359069,42576,1038928,51726,959254,99248,83177,994846,1045922,249906,890744,635319,630979,77105,476623,873739,246583,471128,276257,379578,658511,219640,705052,149621,420844,368389,720059,292058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]