SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338310 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338310 [ RunTime:0.003398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427125,873517,850516,627515,384722,857547,801345,322767,151784,812329,269531,628319,808013,875743,159066,458074,785723,320444,466284,222681,711972,48964,579187,804609,913335,14147,758016,53174,774518,478743,765887,40171,467334,919428,226711,443161,155289,523951,457202,1002290,891428,907650,813504,797784,386883,426017,122221,765872,194734,289745,903158,332153,373810,767420,45109,819993,940857,446842,1008206,370501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]