SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420483 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420483 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677057,446646,269055,501377,984279,22931,579861,944629,564566,87761,55705,343762,359935,39288,492259,336813,320192,309850,1046877,893304,911295,258838,931571,685677,134589,895813,535148,142501,520559,812735,645997,456663,444294,975980,558229,792132,299536,872992,222777,418461,364232,395179,885208,945924,752768,220726,675256,666215,342918,747337,313561,742788,560866,1013856,395734,536848,547292,605782,698040,857661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]