SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986713 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986713 [ RunTime:0.002455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411523,1001631,715294,941684,647059,977303,451278,588306,862465,1044480,604294,280718,467557,704822,832007,354067,1000674,191571,519473,904806,662591,806506,264988,462013,700657,383455,220013,964049,646697,451377,232574,49701,298171,559297,1010460,249789,688807,181029,27659,272036,871180,972837,45295,615327,165120,212231,454182,523919,802083,811394,825676,221036,256297,725276,169121,538127,1005502,732680,244255,14985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]