SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311383 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311383 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712439,15625,114832,535939,959040,169459,193214,367723,250214,293107,974351,925566,565404,535123,9033,906255,868823,668212,846717,351890,193550,583162,612902,811948,594427,181394,444374,433365,971641,976062,991984,1027571,1041560,394548,290114,981634,15077,993667,772355,477936,229796,171022,809623,898693,136275,487783,673008,826384,312688,955685,274753,371290,524862,443401,339250,587572,522915,510549,235123,654350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]