SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505620 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505620 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846141,696174,987277,887117,5391,252246,686214,752040,222135,526235,1012224,273732,817233,533664,123410,1019508,246059,20912,118768,1042696,315240,629922,823383,700688,352589,12639,671655,555695,203530,339725,546209,129170,391492,323349,998721,93481,836264,62481,53746,209707,591160,839653,787785,403877,498773,171304,15610,246238,150309,755380,542461,569270,210827,1022569,891632,980860,672609,700264,660906,473880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]