SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525036 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525036 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603191,801808,273770,198857,526540,517616,508590,1004706,161628,629866,154681,163669,794802,891138,881605,193381,257409,450013,611711,753974,1002740,346944,375339,741061,826158,919368,89318,997125,244733,108183,959620,799296,535054,379715,707534,227528,7204,504713,272872,117379,317669,263691,139821,570728,407604,508206,502281,184207,362329,507018,813588,199861,604558,1024825,258178,66706,109625,1048127,363953,365648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]