SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 212203 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 212203 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745393,394672,110278,363903,806504,549912,697478,774139,557214,531515,522670,339071,102773,458802,29101,242193,802402,62525,431880,550642,981923,98520,579788,595051,211256,221664,850147,529522,643195,560947,1039057,895813,382939,736793,60607,172131,971627,447260,706914,554350,918116,212823,258363,182639,720801,366215,805401,447535,119486,371190,982392,607888,997361,989547,579891,884128,799311,487500,256682,876754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]