SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437826 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437826 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98045,242470,105276,191481,326262,602824,859360,651900,798636,266986,968923,1010438,533626,403362,774649,1027962,992682,812595,270151,951561,716012,584408,186989,809214,871022,489981,206039,588168,243616,491788,295792,593145,39659,952393,458696,793440,591540,558273,138329,884496,121803,325706,812262,925760,804544,355064,418201,1004228,370018,681201,1017134,847300,382103,263751,546419,633588,860516,937543,139978,1035195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]