SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591501 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591501 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87900,669376,197837,658454,174928,995406,543511,765196,718387,508589,366691,383609,501105,64285,636420,762159,999138,276485,253983,153267,940163,259618,897676,934238,297659,581229,582325,699434,604650,573688,769302,97147,632099,613808,407151,459076,520322,16749,700006,171034,1031445,647041,368496,971216,827394,868585,612605,59176,892978,577282,983499,669320,613361,757745,990427,774400,721927,724041,472355,562238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]