SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576851 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576851 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905278,246013,877171,658750,341731,221998,765233,290213,381203,991398,774059,946980,953379,57059,191870,847478,1028767,228153,486667,898820,11018,1000869,669465,301431,282917,228920,347448,807785,560420,257664,697689,856472,156041,890371,952113,121636,760867,152716,330020,542955,25768,289764,372092,334556,940938,757817,190681,828672,893032,396083,573709,127739,666415,122017,550817,59312,197449,466787,1025698,608174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002346s ]