SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252019 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252019 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331405,630034,759550,530084,103823,768448,968090,739386,105219,243580,1005127,796211,126209,76913,932609,900943,725085,8283,1010574,595314,692760,204534,659065,76104,984064,763939,173314,231593,870400,869003,61482,15211,431317,381190,783615,58375,800320,539633,821061,75486,341290,451646,617807,613641,691677,203351,660128,449416,816060,232683,784172,559528,791538,744553,655027,901005,814114,311668,371798,268835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]