SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820091 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820091 [ RunTime:0.003889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199985,463116,919079,920132,632201,41439,678268,407569,427904,102556,989037,547767,801018,581481,957041,975107,169778,205660,893681,168033,864488,746332,24866,127016,149127,931682,16961,288608,1029843,682644,481428,669920,180889,329780,187093,77983,718115,359002,58082,366486,282471,836526,573788,678491,226825,269846,666980,153895,40712,859912,848999,652284,73845,619085,78217,1037041,266614,43974,189219,520997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]