SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485335 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485335 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515696,477788,931988,1040527,877393,525296,203506,725867,886089,736295,196539,322452,69850,475992,350887,732265,616121,954236,740059,72269,753053,558439,632329,601008,94207,714733,327099,961875,657920,684946,961806,234384,551226,842865,240452,718861,983987,311766,495556,967527,398851,270105,633353,49322,844595,600962,846965,589755,749734,31023,784766,313625,920433,632869,829280,723376,584390,577874,382075,174721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]