SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804860 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804860 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925432,433386,1042197,353783,527503,895318,31791,978873,774695,697374,786692,479005,1020324,442538,178536,154676,531784,892333,647377,792819,765511,143395,257486,386305,29253,212425,391272,76788,222504,765611,361770,192363,329926,672471,684174,865053,447043,967469,798172,1012612,147652,735850,732186,49487,571071,91845,48969,782894,841326,804338,821614,198936,108502,500728,610952,466209,666081,398506,305802,60687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]