SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504311 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504311 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61923,271443,609455,709950,249716,149989,297715,642472,1024327,301900,974088,475374,752415,500730,664577,848276,27316,449414,169629,239355,265766,340846,809810,337088,939053,408512,67807,219352,938227,576106,881396,232129,539928,194217,494190,320150,226348,395776,411517,989109,875255,466524,375649,707533,653403,934690,705702,68566,1032989,383758,755676,541463,860427,478709,822308,490227,83696,404377,352080,420940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]