SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47099 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47099 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502515,949277,98426,412425,413521,175311,559198,711299,751252,327067,722419,262003,650636,642820,988661,744433,352754,850872,141036,949799,72272,255417,285413,401428,295048,440850,617620,137652,189707,351811,40252,502172,1034014,300183,996060,172839,439972,897059,897783,787307,936027,545252,313106,333413,412465,727379,908311,394282,104109,767290,215846,979383,768333,364173,935757,873206,761220,699734,405458,191353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]