SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516471 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516471 [ RunTime:0.002831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382231,877571,204449,356375,972604,959459,695311,736866,534549,509968,371696,775642,1000145,637909,269442,496721,467497,113349,295780,975352,1044600,372581,726029,133678,196099,3511,289103,749758,105233,965071,804075,515074,584477,434434,744198,208613,291156,416851,856565,981766,333716,14409,648880,267608,518144,923137,244135,301487,92028,189625,370243,322879,307678,612176,628168,754594,890166,414013,333034,356404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]