SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509036 LIMIT 1 [ RunTime:0.003226s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509036 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219259,85767,339539,479742,912619,760631,725781,171169,424037,752340,703574,249051,774427,1023057,651171,32235,937337,996716,986250,946249,409272,1011979,279584,283203,778115,978890,293697,687847,937783,97535,899122,892872,826352,711591,395201,676234,270559,221621,204106,575258,950575,463793,1017999,473487,69795,992347,553235,910254,91636,833545,926744,794585,579052,392546,801231,503917,85455,1048032,946054,856706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002661s ]