SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249908 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249908 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424664,208078,207835,502814,8386,308835,911457,664905,922068,547128,918357,380096,881741,483124,202011,324305,411062,199685,728008,544338,46543,772756,924005,528168,57887,928762,458554,629205,401146,850355,782571,403991,225155,605993,197826,480799,618506,955507,312308,821175,247889,269692,1033336,820129,275212,84151,600139,753527,805406,170785,568417,723559,59910,217826,889588,286463,706020,906174,521270,404343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]