SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523541 LIMIT 1 [ RunTime:0.002603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523541 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748509,989503,338137,871109,954340,766757,851002,798439,315059,130915,215518,1001565,214703,60965,163170,870187,601484,387617,159093,585730,495341,14376,157653,45678,923606,245669,483513,774498,230448,10665,237983,740627,599543,281823,43515,284545,568195,806297,274040,212152,678203,923413,669975,838341,899024,892226,679685,765855,396310,474116,154571,104462,969422,242144,956817,198815,937965,932661,589097,255504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]