SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489061 LIMIT 1 [ RunTime:0.004431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489061 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464545,849434,378118,237837,450110,311093,824403,536452,249365,846329,858424,131633,745161,113588,831432,860438,138298,524504,945728,823662,926638,872505,116399,88079,93993,337067,298287,964082,849765,783289,111280,945579,140712,202625,1031684,432309,368965,766574,695610,193018,106269,681127,376166,444616,501910,337260,207939,906750,992688,933926,34639,820000,412521,556117,494857,109549,586220,462846,297459,379017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004963s ]