SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266326 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266326 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240094,632500,841801,223541,786751,599918,490287,82898,945890,972998,973668,29311,781616,960192,439324,1017876,791954,106080,396649,645250,684065,308506,607264,910666,663845,857367,334421,688133,12842,170652,248078,314085,765342,550527,441669,835722,931067,28537,874789,834490,112560,937308,484329,182925,743026,789592,769925,1040212,956160,476492,6578,77037,393250,893874,729839,753382,783637,151090,339104,141759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001215s ]