SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504926 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504926 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719703,833527,924455,651802,502109,354534,821297,842937,694746,360333,82230,44076,103591,904801,796088,166092,174618,561103,925789,852383,327449,839006,741889,842654,295325,876399,863101,633316,809744,629119,738573,968704,749511,492144,287561,601956,706228,415959,84629,710659,761817,522144,329884,214118,548500,532380,231918,147441,378451,299073,844084,1005049,792897,670726,151000,148515,942289,940286,973824,613629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]