SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5426 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5426 [ RunTime:0.003408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663894,285034,814024,831453,891574,298699,468605,849296,147204,224596,632580,15743,661137,230535,549848,482467,689303,291672,105445,363384,931286,515905,980351,606726,458681,629951,180569,310494,176059,952220,646607,1013676,538861,507393,675576,188944,845282,297573,786406,52377,440357,567218,731835,702642,270025,723745,954642,507547,422124,393676,995950,844748,714626,1407,439093,567441,871354,691801,242284,121082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]