SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409200 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409200 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173560,144176,891692,924841,571466,417186,867995,704429,1014739,575956,374337,717463,62764,228463,461812,313324,916868,746512,331531,714816,379028,225065,1002775,787805,452627,91522,845902,28086,362544,937795,534521,415414,326331,338518,506923,929225,109072,143787,264856,346586,841853,944815,547659,68063,325607,889094,710138,567909,41848,666437,718656,346641,331740,468726,248031,847397,347247,145101,701118,145832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]