SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4601 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4601 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20610,176853,1041325,259173,876776,512284,367430,332400,259165,244601,474179,828053,127767,91019,300382,669930,707764,219402,484495,594844,687184,982756,725759,717829,40873,628369,746420,693641,533268,865092,233902,210946,306745,602104,337435,132674,2526,56178,187096,1042133,607789,125628,596105,754153,549245,704528,701288,679853,713902,604038,920797,387013,456707,411596,151384,836093,496010,256366,1009237,450130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000768s ]