SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803701 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803701 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002171,906609,501127,501772,983477,823120,233286,812097,1020625,867096,102523,102952,941233,923459,331710,986015,847518,346966,770814,683129,757731,383535,423094,471416,266716,469755,505394,895919,778022,960221,751106,513541,655720,91541,561772,147491,756299,420816,630486,257154,323960,510513,638857,149824,360101,161918,445022,765752,8478,478004,225760,162272,122170,864834,221726,354495,911949,264052,586775,155856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]