SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201075 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201075 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576130,632571,506833,966882,1015978,148098,750188,132158,333050,283387,1021180,1008918,543155,616877,683242,860519,512939,602839,16989,670760,34609,469791,651568,300775,798364,798994,1042298,698495,755911,537149,253079,591121,597032,662736,97415,109130,8328,777934,664206,428531,619888,990924,41633,290398,427256,967727,251824,924355,711061,969203,925256,1045770,575208,596305,346005,542740,831995,696667,860934,36671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]