SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290450 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290450 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562171,48679,606574,33750,153913,830305,671514,10923,487031,499322,571637,406981,198511,835625,591448,688592,1029328,921643,132727,976870,495208,578059,323118,892305,279013,876885,530707,591994,158795,551138,546508,877230,455113,215433,910401,652009,222552,200676,501902,52407,46636,828738,53808,990158,87803,689827,883574,384318,60598,1030828,154029,704947,733367,312349,276994,783887,524723,442729,266688,812803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]