SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031751 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031751 [ RunTime:0.002905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448682,977641,433722,427981,488500,965106,849184,256911,752822,436701,694945,937965,893857,418387,493035,147730,845511,694245,684387,914130,181868,817197,152353,119435,988040,637836,773557,26251,746392,729121,1026858,615175,752695,63789,411257,274203,849931,1029071,285203,190381,665770,351688,902319,448867,63751,164058,806248,897978,594915,387324,702682,506662,858302,702030,62498,243741,426785,975460,1023846,374645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]