SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101374 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101374 [ RunTime:0.003003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51797,625891,258196,700035,298042,163152,370737,739160,1010196,897328,301571,243478,353446,213275,683237,12112,628147,256238,740953,1023791,652324,369823,683163,141777,762410,957484,468417,667676,88063,524030,153862,504543,1018683,1018611,963911,443464,175064,1021851,351874,299147,338238,235571,130469,292067,772820,454559,459659,160843,505408,295221,891480,923830,1008781,251482,918471,388659,954589,597174,657348,415060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002346s ]