SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443401 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443401 [ RunTime:0.002694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471079,670267,540829,750467,187310,44171,710927,494222,127927,366358,996451,784871,319037,704229,822375,660619,769425,398433,664315,893805,100910,864547,404720,316932,714765,487543,673488,131238,450133,853319,680906,86250,343028,628790,87928,478354,343918,100223,887328,44,352111,774531,1010536,947426,529372,753152,920786,720151,218937,634510,786152,572061,574403,551468,466710,902758,1035631,491145,1005406,580227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]