SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 628901 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 628901 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842033,334413,859688,220490,762192,780210,316730,1040551,239541,488045,593656,178940,507965,1020780,802393,406875,158104,997720,97293,969951,377882,924394,106969,97858,55127,606733,381310,550107,899579,372687,1024283,207127,531511,573747,436456,811739,852799,308510,873306,497110,694992,20444,885158,662860,404989,383827,202353,857411,272512,619347,445320,288758,105227,421284,204113,843710,203592,304111,632989,500650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 628901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 628901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000939s ]