SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3083 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3083 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468181,212335,720427,124624,349400,18841,295675,1045553,49991,348763,630591,239212,629052,839373,497399,727215,456724,495719,86867,880049,384284,655749,562371,62386,243946,995731,331042,89465,163768,403752,814538,171884,278549,978582,352751,678821,113120,544301,516974,668558,799435,606912,786974,42127,96666,192406,636487,221436,167907,628052,914367,149944,1018686,958529,547874,842053,30673,408712,654515,197362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]