SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72043 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72043 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575641,274590,881991,744443,824729,756394,514153,380872,450972,539107,546159,405978,530414,864001,682294,311167,279707,292609,653394,761834,524799,330282,42516,156348,90433,710731,700791,585237,76540,1021408,199135,357979,615168,756617,537545,394873,177445,388604,553835,75777,397123,495641,942950,90339,433036,791035,491836,803020,490642,888605,941754,436502,292009,98849,508024,812226,393594,548076,1032731,793988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]