SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801018 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801018 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752423,538192,928070,232837,584948,888509,1010855,745214,274817,552713,684246,766586,318914,372078,24848,178327,95421,888025,669957,744467,414660,937057,260371,748625,918473,896989,880024,797946,304247,421054,1002498,615942,871880,153788,438982,742268,154636,249401,835569,522150,840249,731481,944195,125337,1018995,637787,500868,12147,400759,190161,572790,302239,97465,75785,354620,238999,163617,191394,168955,292785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]