SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498410 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498410 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60590,993126,347920,191021,232066,192566,322083,818314,944310,764738,838548,570455,692890,412080,366880,915450,704634,423960,633226,726671,406975,38372,649051,32892,102504,582092,476643,555571,1044472,522992,715731,886135,9775,845376,458675,602284,295065,876643,402715,316369,143240,457683,463787,703483,632360,344523,784180,953276,191616,538348,168261,847661,642178,814651,94528,351759,56854,665841,621479,124281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]