SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107522 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107522 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807447,104040,1028531,778101,855462,1005630,237119,742195,410699,424533,148227,236953,195651,982507,932535,675069,828689,1047428,750552,915791,117134,422640,232549,274254,126262,416700,293413,20134,824064,375601,748998,560826,581860,675806,345442,622242,895855,558053,463001,455192,695442,339895,350933,229521,19,16229,21173,461359,504107,497407,709289,567522,282154,944279,289923,193492,794296,868738,422867,451460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]