SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200994 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200994 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401369,514923,304991,346591,420702,368300,498102,999303,1020298,379640,396337,903070,718859,122101,1030207,912481,604290,628095,739251,164760,310598,578577,930129,478296,147011,882562,893835,579601,297924,1022243,506547,550504,900035,358427,906835,81716,244220,754824,345257,377250,200868,937036,204530,101535,683291,319985,789022,1028045,839034,67156,925427,288320,696904,772520,998683,98339,221446,236113,880343,186984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]