SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111180 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111180 [ RunTime:0.005658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036308,578417,969905,1042252,886711,547821,297144,288596,229643,360202,379850,578399,290628,486598,983084,749941,723226,253351,378652,167919,908565,319514,211568,352800,281351,34243,307311,951591,361708,650497,515068,145435,1024373,1017376,629849,26723,363577,974925,887016,825471,364055,539601,649389,546664,247426,425179,1015571,172252,176881,907712,615359,544013,708019,706848,156082,822266,28339,1005302,81591,143835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]