SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 117919 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 117919 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49491,152789,404852,205247,840771,472864,861511,988536,205762,549261,322360,125208,251305,821227,222027,112754,370480,597435,1009728,596793,139209,795981,581007,461478,101993,11256,683069,510691,104102,61843,298369,464131,178846,628196,861665,831627,515834,504175,1032837,611140,985074,28048,789482,149376,886643,307720,765966,1026618,186140,61108,136102,306831,710928,1006385,49770,949840,616674,689169,475768,36686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]