SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671541 LIMIT 1 [ RunTime:0.000741s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671541 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499598,548509,291026,795509,631955,685417,909151,608222,749153,407132,527755,670070,275383,90092,101510,190135,303413,973494,1019673,390395,256110,523089,448626,926663,927469,901252,425604,567845,496209,894828,572809,643461,539797,468242,995615,160141,552198,424986,589401,335645,330884,531130,245254,81673,50708,765540,675948,841400,862879,804892,77302,666474,808157,930405,414527,981136,384470,704574,733474,848579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]