SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428527 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428527 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194814,668412,561448,1006044,262616,705024,836335,673350,203329,574760,206936,948451,360703,346410,198058,850806,80659,7823,163517,541406,308379,818303,690708,718489,126634,530062,866165,204137,522149,819877,970902,1026083,784465,756252,286866,809555,773719,840489,706182,522539,171644,802471,57991,222453,501132,493511,73772,919761,842081,541138,632303,95124,796523,353000,304510,631658,686896,1043969,262129,65787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]