SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180711 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180711 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5925,1040548,893992,644964,883740,612513,188023,383357,126367,422229,481053,117672,286490,500103,1020947,350537,391220,500219,31081,175899,898541,308679,554753,971589,263800,556854,11280,206138,192265,307239,6947,911766,267257,262187,1017346,549885,50522,584832,230181,1016885,976507,456109,202744,716360,684118,142303,250677,180282,765811,388305,118527,673875,785593,980269,413519,724067,821006,648079,911589,326752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]