SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428564 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428564 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328003,395782,302426,371118,674101,240289,404102,569331,605650,468982,1012749,707391,972603,770966,810829,926630,1043796,825996,265904,693806,930708,690978,119365,821961,941093,799688,822948,199081,871576,203519,164593,717539,1034126,389986,54630,109758,727015,800,130486,357138,274887,284507,476376,976982,996736,677328,604367,135970,128230,160796,895693,662729,744073,931195,437549,1007284,1058,293020,583712,905666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]