SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442840 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442840 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10100,291063,855186,372259,216378,172930,868009,31798,917413,99539,839595,593900,62936,1041894,130651,505642,120960,801674,229840,1047281,869296,530807,443147,501694,617966,299163,31300,1030126,473936,1019274,902037,460912,549518,40208,592876,688191,125441,651170,77419,398879,341331,1004759,397249,199052,37989,485053,183072,242080,555636,846495,775281,328487,701211,425272,288357,217516,300399,284737,247334,534409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]