SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982081 LIMIT 1 [ RunTime:0.000646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982081 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847799,706338,602589,161156,78576,803570,877389,455381,550328,525865,880862,771501,356015,451390,416086,954834,597927,281696,144021,653509,206655,62891,667214,277673,677297,240138,867456,144452,511278,812185,672592,523211,335965,242974,622201,567975,619666,52143,289713,935284,330222,252633,958079,439939,995217,169198,732470,427009,466294,117789,717834,736984,790289,935564,991189,434904,366285,125690,690679,233562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]