SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504146 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504146 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170097,182886,167391,997889,652089,652230,148999,601551,871683,220294,1001258,75248,550228,644405,249193,996254,962448,460876,547822,938814,968335,527387,292993,78467,651947,1001664,89726,60680,379989,722045,416691,749234,359942,810271,466589,530237,738332,528134,591800,328296,110646,196367,116725,15553,73735,229577,285651,542460,119194,373435,160303,402357,43461,1020207,601112,169676,777988,259417,572781,11786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]