SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589029 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589029 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796450,565049,569895,248324,998056,549500,766281,541351,679065,215681,609928,293415,609836,1047061,693773,481176,66011,77645,680070,167649,884754,799024,528443,14204,166943,537049,1001269,545161,419582,898307,912491,76525,447463,448691,453636,406679,95631,108736,200394,522211,837577,441668,975172,877449,760702,68661,686563,587159,563138,551681,479310,986192,121989,864101,475412,111552,985902,1010437,85897,289029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001844s ]