SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555013 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555013 [ RunTime:0.003202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42923,950260,420989,539486,339639,1027935,212122,663324,786559,873344,579921,530603,1031616,1038199,417319,661873,716235,463425,577743,491471,800407,700370,562065,894813,210991,575252,349015,496701,189870,142571,840953,857092,656405,594281,465460,103503,730992,164194,237753,518232,745182,519353,926788,416812,167358,437514,247529,837427,99953,341883,794590,401527,503866,214215,54194,274303,201002,924872,292985,584316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]