SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405612 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405612 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756865,376143,166578,712990,944820,169568,749767,254714,800581,137092,706996,172328,547516,999471,1035945,435445,646048,794648,558572,601323,601788,520864,814288,630804,539679,426686,936404,185044,119639,263150,946718,71168,27261,720222,595109,373102,764842,255070,738322,216420,278048,861261,592034,451435,98057,814389,835141,58594,580565,443399,85160,190226,330040,506470,975623,806759,112388,477542,207463,753335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]