SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289984 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289984 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484809,145440,187096,1001310,50667,466178,513574,818298,371662,243720,294701,72754,1040478,100790,988456,687346,940246,267597,330034,740386,682729,428609,709930,166484,261417,862157,570971,666948,837755,872483,958328,415024,145806,397947,580492,910694,909616,794851,626032,363597,555815,9981,400731,276167,727448,140447,495602,833944,81765,384534,613170,589404,93664,369620,491679,715145,804762,718145,1008666,958514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]