SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042071 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042071 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347117,231295,432104,1006646,97244,712136,971355,810770,586993,897077,158516,819896,772087,445855,154393,399202,96802,898345,294937,415662,330248,272487,452443,831410,584398,300187,11154,374305,1033832,631543,756664,457433,840805,125906,498201,306607,740046,963523,966758,138673,202698,28420,651686,274024,501761,849842,308952,48352,348397,706079,163206,199776,1029480,678978,824710,329316,860070,790786,380692,699250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]