SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831218 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831218 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40229,967862,714934,969794,286342,757820,633650,903271,658340,451789,225427,566790,96164,493113,917948,8296,438519,6011,29125,762920,838161,1008172,407559,143386,19560,735374,437800,124014,301102,439447,1029437,396685,736791,41661,693273,590546,1048491,387315,1013296,560032,591541,135553,259643,556457,554268,330341,356822,949233,356624,535262,860003,527113,85884,385607,903402,831603,857165,767821,381571,432973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]