SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485329 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485329 [ RunTime:0.003003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362809,167916,544158,373878,652450,956381,663431,806810,33978,464054,372261,483703,639771,406568,558472,260703,535564,449249,999707,868839,794774,798896,444771,165,100652,82120,662050,229454,3195,91783,692864,801129,272865,552799,595006,278484,512174,849582,810781,494122,172228,696654,959697,83339,876516,259758,38397,940366,991529,687508,371394,812091,44897,390514,494859,290592,348544,245852,33345,592138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]