SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593568 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593568 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504023,529856,556894,129667,156379,464552,627133,161892,155100,525401,754391,823448,36282,373823,814405,860933,255259,165448,345678,1021512,995097,568698,580724,976406,910066,848008,850865,523815,643685,799059,739372,444956,1014284,81734,69593,272368,573512,199405,109507,333364,74000,424254,851220,774897,186230,1005722,927626,698636,598711,699433,112661,1018425,200289,91989,75450,902269,274117,216043,288924,299770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]