SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47140 LIMIT 1 [ RunTime:0.001122s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47140 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323044,907130,1019377,120451,27368,930643,912253,923207,287856,338231,16138,733514,682942,90664,249517,612543,850410,841666,865819,820863,786873,97456,345902,91626,711595,537516,973368,778363,118918,41729,878999,903232,779083,176874,851252,481741,493279,158682,1010196,409482,457044,349878,318094,1035788,992408,807090,172719,133683,202274,934778,318997,123279,1023712,105073,580223,126997,432065,870370,24898,716084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]