SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650674 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650674 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426808,581305,68640,721143,924090,140055,454325,908013,1041635,603323,807648,938198,167722,125691,790158,164249,87011,678777,1022357,233766,992428,965586,802646,553807,405430,758219,862396,308405,586257,397882,1043414,186184,834616,199582,805464,262385,643944,990999,307147,768506,162205,497969,168799,178658,860000,421637,449543,326875,553463,610298,325065,781046,794285,950521,245265,757778,383401,533207,14042,812102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]