SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141254 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141254 [ RunTime:0.002207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044152,1025638,415082,640114,394468,626286,711647,903020,809781,383159,743686,411478,987468,133848,682757,468766,1004170,988640,919770,628073,89926,385610,897240,859765,454482,473877,827808,57241,601344,561597,1433,669714,70633,224006,949149,659393,323012,748500,645239,7356,717359,76184,168205,209560,308419,551335,346780,936605,1047340,108551,818544,773886,310447,937041,923892,866999,844332,948529,489967,302479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]