SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489370 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489370 [ RunTime:0.003182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484141,490373,409065,513449,382029,644290,973590,1012238,589000,801070,419245,271602,1037561,149447,1012939,16529,819622,609419,714500,429237,973140,896282,584216,659706,296787,694019,388762,61108,575651,750800,280055,645910,113152,58274,441643,34574,708073,391087,239546,723440,943057,741226,897929,935591,788165,991032,15966,414248,782025,1000515,808547,949857,450084,921306,430321,404991,253377,925293,878471,873386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]