SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546860 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546860 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406512,669758,247449,305400,530430,152504,287493,806489,897936,158065,845691,179081,263860,123166,243255,975032,885755,214870,216450,17890,600489,128234,179922,692499,126856,38434,676862,378546,394543,432130,39113,664176,1019914,274551,228916,246506,58588,966513,765649,920401,519437,817169,712384,220032,113785,998400,413610,786978,800706,939340,764670,38626,262614,756670,733212,275337,81006,1042598,473282,856046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]