SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41939 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41939 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691363,245617,883018,330557,1047928,702367,437813,493930,1034307,427510,834225,725795,635760,311066,125199,887547,1026702,492435,591347,740224,317053,170839,467532,596891,784439,981427,177387,644439,356887,657642,161527,114317,288008,132986,246245,676535,245442,479578,23519,807700,1021620,746217,170233,889078,783478,1002725,2981,86015,783701,818986,277918,788325,480842,494893,187832,128281,198124,372420,32268,974338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]