SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508728 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508728 [ RunTime:0.003297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955451,54460,764784,192140,739578,595423,467502,52121,463071,488333,340062,397218,11544,500650,740864,107643,55464,678473,684357,658099,471007,763245,257954,46684,645766,804680,364584,624571,130694,958735,680714,986218,1041366,929560,348676,409203,804053,470175,1018845,1009881,70110,771027,309351,815787,176301,150113,532981,530237,1018378,97421,206529,672344,494069,118250,899676,709303,24112,528744,123783,217223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001842s ]