SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 232005 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 232005 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721815,1001603,734460,302829,461052,665315,38387,148039,683254,1020033,493618,385709,590143,287057,402066,462505,749141,90248,143148,20305,1035528,471377,149898,60374,584717,567662,409851,135576,560113,584766,383511,551960,251643,690228,336596,190453,760466,408359,153057,905462,431163,644852,530410,39226,337243,394532,741179,924151,553131,281989,341051,120093,771571,939141,519080,356509,235010,241460,959827,625375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 232005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 232005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]