SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103262 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103262 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424031,60380,645862,223363,861294,440225,983216,844371,397107,486591,905348,88588,1028005,257093,826247,762786,649813,609780,698866,88252,506040,688742,347293,579044,680657,214,322710,546100,816052,620930,618359,897075,594104,902088,326817,949457,260512,415123,339652,620321,29993,888365,225714,545959,514451,975652,1004520,974712,990079,197500,458550,654766,957206,336959,278966,410029,981600,471493,760816,77192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]