SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403210 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403210 [ RunTime:0.003000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16062,794897,74152,626315,835273,387837,712870,826796,574135,774836,20601,542590,654364,830686,100951,799179,455203,728353,941955,255012,836051,180570,340463,747351,719958,730093,384555,646508,673739,652172,597187,608269,1003757,724176,450729,873103,955960,588256,948677,126793,463811,858932,869982,393715,966146,68489,158000,121147,752588,62772,475834,903615,145414,470024,300142,662428,789435,995664,643505,737905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]