SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20084 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20084 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39740,127362,909023,762545,1037325,245132,925720,142467,57259,787116,18711,599487,578370,228043,844202,380935,550842,185316,738343,882823,642793,71931,183522,165694,836102,800272,668602,809106,1010185,464932,424010,859517,233445,478468,225971,246270,854210,283707,483576,745584,477088,680785,444240,256821,454755,510032,211659,476691,338765,1003752,227142,878875,948645,14700,689089,666625,554525,299637,22962,503750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]