SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488029 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488029 [ RunTime:0.001387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107330,748431,952176,385971,81896,767530,439095,372216,870521,500570,819474,413473,233912,1030809,471196,176849,314200,735335,905086,59950,116898,297129,671996,252030,897621,54565,764918,320579,332977,1036038,202847,633414,912115,948473,169045,949662,248558,588121,884466,389523,279160,106542,959785,64377,41150,836364,510425,341485,412396,240275,109190,771551,700372,372527,981563,139720,578758,222041,2512,174257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]