SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800209 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800209 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395369,531206,188864,528662,432679,132333,41873,306293,386502,975512,423049,1041504,257560,215463,347370,967563,643114,446953,1032558,398143,73339,678133,995131,1016048,367016,633905,41012,145025,26333,407832,34180,707820,818739,990619,612787,826758,741192,140846,316046,937411,399681,991027,525642,526758,763478,771017,670573,836051,155592,918448,613058,565598,472835,797526,802524,287523,332531,471721,947762,327833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]