SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322968 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322968 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902788,643442,871501,1039331,664379,482812,582862,366935,49416,262687,86497,608503,500649,408282,467595,483256,765798,572846,777792,279795,120880,1001619,434246,112763,876116,394192,916814,10982,780900,903547,189833,320433,520443,558549,751498,166630,960743,509104,493755,113862,755629,782213,457394,975533,1010616,323873,462255,949434,905863,741958,618471,478173,621034,501331,704860,801141,740182,954015,220367,549807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]