SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406221 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406221 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716899,594275,443901,470431,617994,535895,555684,57748,379576,568051,933311,379400,225194,744143,905224,920533,227904,538560,222576,619765,208275,995924,729493,50664,437385,154004,466051,798550,965598,902638,915638,990499,579601,256844,267586,763167,892156,635823,887146,951360,385775,547120,326060,896696,668819,1023565,465528,935678,168061,769969,353140,552806,952335,217446,24157,915637,854297,355080,664865,580566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]