SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404128 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404128 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32628,897555,309499,828166,126341,873351,292469,484200,339842,70724,636282,531319,247892,38452,745719,613044,457794,80332,720884,267828,810653,486721,1023356,841278,914443,247995,291647,687613,806810,1036514,16350,520192,192786,23196,15886,520443,859594,762345,572754,21205,617783,960104,1047479,902213,959652,694024,966250,322471,749596,39810,714083,423867,440036,216328,870529,257682,337834,938583,283693,745630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]