SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 695918 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 695918 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147493,458712,737697,76076,528049,535662,797750,976584,798986,168392,435371,704541,137541,771601,1033406,172746,630710,541763,202662,230121,74192,332000,135796,4693,56166,347288,674841,112273,897086,503461,645488,807674,616116,685470,132409,213631,83424,357071,43754,558136,1045479,585743,199400,683151,801388,246858,1038112,5274,443270,462771,103905,901307,457239,72827,277072,578799,684758,536281,936981,555052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 695918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 695918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]