SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481300 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481300 [ RunTime:0.002432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57153,367581,1003165,750571,148172,330515,804676,792489,850999,225651,372354,781584,389850,5851,535916,590033,718696,939115,1028793,561045,248377,545942,972497,612980,1001484,828571,522218,720923,161524,313137,1019733,406282,593449,65929,645863,778199,811077,825346,942045,425300,552606,162527,284287,417185,34288,972128,662772,604251,793996,595587,877700,135648,297165,842417,73771,327137,893749,464404,42302,577491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002189s ]