SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002803s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502463 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502463 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135626,628111,477458,1035230,864678,410900,364165,92984,781725,101647,885899,29219,953920,260234,165770,462823,1011343,514948,936161,657026,150332,696505,89000,313172,260418,763268,134095,107310,72653,219386,163731,513024,153132,842778,677773,817771,763182,786220,90695,468748,69604,744127,740895,31958,495108,144961,793508,315334,964468,1043803,176577,74712,170529,548132,981825,226196,482263,251627,969,664275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]