SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281420 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281420 [ RunTime:0.003595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002007,59770,525824,924109,762041,121574,740757,902227,285539,333383,662609,136850,119393,728106,752526,30880,411710,144454,805209,611707,407399,681895,716423,86497,109992,106244,731493,425296,398703,1028656,942800,256742,733516,856285,198572,767245,244202,1046760,63284,679338,230189,36559,600030,573864,579263,495579,860456,1029204,575946,666838,350263,984689,350496,638129,889785,145736,954145,513775,757912,213135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]