SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470894 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470894 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91839,216324,663314,691990,527903,705408,1048358,136148,857892,627962,517864,589002,51195,172294,1018792,283641,1023104,542865,505780,129406,804381,694021,661983,361732,462370,300488,59780,282281,296568,342023,733197,277114,1015911,775540,625369,85419,686122,371239,545723,672603,577850,313232,785494,295679,1047297,365715,978450,234304,1011848,559165,771174,295738,571360,175072,362911,42978,8156,861490,413337,76025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]