SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541077 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541077 [ RunTime:0.003965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554275,383694,530366,662309,245653,214933,992508,506509,843059,788395,319290,1024290,277656,501206,737132,582959,12889,347800,837685,991918,222064,194263,754442,316040,442377,728224,856982,249787,123394,104968,369005,521042,186045,24344,185518,665465,427642,234406,17557,140656,1032792,159390,1008180,331021,449768,500723,941241,320946,708402,308166,331762,348826,516657,797171,376051,118699,868486,1015833,961189,1014868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]