SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489681 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489681 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820410,698822,795565,409859,364982,416245,823176,742376,20184,797588,603127,770202,636543,504123,288748,846904,730679,83778,760995,512729,865037,622810,429143,990919,331427,949358,828912,5604,307755,650288,663229,305007,526123,988069,881723,802639,1046581,621078,1037937,673563,102161,990452,982950,598295,385468,826132,236818,518851,44377,918031,587841,28260,710759,283953,1045861,41520,486955,369048,993196,314782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]