SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004943s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374203 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374203 [ RunTime:0.009071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140392,823627,882517,192230,770664,165981,913195,607127,461281,1035537,838502,272230,446287,1029557,806367,468010,481597,219257,969311,1002524,244197,424484,688218,266455,515162,691250,461586,301422,166279,476280,857767,485533,1016506,929673,332794,912325,568265,827484,34592,615232,792844,841299,1016412,253259,530388,41884,862827,74579,628963,156835,22415,881198,1007866,502172,840040,308236,651691,550316,191174,62788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]