SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804400 LIMIT 1 [ RunTime:0.000904s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804400 [ RunTime:0.003422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419686,116924,729352,92813,142386,113397,761367,738382,563494,202938,164264,508114,550491,596812,489546,783965,839753,662312,986969,676806,84788,187214,707523,377183,245512,449154,52835,409541,652114,498906,1029111,914867,145663,967751,587529,325091,683042,979259,287570,826523,934910,953935,126989,485809,427437,939346,112568,400382,21836,928229,99472,736255,596676,591618,1008401,426916,627841,574263,406041,101552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]