SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002778s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594936 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594936 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247012,666601,592149,918256,1046316,418873,595864,550997,582186,347244,891114,668244,648140,487331,553029,1040283,515284,72659,40720,765485,626002,509302,126097,543644,159895,649060,725050,814183,83102,692985,66991,133954,119622,722925,115396,452290,551743,628777,573369,1030609,76392,311156,1034316,14515,574957,188425,363028,993334,898732,288182,708564,555794,519185,459896,979711,90321,216497,353563,880493,851352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]