SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527658 LIMIT 1 [ RunTime:0.001605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527658 [ RunTime:0.006316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31045,828314,35432,602582,38000,838218,695235,716774,599678,195900,151661,917308,204132,561122,513307,66206,657267,615458,620082,269430,178217,907363,991374,775403,362023,477213,424999,238429,410788,783827,984509,995699,1011808,650584,1009924,751230,764186,285490,718259,567893,980,809405,281101,973799,392375,710304,87721,1024163,804164,694034,330297,1043605,868534,306523,279571,930553,804008,467855,144860,968445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]