SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100419 LIMIT 1 [ RunTime:0.003390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100419 [ RunTime:0.007660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016808,251464,595100,223681,353872,719937,165215,982963,668196,799091,453073,10275,413606,583127,589849,282983,591371,835690,652796,786122,344779,817068,398899,1031552,36852,187201,430478,781776,534006,155320,283727,71698,330899,529845,491076,197849,929889,268759,1020423,188060,347896,778342,297557,720173,914459,1043186,316224,688252,60798,156930,279098,291344,543546,375095,853524,802507,384972,77126,514315,172520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004496s ]