SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509176 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509176 [ RunTime:0.001455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498241,741630,785182,105498,347959,107756,249606,892516,557807,1030446,931389,307740,933453,570395,234312,121415,323287,382279,30778,755170,914235,631786,28916,932418,597773,762684,693191,600893,364807,391305,707705,306774,907610,14521,343117,24214,742754,925020,86140,490975,331956,710021,342569,265667,931784,881214,523950,962185,897029,95371,899217,413909,531946,96086,731131,292538,963740,405385,961980,7450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001559s ]