SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531618 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531618 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495780,490706,923605,860837,739856,890125,956056,36766,387770,331112,378244,964737,967982,683398,102816,340994,350410,318026,410299,142453,655827,837491,979992,462277,519198,402785,69351,185212,303421,108588,835132,846189,467411,825441,828390,369760,34800,186751,211446,223214,474178,510111,158000,767664,13001,835782,828232,261796,1021524,556432,321741,164856,77394,524863,676820,449772,90200,309705,538339,833643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]