SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33178 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33178 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405990,258295,526542,383826,205367,829309,525369,873525,375695,296098,202299,724262,168530,344037,708865,144262,805250,1045025,361928,634731,571091,543659,573526,424189,652929,210729,148360,990455,255449,496328,205479,513894,52408,516918,618818,222685,273531,662972,781441,487470,260755,870197,45870,329676,916431,489400,885416,671882,935759,118858,295329,992679,308955,99567,500479,191118,98419,718583,1045228,460018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]