SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407131 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407131 [ RunTime:0.003833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202936,211154,998927,613981,177649,136024,317691,624718,46952,563098,486424,642049,1047006,307830,96144,372053,286026,534534,640267,354165,584163,718152,488041,194621,707153,661285,473620,835605,139564,587908,657077,77390,764260,808853,377156,514053,223081,961451,113098,871742,705026,26002,545746,434604,690320,576302,1022264,642342,556683,44850,989523,256820,377826,345292,480598,653078,853174,935070,517511,496382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]