SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033500 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033500 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746987,797511,128066,686225,356704,305302,408862,190379,667345,585219,577912,129059,65560,524761,631985,876463,143520,10198,61031,1027232,66010,144487,726954,697238,31800,246606,744105,206257,109601,325186,585436,851080,541341,295300,613162,705532,536065,1030214,372055,147075,811787,425068,184571,1031816,335377,284904,477397,1000932,986253,757107,575092,443299,744260,575868,42878,255440,446847,177806,635965,321597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]