SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681790 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681790 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269778,607393,28763,796238,268095,729127,16116,965767,873295,762089,816835,130114,664522,291677,116364,303098,1000473,299651,172481,653961,338420,790738,938676,593855,992856,807109,206123,217370,727543,618447,254917,799144,784803,968160,303662,567267,885085,515176,432242,102804,678932,295027,701085,914478,386634,702680,310664,142690,120140,793186,725054,472357,679411,729488,555385,427548,850153,587531,268648,694606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]