SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200372 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200372 [ RunTime:0.004838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372081,83558,211173,148439,1020392,60453,921906,704522,725566,183369,363312,477433,405118,994791,63303,861446,991417,917637,608754,973187,239445,864684,447822,294931,811533,637732,30694,189656,413929,426061,586061,851271,967425,736957,353353,724250,451949,630208,114244,846257,250120,271805,364679,679258,589084,196090,112474,262517,481034,955867,864261,815481,260677,755954,446809,974838,175653,369261,601555,989643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200372 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200372 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002623s ]