SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542315 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542315 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277418,462697,139735,558663,773943,503500,349573,232042,792848,634594,598709,925828,608861,223312,17867,1030353,595395,828195,143683,763988,447165,765981,648894,730445,388664,595220,680863,327055,872075,711315,715687,761426,615574,154244,401541,711955,222540,810416,1031323,247922,393184,455051,426825,750828,337387,292289,615733,122267,963521,589326,14101,474658,505565,302310,1002168,323646,113006,98750,768541,808540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]